| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
locating the cell that contains the MIN or MAX
working horizontally, I have found the MIN and Max of the data on the row
{example: =MIN(C2:BE2)} I now would like to know what cell in row 2 holds the MIN or MAX. Any suggestions? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
locating the cell that contains the MIN or MAX
In article ,
JR wrote: working horizontally, I have found the MIN and Max of the data on the row {example: =MIN(C2:BE2)} I now would like to know what cell in row 2 holds the MIN or MAX. Any suggestions? Try... =SUBSTITUTE(CELL("address",INDEX(C2:BE2,MATCH(MIN( C2:BE2),C2:BE2,0))),"$" ,"") or =ADDRESS(ROW(C2:BE2),MATCH(MIN(C2:BE2),C2:BE2,0)+C OLUMN(C2)-1,4) -- Domenic http://www.xl-central.com |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
locating the cell that contains the MIN or MAX
Thanks!
Both work fine. "Domenic" wrote: In article , JR wrote: working horizontally, I have found the MIN and Max of the data on the row {example: =MIN(C2:BE2)} I now would like to know what cell in row 2 holds the MIN or MAX. Any suggestions? Try... =SUBSTITUTE(CELL("address",INDEX(C2:BE2,MATCH(MIN( C2:BE2),C2:BE2,0))),"$" ,"") or =ADDRESS(ROW(C2:BE2),MATCH(MIN(C2:BE2),C2:BE2,0)+C OLUMN(C2)-1,4) -- Domenic http://www.xl-central.com |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Locating cell using Hyperlink | Excel Discussion (Misc queries) | |||
| Locating a cell within a macro | Excel Worksheet Functions | |||
| Locating First and Last Cell Containing a Specific Value | Excel Worksheet Functions | |||
| Locating Last Nonzero Cell in a Row | Excel Worksheet Functions | |||
| Locating first blank cell | New Users to Excel | |||
Hybrid Mode
