Unique lookup of numbers on worksheet and notification if there are repeats

Hello,

I need assistance with the attached worksheet.

On Sheet2 there is a column of numbers, that can repeat.

On Sheet1 in column A, I want to pull a unique of all numbers from Sheet2 Column A.

On Sheet1 in column B, I want have it display if there are repeats for that adjacent value, or if it does not repeat.

I know this would involve a Let(Unique formula, but I have trouble getting the column B to populate the correct value.

I appreciate any help.

Thank you,
Nick