Hello all,
See attached worksheet. I'm trying to find a way to identify the sub-range within the range of column C (C2:C31) where the sum of the fewest number of consecutive cells is at least 20% of the sum of the entire range of column C (C2:C31). I've all but given up on a solution.
Any ideas?
Thanks!
Bookmarks