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.


.