I have an array formula and trying to add a second item to look for in the INDEX or IF statement.
I have tried OR and COUNTIFS and get nothing or strange numbers.
The BRO_CNT is the column where the names to be retrieved from.
The TIME* is the column where to look for (currently) the letter I. I also want to include a second item... an I with a space ("I ").
Here is the formula:
=IF(COUNTIF(TIME730,"I")>=1,INDEX(BRO_CNT,SMALL(IF(TIME730="I",ROW(BRO_CNT)),1)),"")
I have two other array formulas the look for the second and third occurrences of "I". So the last 1 changes to 2 and 3.
I have tried everything I know and then some for about 2 hours and I am stuck. I will be very grateful if someone can un-stick me. Trying to fix a church spreadsheet.
Bill
Bookmarks