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
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.