# Determining Next sequence of number if there are 7 sequences each starting with a letter

#### willow1985

##### Active Member
Thank you so much Peter, this formula is much better. Turned out the original gave me a VALUE# error when I entered "B" in the reference cell. I am assuming it is because B is the only number sequence with 1 letter and 4 numbers where the other 6 letters only have 3 numbers.

Thank you very much for this formula and it is faster!

Cheers,

Carla

### Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

#### Peter_SSs

##### MrExcel MVP, Moderator
Thank you so much Peter, this formula is much better. Turned out the original gave me a VALUE# error when I entered "B" in the reference cell. I am assuming it is because B is the only number sequence with 1 letter and 4 numbers where the other 6 letters only have 3 numbers.

Thank you very much for this formula and it is faster!

Cheers,

Carla
You're very welcome. Thanks for the follow-up.