You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"z942849" wrote in message
...
This worked. Thank you!

"T. Valko" wrote:

see your later post

--
Biff
Microsoft Excel MVP


"z942849" wrote in message
...
SEE THE EXAMPLE IN THE POST I ADDED AT 9:13 PM

"T. Valko" wrote:

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

--
Biff
Microsoft Excel MVP


"z942849" wrote in message
...
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.


.



.