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
Solved! Go to 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:
@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.
Great,
Thanks for the solution