AnsweredAssumed Answered

Create a new serial number for different unique numbers (Loop and Calculation)?

Question asked by lovelandj on Mar 14, 2018
Latest reply on Mar 14, 2018 by erolst

Hello,

 

I have a list of numbers that I need to have a new serial number created for I have thousands of numbers.  Example below.

 

Here is a sample list of numbers

 

2984

2984

201253

201253

201253

201253

201424

201424

201316

20318

20318

 

I need  the results to be

 

Number Field                Serial Number

2984                                        1

2984                                        1

201253                                       2

201253                                        2

201253                                         2

201253                                        2

201424                                        3

201424                                          3

201316                                        4

20318                                            5

20318                                             5

 

Thank You

Jeremy

Outcomes