DougStroud
Well-known Member
- Joined
- Aug 16, 2005
- Messages
- 2,968
Col. A contains a list of values I need to evaluate for duplicates. I have an instance of this value- GW1TIANCRT54 that exists three times, I can search on this value and find it in the respective cells: A5595, A12811, A15600.
My countif function only shows its occurrence of 1 in the results in the corresponding cell where the formula resides-
So-
=COUNTIF(A:A,A5595) displays 1
=COUNTIF(A:A,A12811) displays 1
=COUNTIF(A:A,A15600) displays 1
Which all three cells ref. should show 3. Clicking in the source cell, the values do not show a leading or a trailing space.
Any ideas where to check?
My countif function only shows its occurrence of 1 in the results in the corresponding cell where the formula resides-
So-
=COUNTIF(A:A,A5595) displays 1
=COUNTIF(A:A,A12811) displays 1
=COUNTIF(A:A,A15600) displays 1
Which all three cells ref. should show 3. Clicking in the source cell, the values do not show a leading or a trailing space.
Any ideas where to check?