Find repeted data???

[Guest]

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.....

 

[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

 

[Guest]

Thanks Bif

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