Formula that identifies distinct values in a list

Hello

I have a spreadsheet with ~ 10,000 rows. What I'm trying to do is have the word "Distinct" display in a column if the number in Column A is a unique value in that column or if its the first occurrenceof that number in the column.


Row A B C
1 1451 Red Sydney
2 1451 Blue Adelaide
3 1452 Green Melbourne
4 1453 Yellow Sydney
5 1454 Blue Melbourne
6 1454 Green Perth
7 1455 Blue Sydney

In the example above I only want to identify and display the word "distinct" for Rows 1, 3, 4, 5, 7

Is there a formula that can do this?

I can't use the Delete duplicate values button as I still need the duplicates for another part of a report I'm working on.

Thanks in advance.

Hi alansidman

The numbers currently could appear anywhere in the list but I could sort them if there's no other way?

Thankyou so much!! You've saved me hours of work