change from1,2,3,3,2to1,2,3

excuse me, how what formula can I use if I want to change from1,2,3,3,2to1,2,3

1 Like

This should do it…


/edit - and welcome to the Coda community. :slight_smile:


Thanks! I’ll try it tomorrow morning!

Note that the order of the result depends on the order of the input; if the input numbers were ordered differently, the result would also be different. Like this…

So the output was in increasing order in the previous example purely by chance. If you wish to ensure the output is ordered just pop a sort on the end. Like this…

it worked!! thanks very much!

1 Like