Find Sequences of any ranges

Question

I need to find number sequence ranges in below number list. there are diffent number serials in the list

pls assist to find a foumular or rangers

sample

Start Number - End number

9402970201041150 - 9402970201041239

tks isuru

Please clarify your specific problem or provide additional details to highlight exactly what you need. As it's currently written, it's hard to tell exactly what you're asking. — Community, Jun 08 '22 at 11:56

score 0 · Answer 1 · answered Jun 08 '22 at 14:21

0

see:

=INDEX("9402970"&SEQUENCE(C2-C1, 1, 
 REGEXEXTRACT(TEXT(C1, "0")&"", "\d{9}$")*1))

answered Jun 08 '22 at 14:21

player0

1 Answers1