is unique, and if there are duplicates, assigns the number of the duplicate. An example is shown below. The first two items are unique so the repeat code is $1.$ However, Item ID $37704$ is listed six times, so the codes are assigned from $1$ to $6,$ and so on$.$ Explain how to assign the correct code using an

Click the icon to view the Item ID and Repeat Code data the correct formula to type into cell B$3?$

A

B$.)=(A2,1,B2+1$

C$.)=(A2,B2,1$

D$.$