removing duplicates in a case-sensitive manner

**darkyam** · 08-20-2010, 01:40 PM

DO, I tried posting your formula into a workbook because I was interested to see how it worked. When I did, I got some duplicates mixed in and a couple unique values left out. The most likely explanation is that I did something wrong, but I can't figure out what. Could you please see the attached? Thanks.

Also, I played around with it to find an alternative just so I'd have one for the future and this seemed to work in B2: =IF(SUMPRODUCT(--EXACT(A2,$B$1:B1)),"",A2)

**DonkeyOte** · 08-20-2010, 01:43 PM

Originally Posted by darkyam

I got some duplicates mixed in and a couple unique values left out. The most likely explanation is that I did something wrong, but I can't figure out what.

No - error all mine - the reference to A1 in the REPT should of course be A2 - I will modify
(should test first eh?)

**SIFT-MS88** · 08-20-2010, 03:36 PM

Darkyam, could you provide me with a brief explanation of what's going on in this formula (the one that's B2: =IF(SUMPRODUCT(--EXACT(A2,$B$1:B1)),"",A2)? I drew up an example and used it, and it seems to work, but I need to understand it a little better seeing as I'm using this for research and I can't make any mistakes! Thanks.