Serial Number Logic

[Shushant27]

Hello,

I am trying to have a serial number logic, as below:-

Sr. No.	Code
1	AB005
	AB005
2	AB006
3	AB007
	AB007
4	AB008

<colgroup><col><col></colgroup><tbody>
</tbody>

Column 1 is Sr. No., Column 2 is Code Number.
Now, I am need that Sr. no. should ignore while dragging, if the cell next to it is same as the cell above it.

please help/ suggest some trick/ logic

Shushant

 

[AliGW]

Try this:

=IF(A2="",B1,"AB"&TEXT(A2+4,"000"))

 

[Shushant27]

I want to have serial numbers, based on the "Code" Column.

Sr. No. Should go 1,2,3......, but if cell in the "Code" column is same as above it like in example: AB005 comes 3 times. Then it should consider it only once in the serial number.

Sr. No.	Code
1	AB005
	AB005
2	AB006
3	AB007
	AB007
4	AB008

<tbody>
</tbody>

 

[AliGW]

OK - sorry - I'll try again.

 

[AliGW]

Try this in A2 copied down:

=IF(B2=B1,"",COUNT(A$1:A1)+1)

 

[Shushant27]

Thank You,

It Worked

=IF(B2=B1|""|COUNT(A$1:A1)+1).

 

[AliGW]

You're welcome!