Solved: Declare a variable and add an incremental value

harry1848 · ‎10-21-2022

I am trying to replace a duplicate value with "duplicate value" +Y

Where Y = X + 1 for all (x=0 to total number of rows in the column)

The goal is to create uniqueness for any cell that contains "duplicate value" by adding an incremental thing to the end of "duplicate value"

ImkeF · ‎10-21-2022

Hi @harry1848 ,
not sure I got your requirement right, but would adding an index-column work?

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

ImkeF · ‎10-21-2022

Hi @harry1848 ,
not sure I got your requirement right, but would adding an index-column work?

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Declare a variable and add an incremental value