Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locate max value cell
There is probably a simple way to do this, but I can't
find it. I need to locate the cell with the highest value in a range, to dymanically build another named range, based on that loaction. I need a function to return the cell address so I can parse it and use it as the reference in the offset function within my dynamic named range. thanx kpd |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locate max value cell
=offset(A1,Match(max(A:A),A:A,0)-1,0,1,1)
If using offset, no reason to parse anything. -- Regards, Tom Ogilvy "Kevin" wrote in message ... There is probably a simple way to do this, but I can't find it. I need to locate the cell with the highest value in a range, to dymanically build another named range, based on that loaction. I need a function to return the cell address so I can parse it and use it as the reference in the offset function within my dynamic named range. thanx kpd |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locate last cell in column | Excel Discussion (Misc queries) | |||
Formula to locate a cell | Excel Discussion (Misc queries) | |||
How to locate the first digit in a cell, explained | Excel Worksheet Functions | |||
Locate a cell, based on a criteria, then use the 'Cell' command... | Excel Discussion (Misc queries) | |||
how do I locate a cell that provides data to a formula ? | Excel Worksheet Functions |