How to find unique (non repetitive) values in list?

[nichojo]

What is the easiest way to filter a list of all values that repeat?

ie: A, A, B, C, D, D, E turns into B,C,E.

I'm guessing I have to do some kind of count but I'm not a VBA master and don't know the slickest way to do this.

I bow in your VBA expertise. Thanks!

 

[DCrake]

Create a query that groups by the field you refer to and add another column:

Cnt:1

and count on this column. This count the occurances of each value in the field. Then in the condition line enter =1. This will then only display records whre the values only appears once.

 

[SpentGeezer]

You can use use/modify the code on the button in this DB

However this is not what you were after....my apologies!!

 

[SpentGeezer]

Try this one:

 

[nichojo]

Thank you all for your replies - I'm going over your solutions now.

 

[gemma-the-husky]

do you mean you have a number of rows, and you want to find the rows with unique values

or do you mean you have a long text value that you need to analyse?