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?

[ayazgreat]

The result target twenty thousand or less

[Rick Rothstein]

The result target twenty thousand or less

Stop looking at the numbers I am using and look at the structure of the table instead. I could construct a table for 20000, but all that would involve is many more rows of 400 each... I am trying to keep the table small for posting purposes while trying to get you to tell me how to handle the structural problem that occurs when a continuous set of ranges of 400 total less than the target number. Look at my last post, make believe 2000 is a possible target and tell me how you want the program you want me to write to handle the problem shown; namely, that the continuous set of ranges of 400 total less than the target number of 2000 in my chart but which could just as easily be 20000 as well.

[ayazgreat]

Stop looking at the numbers I am using and look at the structure of the table instead. I could construct a table for 20000, but all that would involve is many more rows of 400 each... I am trying to keep the table small for posting purposes while trying to get you to tell me how to handle the structural problem that occurs when a continuous set of ranges of 400 total less than the target number. Look at my last post, make believe 2000 is a possible target and tell me how you want the program you want me to write to handle the problem shown; namely, that the continuous set of ranges of 400 total less than the target number of 2000 in my chart but which could just as easily be 20000 as well.

Rick Rothstein what do you think ? I do not understand how to handle the structural problem that occurs when a continuous set of ranges of 400 total less than the target number, as i let you know that I receive data in this form (mix up of continuous and non continuous ranges), you think there is no way to handle this knd of data ?

[ayazgreat]

So excel gurus you think that there is no solution for query I asked

[Excel Fox]

Ayaz, if you look at what Rick is implying, there has to be a logic to the way your data is laid out for it to be logically split and/or combined. If that is not consistent, it would be difficult for a logic to be developed around it. If there aren't enough records to be grouped to form the target sum, how do you want that to be handled? If you can get that across, then only can the solution be aptly developed

[ayazgreat]

As I have replied before that I receive daya in this form so how should I change or make further development in the same?