Forum Discussion
If COUNTIF Help
I'm using the following formula in column I to provide me with a value ("1") for every unique instance in column G. The formula actually works great, except for one thing. In cell I88 it gives me a...
As Haytham and Detlef suggested, I will use something like
=IF(AND(LEN(G7)>0,<Condition>), 1, "")
In addition, if you do not care about the actual count of the occurances, but just the first occurance, you may try to compare the current row with the matching row in column G (the row of first occurance should be less than the current row).
=IFERROR(IF(AND(LEN(G7)>0,MATCH(G7,$G$7:$G7,0)+6=ROW(G7)),1,""), "")
If you have 1000 rows, I think using MATCH function will have better performance than using COUNTIF function.
Thank you Willy, Haytham, and Detlef, I greatly appreciate all of your assistance and time.