Excel gurus,
given that I have data in which they're not in order (for this purpose, we can't use 'sort & filter' to have the data sorted - in other words, use the data as is but accomplished via formula), how do I increment a value with criteria for every Nth duplicate.
And this increment also needs to take the MIN value of that criteria as the start, and then increase.
For example, looking at the screenshot,
The original data is column A and column B.
Again, the data is not in order. Thankfully, for each data (A, B or C), the year associated with it is the same.
Therefore, the "minimum" value for A is 2021, B is 2022 and C is 2023 as the "start point".
And for every nth duplicate, in this case the desired is 2 which is found in cell G2, I'd like to increment by 1.
Therefore, taking A for example, the 1st 2 duplicate will be 2021, and if it found the next 2 duplicate, it'll be 2022 and so on.
Increment value with criteria for every Nth duplicate.png
Bookmarks