Forum Discussion
Data with Mix of Unique and Duplicate IDs - Create new column that creates Unique IDs for all
I have a data set where I have a mix of unique and duplicate transaction IDs. I am trying to figure out a way to create a MACRO that can complete the following on different data extracts with the sam...
Lets try a little bit dynamic process using MAP() function.
=MAP(D2:D12,LAMBDA(x,x&"-"&COUNTIFS(D2:x,x)))