Hi Guys,
I have been stuck on this one for a little while and would really appreciate your help.
I have attached a SAMPLE WORKBOOK to speed things up. The problem is as follows:
1. I need a formula (non-VBA) in a worksheet that can sum two consecutive numbers in a column of data which, when added together, created the highest possible number.
2. The numbers themselves MUST BE in consecutive order, i.e. if the fifth and sixth numbers in a column make the highest aggregate, the formula should find and return the SUM of these two cells. If the second and sixth numbers in the column were to return a higher aggregate value, this does not count, and should not be calculated.
3. In the attached workbook, B2:B18 each contain a number. There are no blanks and no text.
4. I need the formula to identify that by summing B10 and B11, it returns the highest value.
5. The formula must also work if multiple combinations of consecutive numbers are possible which return the same value.
Thanks in advance for your help, I look forward to receiving your answers.
Best regards!
Bookmarks