View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mitch Powell Mitch Powell is offline
external usenet poster
 
Posts: 37
Default Get list of row #s with certain value

I have a column in which rows will contain the value of "1" when that row
meets a certain criteria. I want to build an ascending list in another
location of the row numbers in that column that contain "1". Any ideas?