ExcelBanter - How do I get the distinct values in a column & put it in next col

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

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

- - How do I get the distinct values in a column & put it in next col (https://www.excelbanter.com/excel-discussion-misc-queries/214435-how-do-i-get-distinct-values-column-put-next-col.html)

Vidya

How do I get the distinct values in a column & put it in next col

Bob I

How do I get the distinct values in a column & put it in nextcol

1. Use this area to ask the question.

2. If I guess the rest of your question correctly. The answer is,

Edit, Paste Special, Values

VIDYA wrote:

Bob Umlas, Excel MVP

How do I get the distinct values in a column & put it in next

Try Data/Filter/Advanced filter, click Unique Values, then copy the result to
the next column.

"Bob I" wrote:

1. Use this area to ask the question.

2. If I guess the rest of your question correctly. The answer is,

Edit, Paste Special, Values

VIDYA wrote:

All times are GMT +1. The time now is 11:31 PM.