identify similar cell values

[gxrxba]

I have a column in a spreasheet which has about 10000 values. I jus
want to identify cells which have similar values. For eg if 1 0r mor
cells have the same value, I would like to identify those cells. Wha
function should I be using. Thanks in advance

 

[mzehr]

Hi,
You might want to consider using a helper column. For
instance if your data is all in column I, insert a helper
column in J and copy this formula down in column J.
=IF(COUNTIF(I$1:I1,I1)=1,"Unique","Duplicate")

See also Chip Pearson's website for more info:

http://www.cpearson.com/excel/duplicat.htm#TaggingDuplicate
s

HTH

 

[Dave Peterson]

You could use a helper column of formulas:

=countif(a:a,a1)
and drag down.

You'd see the count of how many times each of those values are in your data.

Depending on what you're doing.

I'd insert a helper column and put =row() in B1 and drag down.
copy|paste special|values (in column b)

Then sort by your real column. The like values will group together. And if you
want to return to the previous sort, just sort by column B.