Auto Removal Of Duplicate Rows

A

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

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
Formating bolded text exclusively. 0
How can I count deviations between two rows? 4
Min Match Function needed 8
change column to rows with a match 3
Arriving at totals 2
Countifs with different restrictions 1
return multiple values when within range (greater than and less than) 11

Top