|
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
|