Formula to Find Sequance/Range

[Robert_Fabian]

​i want the sequence from Filename column to appear as range in the next column

is there any formula to do this
i need a formula to get the highlighted values from the Filename Column

[TABLE="class: outer_border, width: 1007"]
<tbody>[TR]
[TD] Date[/TD]
[TD]Box.no[/TD]
[TD="align: center"]Filename[/TD]
[TD]Range[/TD]
[/TR]
[TR]
[TD="align: right"]1/10/2014[/TD]
[TD="align: right"]1000[/TD]
[TD="align: center"]5000132355[/TD]
[TD]5000132355-5000132363[/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132356[/TD]
[TD] 50001032556[/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132357[/TD]
[TD] 5000132364-5000132385[/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132358[/TD]
[TD] 5000125322[/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132359[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132360[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132361[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132362[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132363[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5001032556[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132364[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132365[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132366[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132367[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132368[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132369[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132370[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132371[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132372[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132373[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132374[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132375[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132376[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132377[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132378[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132379[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132380[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132381[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132382[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132383[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132384[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132385[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000125322[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132386[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132387[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132388[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132389[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132390[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132391[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132392[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132393[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132394[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132395[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132396[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132397[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132398[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132399[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132400[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132401[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132402[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132403[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132404[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132405[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132406[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132407[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132408[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132409[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132410[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]1/10/2014[/TD]
[TD="align: center"]1000[/TD]
[TD="align: center"]5000132411[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

What's the logic behind those results? I can't see it.

 

[Kamolga]

Do you want to regroup by date? Box number? Similar date and box number? Like Special-K99 I do not understand why you have 2 elements in the first line, only 1 in the second, etc.

but the formula to groupe text is =concatenate(C1,"-",C2,"-",C3) or =C1&"-"&C2&"-"&C3

 

[Robert_Fabian]

The Logic is simple
5000132355 is the starting number of the sequence
500013236 is the ending number of the sequence

 

[Robert_Fabian]

The Logic is simple
5000132355 is the starting number of the sequence
500013236 is the ending number of the sequence

The second line contains only one element because there is no other element in that sequence

 

[XOR LX]

But what dictates each sequence? Your values in the Box No. column are all equal, as are those in the Date column.

Regards

 

[Special-K99]

500013236 is the ending number of the sequence?

How do you KNOW that's the ending number of the sequence since that number doesn't occur ANYWHERE in the data?

Can I pick a random number and we use that instead since the number I pick won't occur ANYWHERE in the data either?

 

[Robert_Fabian]

Its the Values in the FileName

 

[Robert_Fabian]

5000132363 is the value i intended to be the last number of the sequence

 

[Special-K99]

Regrettably it's not.

Since given the filename 5000132358 your answer of 5000125322 is not the value of the filename.
Same goes for filename 5000132356, 50001032556 is a completely different number.

And the ending number, how is that determined since most of those are not the filename either.

I'm starting to lose interest in solving this (as yet) undefinable problem. . .