A sum problem
From
Daddy Sage@21:1/5 to
All on Sat Nov 16 02:02:35 2019
I have the follwing sheet
A B C D E F G H I J K
101 400 18 200 2 200 8 200 6 200 10
102 400 12 200 5 200 7 200 4 199 8
103 399 17 199 7 200 7 199 9 199 10
104 395 13 195 5 200 6 195 7 190 5
105 390 15 195 7 195 2 195 8 190 3
106 390 12 195 5 190 2 195 7 190 5
I like to calculate the numbers in column C using a formula in stead of doing it manually.
The reuslts are calculated from this logic:
Columns C is the sum of the two highest values in columns E, G, I and K, but only if the numbers are next to one of the two highest numbers in columns D, F, H and J.
Thus the resultat for 101 is 18 because the two highest numbers in D, F, H and J are 200 and the two highest numbers in E, G, I and K are 8 and 10.
The resultat of 103 is 17 because 7 is to the right of 200 (highest number in D, F, H and J) a,d 10 is the highest number to the right of an occurance of 199.
I hope you understand the logic.
--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)