| Home |
| Search |
| Today's Posts |
|
#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. |
| 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) | |||
Threaded Mode
