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?