Quote Originally Posted by Excel Fox View Post
Your first set is clear. Can be done. In your second set, how do you decide that a series has started and ended?
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"?