| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Find max value in one column and return the value of corrosponding cell in different column
Ah, I think I did something similar using the OFFSET function
before . . . I have tried using this combined with the MAX function to list the reference value. An example of what I have tried in relation to the data above would be. However I am told my formula contains an error. =OFFSET(MAX(C2:C4),0,-1,1,1) I might be going down completely the wrong road! Any suggestions would be gratefully received Cheers Paul |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maddening Dilemma - Compare each cell within column a to each cell in column b and find unique matches | Excel Worksheet Functions | |||
| Find First Non blank cell than find column header and return that value | Excel Worksheet Functions | |||
| Find a value in a table and return the cell or column reference | Excel Discussion (Misc queries) | |||
| Find max value in a row and return column title | Excel Worksheet Functions | |||
| find Max value in row--return value in same column, different row | Excel Worksheet Functions | |||
Hybrid Mode
