learning_grexcel
Active Member
- Joined
- Jan 29, 2011
- Messages
- 319
I have a column with values like below and their format is text
[TABLE="width: 80"]
<colgroup><col style="width: 80px"></colgroup><tbody>[TR]
[TD="width: 80"]00019[/TD]
[/TR]
[TR]
[TD]00050[/TD]
[/TR]
[TR]
[TD]00080[/TD]
[/TR]
[TR]
[TD]00090[/TD]
[/TR]
[TR]
[TD]000E1[/TD]
[/TR]
[TR]
[TD]000E2[/TD]
[/TR]
[TR]
[TD]000E4[/TD]
[/TR]
[TR]
[TD]000E6[/TD]
[/TR]
[TR]
[TD]000E8[/TD]
[/TR]
</tbody>[/TABLE]
When I write a formula as below to find if there is any repetition in the column, it shows result like 2, 4, 100, 25, etc etc. particularly for the values I mentioned above but in real there is no repetition. The result should have been "1".
= countif(A:A,A1)
Is my formula incorrect or the issue is something else?
[TABLE="width: 80"]
<colgroup><col style="width: 80px"></colgroup><tbody>[TR]
[TD="width: 80"]00019[/TD]
[/TR]
[TR]
[TD]00050[/TD]
[/TR]
[TR]
[TD]00080[/TD]
[/TR]
[TR]
[TD]00090[/TD]
[/TR]
[TR]
[TD]000E1[/TD]
[/TR]
[TR]
[TD]000E2[/TD]
[/TR]
[TR]
[TD]000E4[/TD]
[/TR]
[TR]
[TD]000E6[/TD]
[/TR]
[TR]
[TD]000E8[/TD]
[/TR]
</tbody>[/TABLE]
When I write a formula as below to find if there is any repetition in the column, it shows result like 2, 4, 100, 25, etc etc. particularly for the values I mentioned above but in real there is no repetition. The result should have been "1".
= countif(A:A,A1)
Is my formula incorrect or the issue is something else?