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

  • Thread starter Thread starter z942849
  • Start date Start date
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.
 

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
count the number of rows with entries greater than zero 1
COUNTIF for 2 columns 6
Position of first number in array greater than a given number 4
Conditional Formating if Greater Than or Less Than other column 2
VLOOKUP plus IF 1
Count entries in the column translating to minutes. 5
Minimum Date Greater than Today() 6

Back
Top