NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN
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.
.
.
|