In cell B2, enter 1, and then type a formula into cell B3, followed by dragging the formula down column B until it aligns with the last row in the Item ID column. Which of the following is the correct formula to type into cell B3?
A. =IF(A3<>A2,1,B2+1)
B. =IF(A3<>A2,B2+1,1)
C. =IF(A3=A2,B2,1)
D. =IF(A3=A2,1,B2+1)
Excel:
Item ID
Repeat Code
35015
1
36634
1
37702
1
37702
2
37702
3
37702
4
37702
5
37702
6
37709
1
37724
1
37767
1
37767
2