NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT

[z942849]

SPREADSHEET HAS COLUMNS WITH DATA SPREAD OVER 12 MONTHS. IN THE 2ND TO LAST
COLUMN OF DATA, THERE IS NUMBER THAT I WANT TO COMPARE TO EACH NUMBER IN THE
SAME ROW ROW. WHERE EVER A NUMBER IS GREATER THAN THE 2ND TO LAST COLUMN, I
WANT FORMULA I NTHE LAST COLUMN TO PICK UP THE MONTH AT THE TOP OF THE COLUMN
WHERE THE NUMBER IS GREATER.

 

[T. Valko]

What if there's more than one number in the row that's greater?

 

[z942849]

i WANT IT TO PICK UP THE FIRST MONTH WHEN IT IS GREATER.

 

[z942849]

SEE THE EXAMPLE IN THE POST I ADDED AT 9:13 PM

What if there's more than one number in the row that's greater?

--
Biff
Microsoft Excel MVP





.

 

[z942849]

JUST NOTICED THE LAST COLUMN TITLE "EXCEEDS PLAN IN MONTH OF" GOT SKEWED.

 

[T. Valko]

see your later post

 

[David Biddulph]

Please get your caps lock key repaired so that you can stop SHOUTING.

 

[z942849]

This worked. Thank you!

see your later post

--
Biff
Microsoft Excel MVP





.

 

[z942849]

Oops - sorry!

Please get your caps lock key repaired so that you can stop SHOUTING.
--
David Biddulph




.

 

[T. Valko]

You're welcome. Thanks for the feedback!