Solved: If duplicate count is

[Nurofen]

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

[Charlize]

Count the occurence for every item in column A and put that number in column C. Sort column C from top to bottom ie. 3 ... 2 ... 1

And what if two items appear the same no of times in column A. Only display the first occurence or all the items.

[Nurofen]

Hi Charlize,

From the list of items from column (A) check occurences, if occurence is 3 or more copy item with count of occurences to sheet2.

If I understand correctly only disply the first occurence with the amount of times it appears in the list.

Thank you for your time

Nurofen

[Nurofen]

Hi,
I found code over at Ozgrid which I added too, to count the 3 or more count in a list.


hope this helps others

Nurofen