Auto Removal Of Duplicate Rows

[Astro]

Is there a formula or way for the system to sort and remove identical rows if
I have the datas like the following:

A B C
1 John
2 Ann
3 Mark
4 John
5 John
6 Mark

End results to show and remove the identical rows:

A B C
1 John
2 Ann
3 Mark
4
5
6

Is it possible? Please help. Thank you...

 

[Stefi]

In 4 steps:
1. Data>Filter>Advanced, List range: $A:$A, check unique records only
2. Edit>Goto>Advanced, Current area
3. Edit>Goto>Advanced, Visible cells only
4. Copy and paste to a new worksheet.

Regards,
Stefi

„Astro†ezt írta: