To get row id

[sia.bhavaraju]

Hi,

I have a worksheet which contains some data. I calculate the
min,max,stddev and mean for those columns. I have a particular column
by name npv for which i calculate these four calculations. I want to
get row id for these 4 values of npv. Like i have the first column as
row id which starts from 1 and goes until the last number. How would i
get the row id for max npv or min npv from the excel. I would
appreciate suggestions for this question.

Regards,
Ram

 

[Mike H]

Hi,

To find the maximum value in a range try

=MIN(IF(A1:A1000=MAX(A1:A1000),ROW(A1:A1000),""))

and for the minimum
=MATCH(MIN($A$1:$A$1000),$A$1:$A$1000,0)

Both are array entered by pressing Ctrl+Shift+Enter NOT simply enter. If you
do it correctly Excel will put curly brackets {} around the formula. You
CAN'T type these yourself.

Mike