Solved: A list of distinct values

[YasserKhalil]

Hi everybody
I used to that forum and I liked it very much
That's the truth
Everything here has a solution..I found creations here

I want help in this file
I have a list and I want to extract the distinct values

[YasserKhalil]

Is this request difficult???

[Bob Phillips]

Yes, tricky with a formula, to get uniques. Conditional is easy, unique conditional, not so easy.

[shrivallabha]

1. Sort the columns (A & B) in ascending order.
2. In third column assign a formula as

=IF(A1=A2,IF(B1=B2,"Duplicate","Unique"),"Unique")

Remove Duplicates and you have uniques list.

Another will be using Pivot Table

See attachment

[Vivian66]

It works!

1. Sort the columns (A & B) in ascending order.
2. In third column assign a formula as

Remove Duplicates and you have uniques list.

Another will be using Pivot Table

See attachment

[brettdj]

The Duplicate Master addin provides anther way to extract true unique values http://www.experts-exchange.com/A_2123.html

The addin provides options for handling white spaces, case sensitivity and regex matching for advanced string capacity

Cheers

Dave

[mdmackillop]

Dave's add-in is a very useful tool. One piece of advice; change the default Application Scope to "Range", especially if you are using the Delete Duplicates function. It's safer!

[YasserKhalil]

Really it's very useful addin
Thanks a lot for help Mr. Dave and all the moderators in this forum

[brettdj]

> One piece of advice; change the default Application Scope to "Range", especially if you are using the Delete Duplicates function. It's safer!

Very true.

In fact I will add a message to do so on the next update

Cheers

Dave