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

Z

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

z942849

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

T. Valko said:
What if there's more than one number in the row that's greater?

--
Biff
Microsoft Excel MVP





.
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

NEED FORMULA TO PICK UP TOP OF A COLUMN WHEN CERTAIN CRITERIA MET 3
Problem with formula for finding last greater than/less than or equal to value 2
Need Help with a VBA subroutine 0
return multiple values when within range (greater than and less than) 11
count the number of rows with entries greater than zero 1
Help. Trying to do the opposite of VLOOKUP 3
Vlookup display value if greater than a number 0
Position of first number in array greater than a given number 4

Top