Start & End Number Further Converted

[ayazgreat]

I think the question Excel Fox wants to know is... will the second set always be totalling to 100000 or less (you don't say that in its header)?

I have a question of my own for you... Is the 400 shown down Column C always 400 in every cell or will those numbers vary down the column in "real life"?

Thanks for your reply, second set can not always be totalling to 100000, it might be less
And column c is always 400, you can say Qty or count is always equal to 400 in Column c