Entry Number change with Change in Narration

[Sarfraz Khan]

Dear Sir,

Ref to attached sheet I want to change the entry number with changes in narration.

 

[eibi]

Try this in cell d2:

=IF(A2=A1,"",A2)

Drag down to fill.

See attached.

 

[Sarfraz Khan]

Try this in cell d2:

=IF(A2=A1,"",A2)

Drag down to fill.

See attached.

Dear Sir,
It didn't work, because I want to change entry number basis on narration.
eg : my entry number is BBE0000699 in front of narration "FAST CONTAINER SERVICE-3791880-MY Container Service" I want entry number BBE0000699 be the same till the narration is remain same, once the narration "FAST CONTAINER SERVICE-3791824-GEET CS MOVERS" is started then next entry number BBE0000700 should come.

 

[eibi]

OK -- I misunderstood your requirement.

Try this array formula in cell A2:

=698+SUM(1/COUNTIF($B$2:B2,$B$2:B2))

Also, change your cell formatting to:

"BBE"0000000

See attached.