formula required.

[Mohini79]

Hi,

In one column I have duplicate values. 

I want to add one formula if duplicate then Y else N

Column name is Receipt No

Thanks in advance

[BS_THE_ANALYST · Accepted solution]

@Mohini79 
If we see the value the first time, I have not flagged it. If we see any duplicates below it. It gets flagged:

[alexnajm]

@Mohini79, @BS_THE_ANALYST;'s solution works great! Otherwise you could use the Unique Value method of the Tile tool and use a Formula to mark anything greater than 1 in the Tile_SequenceNumber column as a Duplicate - if you need them to remain in the original order, a RecordID tool at the beginning and a Sort at the end will work well.

[Mohini79]

Great,

Thanks for the solution