Designating Duplicate Barcodes in a new column

[#1]

Hello, 

I have a data set that contains duplicate barcodes that I would like to have designated based on run date. For example, my data set has originals, repeat 1, and repeat 2 barcodes. I can tell that they are specific repeats based on the date of the run. I have attached an example photo here for reference. I have no problem identifying the duplicate rows but I am struggling to find a good way to holistically mark them with the appropriate repeat. To add to the fun, some samples are only repeated once, others twice. Any formula suggestion or creative row labeling that can be done to help this?

Thank you!

H

[#2 · Accepted solution]

Depending on how you want to label them you could try using any of following functions in formula

• Col Rank()
• Col Cumulative Sum() of 1
• Col Sum() of 1
• Col Number()

[#3]

Thank you! Col Rank worked for what I was trying to do!