Fairly simple request for you Excel experts out there.
Can someone please show me how to compile a formula that will place the duplicates in cell B2 if there are two duplicates, and if there are more than two duplicates put that value in B3
For example, in the attached spreadsheet there are two duplicates 63. I would like a formula that would put 63 in cell B2, however if there were three 63's then put that value in B3.
I hope that makes sense.