| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT
see your other post
-- 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula w/two columns to add the greater number | Excel Worksheet Functions | |||
| DISPLAY A FIXED NUMBER IF GREATER THAN FORMULA RESULTS | Excel Discussion (Misc queries) | |||
| countif formula to find the occurances of a number that is greater than one number but less than another | Excel Discussion (Misc queries) | |||
| Formula for number of entries in colum that are greater than 2 hr | New Users to Excel | |||
| Way of making an object with a greater number be given a point.... | Excel Discussion (Misc queries) | |||
Linear Mode
