Serial Number Logic

[Shushant27]

Hello,

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


[TABLE="width: 147"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]Sr. No.[/TD]
[TD]Code[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]AB005[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]AB005[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]AB006[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]AB007[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]AB007[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]AB008[/TD]
[/TR]
</tbody>[/TABLE]


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.


[TABLE="class: cms_table, width: 147"]
<tbody>[TR]
[TD]Sr. No.[/TD]
[TD]Code[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]AB005[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]AB005[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]AB006[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]AB007[/TD]
[/TR]
[TR]
[TD][/TD]
[TD]AB007[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]AB008[/TD]
[/TR]
</tbody>[/TABLE]

 

[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!