Hi hope someone can help
I have two columns and the data is sorted in ascending order using column A. What I would like to do is find the largest sum of consecutive numbers in column B (whether that is a single cell, or all the cells). Looking at the data below I have manually highlighted the highest sum of consecutive cells. Is there anything I can use that would do this automatically?
See attachment.
I am sure it is dead easy I can't do it
cheers!
Bookmarks