A sum problem
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. |
All times are GMT +1. The time now is 05:22 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com