ExcelBanter - Double entry problem

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

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

- - Double entry problem (https://www.excelbanter.com/excel-discussion-misc-queries/41008-double-entry-problem.html)

Jesper Perregaard

Double entry problem

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

Gary's Student

Click the top of the list.
pulldown - Data Filter Advanced Filter
Check copy to another location and unique records only
--
Gary's Student

"Jesper Perregaard" wrote:

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

All times are GMT +1. The time now is 02:29 PM.