Nurofen
10-29-2007, 12:05 PM
Hi,
I have searched but i can only find if duplicate then delete.
I would like to be able to search column A:A for duplicates that occur 3 or more times and then copy to new sheet with the count.
Also in column B:B a search that will copy the data that occurs the most second most and third most.
Thank you for your time
Nurofen
I have searched but i can only find if duplicate then delete.
I would like to be able to search column A:A for duplicates that occur 3 or more times and then copy to new sheet with the count.
Also in column B:B a search that will copy the data that occurs the most second most and third most.
Thank you for your time
Nurofen