Thread: If Then
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ADean ADean is offline
external usenet poster
 
Posts: 2
Default If Then

I'm trying to find a formula that will continue to search for a row that
meets the specified IF criteria without returning the rows that do not. i.e.
I want the below reference range to provide the following based off of an IF
statement. (the actual solution needs to work for hundreds of rows)
1 Cat
2 Dog
3 Cat
4 Dog
5 Cat

Results:
1
3
5