Thread: To get row id
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] sia.bhavaraju@gmail.com is offline
external usenet poster
 
Posts: 11
Default To get row id

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