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