topic Designating Duplicate Barcodes in a new column in Discussions

Designating Duplicate Barcodes in a new column

H_1 — Sun, 11 Jun 2023 00:00:36 GMT

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!

Re: Designating Duplicate Barcodes in a new column

jthi — Wed, 19 Apr 2023 05:27:31 GMT

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

Re: Designating Duplicate Barcodes in a new column

H_1 — Fri, 21 Apr 2023 02:59:08 GMT

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