Find and Get Column Letter and Row Number from Duplicates in Range of Cells

Trying to get the column letter and row number for any duplicates in a range of cells.

In this example:

A	B	C	D	E	F	G	H
tony	1
steve		1
bruce						1
don		1
peter							1
logan			1
matt				1

Basically the above chart can only have 1 entry per column, otherwise it's an error.

[Column C] shows a duplicate entry (Row 3 aka "Steve" and Row 5 aka "Don").

Need to see if VBA can basically give me an output that says the error is in [Column C], and the rows with the error are found in [Row 3] and [Row 5].

If it'll be easier, just an output of the Cell Address would be great, since formatting it to find the Column/Row wouldn't be a problem.

Any help would be greatly appreciated, thank you.

Originally Posted by jindon

See if this is what you wanted.

Please Login or Register  to view this content.

Thank you jindon!

Works!

P.S.
I was able to use both yours and stnkynt's formulas for parts of my work, so thank you.