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

willow1985

Active Member
Joined
Jul 24, 2019
Messages
438
Office Version
2019
Platform
Windows
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
 

Some videos you may like

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
Joined
May 28, 2005
Messages
43,675
Office Version
365
Platform
Windows
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. :)
 

Watch MrExcel Video

Forum statistics

Threads
1,090,186
Messages
5,412,951
Members
403,457
Latest member
mohammad1335

This Week's Hot Topics

Top