Forum Discussion

harry1848's avatar
harry1848
Frequent Visitor
3 years ago
Solved

Declare a variable and add an incremental value

 

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"

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

     

1 Reply

  • ImkeF's avatar
    ImkeF
    Community Champion

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