| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to find max cell location
I have been searching for hours with no resolution...
I need to find the cell location, not the value, of the maximum value in a range. I am using Excel 2003. I have tried: =MATCH(MAX(B9:AK9),B9:AK9) and the result I get is 15 doesn't help me...the location I need is N9 can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find cell location in a large list | Excel Discussion (Misc queries) | |||
| How to find out the cell location | Excel Discussion (Misc queries) | |||
| Find & replace a value in an unknown cell location | Excel Discussion (Misc queries) | |||
| find cell location of max value in column | Excel Programming | |||
| Find Cell and Copy adjacent value to another location | Excel Programming | |||
Threaded Mode
