ExcelBanter - Duplicates and horizontal

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Duplicates and horizontal (https://www.excelbanter.com/excel-discussion-misc-queries/207253-duplicates-horizontal.html)

NirOrtal

Duplicates and horizontal

Hi

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

Sheeloo[_3_]

Duplicates and horizontal

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

"NirOrtal" wrote:

Hi

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

NirOrtal

Duplicates and horizontal

Thanx

"Sheeloo" wrote:

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

"NirOrtal" wrote:

Hi

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

All times are GMT +1. The time now is 03:22 PM.