Find repeted data???

K

kiran

Hi All,
in excel how to find the repeted data i mean to say i have few names like
this in a column...

fhacsarp.p
fhardarp.p
fhargrrp.p
fharigrp.p
fhbkdcrp.p
fharsgrp.p
fhartnrp.p
fharttrp.p
fhbkcorp.p
fhbkdcrp.p
fhbkdurp.p

i even have repeted name how do i find out the repeted name.....
 
B

Biff

Hi!

Here's one way:

Assume your data is in column A, starting in A1. In B1
enter this formula and copy down as far as the list in
column A:

=IF(COUNTIF(A$1:A$11,A1)=1,"",COUNTIF(A$1:A$11,A1))

Biff
 
K

kiran

Thanks Bif

Biff said:
Hi!

Here's one way:

Assume your data is in column A, starting in A1. In B1
enter this formula and copy down as far as the list in
column A:

=IF(COUNTIF(A$1:A$11,A1)=1,"",COUNTIF(A$1:A$11,A1))

Biff
Click to expand...
 
Top