PDA

View Full Version : Solved: A list of distinct values



YasserKhalil
06-18-2010, 12:40 PM
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
06-18-2010, 01:37 PM
Is this request difficult???

Bob Phillips
06-18-2010, 03:59 PM
Yes, tricky with a formula, to get uniques. Conditional is easy, unique conditional, not so easy.

shrivallabha
06-18-2010, 11:41 PM
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
06-21-2010, 02:26 AM
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
06-26-2010, 11:36 PM
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
06-27-2010, 11:23 AM
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
06-27-2010, 11:52 AM
Really it's very useful addin
Thanks a lot for help Mr. Dave and all the moderators in this forum

brettdj
06-27-2010, 05:07 PM
> 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