How do I clean up (besides sorting and doing it manually) duplicate entries in Excel? For example, I have: A B 1 bill cas 2 bill vm 3 sue vm 4 sue cas 5 sue vm 6 sue vm And I want to use a formula or something to pull out all dups in columns A and B so I can have for the results: 1 bill cas 2 bill vm 3 sue vm 4 sue cas I cleaned up the dups in A that but also kept the different fileds in B that were not dups themselves. Did I explain correctly?

The easiest way to do this is to concatenate the fields together, then check for dup's of the concatenation. You can then write a simple routine to check for dup's and delete. There are many ways of doing this: 1) append a concatenation field (say in column C). Sort by it. Run down the list deleting rows whenever two identical ones are next to eachother 2) fill an array with records, but keep rechecking the array to see if the next record has been used before. The rewrite the cells straight from the array 3) loads more. honestly. If you need more help, post back. Tom

That works great! You are the man! I have been tyring for weeks to do this (clean dups) and this is the best way I have done it!

Very glad to have helped! Tom