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

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:

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