Find repeted data???
 

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

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

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

Thanks Bif

"Biff" wrote:

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

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