Fast way to check if column contains duplicates

**richarddd** · 11-20-2008, 05:58 AM

Hello

Im trying to create a fast way to check if my column contains duplicates of my value. If it contains a duplicate, i want to return "yes" and if not "no".

I've managed to create a function like this but its to slow:

Please Login or Register  to view this content.

This will check if the numer in B2508 has a duplicate.

Any way how to "improve" this?

Best Regards
/Richard

**oldchippy** · 11-20-2008, 06:15 AM

Hi,

Do you need to reference the whole column of B, or is the range smaller?

**EdMac** · 11-20-2008, 06:16 AM

If you use the search facility within the forums, you will find that this question has been asked many times and that suggestions are available.

**richarddd** · 11-20-2008, 06:20 AM

Originally Posted by oldchippy

Hi,

Do you need to reference the whole column of B, or is the range smaller?

Hello!

The whole column. There shoudn't be any duplicates in the column. (Well, it's only nessisary to check from the value i wish to check and above, if you know what i mean)

**oldchippy** · 11-20-2008, 06:25 AM

If you want to prevent duplicate entries, perhaps this

http://www.cpearson.com/excel/NoDupEntry.aspx

**richarddd** · 11-20-2008, 07:24 AM

Originally Posted by EdMac

If you use the search facility within the forums, you will find that this question has been asked many times and that suggestions are available.

Tryed that but havn't found what i was looking for.

Originally Posted by oldchippy

If you want to prevent duplicate entries, perhaps this

http://www.cpearson.com/excel/NoDupEntry.aspx

I dont wish to prevent to enter duplicates, just know which value thats duplicated with a "yes" or a "no" value, so i could check them out later on. My formula works, its just thats its extremly slow when you have about 3k diffrent values at hand