Find duplicate values in column & return to it

Hi Experts,
Any simple function available to find duplicates and return/annotates the same number ?
e.g
1,2,3,4,4,7,8,9,10, are in one column

In ANY blank cell I am looking to see function that give me 4 as result

Thanks

KARNIK

maybe this one: =IF(COUNTIF($A$1:$A$10,$A$1:$A$10)>1,$A$1:$A$10,"")

Hi Sandy666,
Thanks for addressing my issue.
Function results in to blank, may be it needs fine tuning?
Request please give second glance
Thanks
Karnik

You said you want to see duplicated values only so ... see attached file:

Thanks Sandy 666
it works when copies down!
cheers
Karnik