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

"z942849" wrote in message
...
i WANT IT TO PICK UP THE FIRST MONTH WHEN IT IS GREATER.

"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.


.