Double entry problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,

I have a worksheet where double entries occur, e.g.

Colum A

Smith
Smith
Jones
Andy
Smith
Andy

How can I make a routine that sorts out only the unique entries in a new
colum, e.g.

Colum B

Smith
Jones
Andy

Thanks,

Jesper Perregaard
 
Click the top of the list.
pulldown - Data > Filter > Advanced Filter
Check copy to another location and unique records only
 
You must log in or register to reply here.

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

Text to Colums 1
Matching Names 5
Macro to pull data with criterea for placement on a new sheet 7
How to get totals 4
Excel Concatenate addresses in Excel but avoiding blanks, and line breaks 6
Duplicates 7
Inserting rows and rearranging data using VBA 6
Search a worksheet, extract rows using a list from another sheet 9

Back
Top