Hello
I want to know how do I find the cell reference that contains the
minimum value between a range of cells.
I know I can use the function =min(A1:A100) but this returns the
minimum value.
I want to know where this minimum is.
And, if I know it's A50 how do I use the cell B50, let me explain: I
have some dates in B cells and some values in A cells. I want to know
when the minimum did occur (this should be a date in B cells)
Thanks a lot


--
fadsnet
------------------------------------------------------------------------
fadsnet's Profile: http://www.excelforum.com/member.php...o&userid=37254
View this thread: http://www.excelforum.com/showthread...hreadid=569726