Start & End Number Further Converted

[ayazgreat]

I can not give guarantee that the data I would receive in quantity 100000 of different non continuous ranges , and for this I am looking for a better solution

[Rick Rothstein]

I can not give guarantee that the data I would receive in quantity 100000 of different non continuous ranges , and for this I am looking for a better solution

I am not sure what I should say here. You do see my problem in trying to write the code though, right?

	A	B	C	D	E	F	G
1	Start Range	End Range	Qty		Result: Target = 2000 or less
2	925874000	925874399	400		Start Range	End Range	Qty
3	925874400	925874799	400		925874000	925875999	2000
4	925874800	925875199	400		925876000	???	2000
5	925875200	925875599	400		811877600	811878799	1200
6	925875600	925875999	400
7	925876000	925876399	400
8	925876400	925876799	400
9	811876400	811876799	400
10	811876800	811877199	400
11	811877200	811877599	400
12	811877600	811877999	400
13	811878000	811878399	400
14	811878400	811878799	400

This is your data and data structure, so if you had the table on the left and you were producing the table on the right in real life, what would you put in the cell marked with the question marks? One idea that came to mind was to put both ranges in the same row...

	E	F	G
1	Result: Target = 2000 or less
2	Start Range	End Range	Qty
3	925874000	925875999	2000
4	925876000 811876400	925876799 811876799	2000
5	811877600	811878799	1200

What do you think of this idea?