I have searched on google but I couldn't really find anything to answer my question.


I have 3000 Computer asset numbers and I want to find duplicates in 2 separate columns.

Does anybody know a formula that will:
a) highlight them
b) only show duplicates and hide the others?

I assume a vlookup will do this but I have no idea, I only fix computers, not actually use the applications I install

Thanks for any help with this matter.

Dan

http://www.mrexcel.com/tip063.shtml
http://www.google.com/search?q=find+...x=&startPage=1

Should get you started ..

Surely it couldn't be that easy ..

__________________
[SIGPIC][/SIGPIC]
Should have bought an STI

Thanks for that, however if you look at most of those links they want $29.95 to get some fucked up plugin to do it for you.

I will check out mrexcel though.

Thanks for the speedy response.

EDIT: Mr Excel FTW

Thanks
Exactly what I needed.

Here i was thinking someone was looking for a 'hyundai' excel guru

__________________
www.facebook.com/technikcaraudio
www.cardomain.com/id/boostndb

Could be done easily using vba. Loop through on column and add to hashtable. Then loop over the other and check if exists in hash you got duplicate. This is the most efficient way but dunno if you have hash tables in VBA.

Could always loop through a column and for each row loop through col b and find a match. But this in your case would be 3000*3000 iterations so 9003000 iterations the first way would be 3000 + 3000 = 6000.

Otherwish I could whip up a little program that does it for you. Take me 10 mins.

Cheers

Just realised my post makes no sense. Hah long day at work does this to you.

if you send me the .xls file i can sort it for you.. basically to hard to explain...

you will need to run a vlookup

define your name for one column eg. "LIST"

=VLOOKUP(cell you wanna compare,LIST,2,FALSE)

if in the cell it pops up with #N/A then it is not a duplicate and if it pops with the data then it is a duplicate... you can then sort by name

i just sorta explained it and it prob makes no sense... i can sort it for ya if ya want champ