Unique data
Hi
Enter this formula in an unused column and copy down.
=COUNTIF(A:A;A1)
Unique text result is one, for duplicates both entries will have the value 2
(or 3 in case of 3 identical strings).
Hopes this helps.
....
Per
"Shah Alam" skrev i meddelelsen
...
Dear Experts,
Suppose,
'Col A' has a lot of text data, how can i find it out the duplicate data.
thanks
|