minimum value in a column, which row no?
Hi,
Try this
=MATCH(MIN($A$1:$A$100),$A$1:$A$100,0)
Now if your range starts other than in row 1 add an offset
=MATCH(MIN($A$10:$A$100),$A$10:$A$100,0)+9
The offset iss 1 less than the start row.
Mike
"Darius" wrote:
Using
Min (range) I can find the minimum value of a column of data. But how can I
find which Row number it belongs?
|