Count duplicates

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!!

What is a duplicate? If one value appears 3 times, how many duplicates is it?

Good morning,

Actually the same when you use the function remove duplicates in excel. You get a message how much duplicates were removed. It is that number I need to be pasted in a cell on another sheet (same workbook)

Thanks

The below counts unique values
=SUMPRODUCT((range<>"")/COUNTIF(range,range&""))

so
=SUMPRODUCT((a1:a1000<>"")/COUNTIF(a1:a1000,a1:a1000&""))


counta(a1:a1000) would give total values

so counta(a1:a1000)-SUMPRODUCT((a1:a1000<>"")/COUNTIF(a1:a1000,a1:a1000&""))