Dear Experts
i have list of reapted name. and i want a list which have name only one time
if any new name add in list then it will add name.
example
List of Repeated name:
A
B
H
E
A
H
A
H
I
A
B
I
List should be this type:
A
B
H
E
I
thanking you
--
Sudhir Verma
Asstt. Mngr. A/c's
$$ How to short repeated name
Dear Experts
i have list of reapted name. and i want a list which have name only one time
if any new name add in list then it will add name.
example
List of Repeated name:
A
B
H
E
A
H
A
H
I
A
B
I
List should be this type:
A
B
H
E
I
thanking you
--
Sudhir
:20:32 AM
Subject: $$Excel-Macros$$ How to short repeated name
Dear Experts
i have list of reapted name. and i want a list which have name only one time
if any new name add in list then it will add name.
example
List of Repeated name:
A
B
H
E
A
H
A
H
I
A
B
I
List should
you are talking about List of Unique Values
in Excel 2007 you can use REMOVE DUPLICATE
in Excel 2003 use : Advanced Filter (Copy to another range / UniqRecords
Only / Criteria = blank)
or you can use a mega-formula see my example workbook at
http://www.box.net/shared/o614r2gnrj
On Tue, Mar