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...
Hi Kelly,
Sorry, but your explanation of the issue isn't clear enough!
Anyway, I have these two formulas for you which could help you:
Use this if you want to hide all the duplicate values including the first instance:
=IF(COUNTIF($G$7:$G$1000,G7)=1,1,"")
And this if you want to hide all the duplicate values excluding the first instance:
=IF(COUNTIF($G$7:G7,G7)=1,1,"")