Sep-04-2021, 10:58 PM
(Sep-04-2021, 10:37 PM)SamHobbs Wrote: There are a couple of details that should be clarified.
First, can you assume the data is sorted by the first column? Can you rely on all duplicates to be together?
Second, is it possible for there to be more than one duplicate? If so then what do you need to do for more than one duplicate?
Yes the data is sorted by the first column, all duplicates will be together and at max there will only be one duplicate. For clarification, the first column will look something like 1,2,3,4,5,5,6,7,8,8,9,9,10, etc. What I need is the data in the corresponding row of the first time one of the duplicates is mentioned, so 1,2,3,4,5,5,6,7,8,8,9,9,10 (the bolded rows are all I need).