| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Subtract a max value from a row then copy that columns title?
Hi,
I've been trying this with variations of the =MAX function but cant get it to work... :-( I have a row of text entries as column titles in every second column, e.g: A1, C1, E1, G1 etc Below those text titles, I have numeric values. e.g: A2, C2, E2, G2 etc I want to get the highest number from row 2, and then display the column title from that row...... .......any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| hOW DO i SUBTRACT COLUMNS IN EXCEL? | Excel Discussion (Misc queries) | |||
| hOW DO i SUBTRACT COLUMNS IN EXCEL? | Excel Discussion (Misc queries) | |||
| How do I subtract two columns from the same total? | Excel Discussion (Misc queries) | |||
| subtract amounts from different columns? | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Threaded Mode
