Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Finding the location of MAX value in column
I know this is a very simple question but I have found the MAX value in a
column using the usual formuls, the only problem is I don't know it's location and I need to relate back to another value on the same row. The column contains nearly 3000 readings so I don't fancy trawling through them all tring to find it! Can anyone please help asap Thanks a million |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Location of Maximum Value in 2D Array | Excel Discussion (Misc queries) | |||
Finding Location of Maximum Value in 2D Array | New Users to Excel | |||
Finding Location of Maximum Value in 2D Array | Excel Worksheet Functions | |||
finding cell location | Excel Discussion (Misc queries) | |||
finding rightmost location of a character | Excel Worksheet Functions |