Excel, create a list of distinct unique values

Question

so I'm trying to create a list of values which are unique.

Sorry couldn't workout how to post it as a table, so its an image! But basically I want column1 whittled down to the results in the Desired Result column. Any entry which exists twice or more should be removed. Only the more unique are to be left. I see there are tools in Excel, but none give me this result. A search on the internet shows very complex solutions to this, is it really as complex? what would be the solution here.

EDIT: Thought I'd add, Column A could be two columns. basically I am trying to maintain a list by adding new values to it. but because I will export this list I only want the new unique values. So When newlist is added to existing list I only want the unique entries left over.

understandable steps to a solution based within excel. i.e. no plugin, and I'd prefer to avoid VBA. — Purplemonkey
– Purplemonkey, Commented Oct 8, 2018 at 8:28

user4039065 · Accepted Answer · 2018-10-07 20:40:43Z

3

try this in B2 and fill down.

=INDEX(A:A, AGGREGATE(15, 7, ROW($2:$8)/(COUNTIF(A$2:A$8, A$2:A$8)=1), ROW(1:1)))

answered Oct 7, 2018 at 20:40

user4039065

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel, create a list of distinct unique values

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related