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

willow1985

Active Member
Joined
Jul 24, 2019
Messages
456
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

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
44,415
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,095,320
Messages
5,443,770
Members
405,251
Latest member
shanezer

This Week's Hot Topics

Top