How to go about getting the following result?

[Chrisa1956]

Hello All,

I have a customer list with addresses attached to a customer number. What I need to do is give each address associated with a customer it's own code start with 51 and then go on incremental by one until the next customer.

So if the customer has one address to the customer number, the code would be 51. If two addresses per customer, then I would get 51 & 52. So on and so on for as many addresses exist. The largest customer has 772 addresses.

See example below. Let me know if I don't make any sense.

Customer #	Code	Street	City	State	Zip Code
11111​	51​	203 Pearl St	Reeseville	West Virginia	53579​
11111​	52​	4343 W Glendale Ave	Glendale	Arkansas	85301​
22222​	51​	12678 Dix Toledo Rd	Southgate	Michigan	48195​
33333​	51​	601 Fulton Ave	Sacramento	California	95825​
33333​	52​	5443 E La Palma Ave	Anaheim	California	92807​
33333​	53​	518 Capitol Way S	Olympia	Washington	98501​
33333​	54​	10865 W Indian School Rd	Avondale	Arkansas	85392​

 

[fjns]

Hi, the formula for B2:
=IF(A2=A1,B1+1,51)
2. step: AutoFill down

 

[etaf]

IGNORE _ NOT WORKING