Cumulative in one cell

%3CLINGO-SUB%20id%3D%22lingo-sub-1503559%22%20slang%3D%22en-US%22%3ECumulative%20in%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1503559%22%20slang%3D%22en-US%22%3E%3CP%3ECell%20A2%3D50%20and%20range%20B1%20to%20Z1%20has%20value%205%20in%20each%20cell.%20My%20question%20is%20to%20get%20column%20name%20till%20when%20cell%20A2%20value%20is%20getting%20complete.%20Its%20like%20cumulative%20sum%20in%20one%20cell.%20I%20want%20to%20do%20it%20with%20excel%20formula%20kindly%20suggest.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1503559%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

Cell A2=50 and range B1 to Z1 has value 5 in each cell. My question is to get column name till when cell A2 value is getting complete. Its like cumulative sum in one cell. I want to do it with excel formula kindly suggest.

2 Replies
Highlighted

@Vijay_Kumar605 I suspect that your real issue is not as straight forward as you describe. But I think that the attached file contains a quick-and-dirty way to achieve what you described. However, it uses some helper rows in order to determine the column in which the sum of the preceding cells becomes greater or equal to the value in A2. The end result is in A4.

Highlighted

Hello Mr. Riny,

 

Thanks for quick response. It is true that my requirement is not as same as I mentioned in my question. But As it was my first time to ask any question on this forum, was not sure I will get any answer. So I simplified my requirement and asked. However your answer is really helpful and shown me new way to do cumulative sum. Thanks once again for your help.