Hi,
I have a long list of random numbers in a column ( e.g. column C ). Column C grows dynamically as new random values are copied/ appended at the last of existing list.
I want to find duplicated values in the whole(ever-growing) list and to copy each duplicated item in a another location on same sheet. If value '12345' occurred twice in the list, I want to display that count. For unique values take no action. Below is an example:
71658
71510
71658
71602
71658
71774
71667
71699
71700
71600
71585
71510
71742
71632
71649
71639
71594
Now I want to display this somewhere in same sheet
duplicates found= YES
Total duplicates= 5
value 71658 appeared 3 times
value 71510 appeared 2 times
Any suggestions?
Bookmarks