Good morning,

Next scenario.

I have sheet "X" with 10 columns with data, each column contains +1000 numbers.
I want to check if there are duplicates in every column (separated of each other), and the amount of duplicates should be on sheet Y

So on Sheet Y I need to see:
Column A: 10 (amount of duplicates)
Column B: 45(...)
....

Thx in advance!!