Auto Removal Of Duplicate Rows
 

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

Auto Removal Of Duplicate Rows
 

In 4 steps:
1. DataFilterAdvanced, List range: $A:$A, check unique records only
2. EditGotoAdvanced, Current area
3. EditGotoAdvanced, Visible cells only
4. Copy and paste to a new worksheet.

Regards,
Stefi

€žAstro€� ezt Ã*rta:

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