Trying to create an Order # sequence

[nyrob609]

Hi All,

I am trying to create order # column using multiple fields but I keep on getting an error what am missing in the formula. I want to give an order 1 2 3 and restart 1 once the cells don't equal each other.

=IF(Or(B3=B2,and(D3=D2),A2+1,1)) A2 = value is 1

I probably going about the wrong way.

Any assistance will be appreciated.

Thank you

[Andrew-R]

Your AND function only has 1 field in, so that's just a straight comparison.

If you want the numbers to restart at 1 when B2<>B3 or D3<>D2 then the formula will be:

=IF(AND(B2=B3,D2=D3),A2+1,1)