07-02-2020 10:15 PM
07-03-2020 12:59 AM - edited 07-03-2020 01:00 AM
@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.
07-03-2020 01:53 AM
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.
by aslabacksabo on May 29, 2020