Duplicates and horizontal

N

NirOrtal

Hi

How can I copy list of names from A1:A10 to A15: J15 and eliminate the
duplicates?
 
S

Sheeloo

Step 1
Data|Filter|Advance Filter|Click on Unique Records only
Step 2
Select the filtered List
Step 3
Go to A15
Choose Edit|Paste Special|Transpose
 
N

NirOrtal

Thanx

Sheeloo said:
Step 1
Data|Filter|Advance Filter|Click on Unique Records only
Step 2
Select the filtered List
Step 3
Go to A15
Choose Edit|Paste Special|Transpose
Click to expand...
 

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

How to delete ALL cells containing the same data 0
How to delete ALL cells containing the same data --- REVISED 0
Black Lines appearing over table borders 0
How to sync OL365 contacts and calendar to iPhone without iTunes? 1
Copy addition formula of non-consecutive horizontal cells 2
Want To Shrink Formula 1
Separating Duplicates?? 2
Accessibilty - how to open doc with keyboard? 0

Top