Home 
Search 
Today's Posts 
#1




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. 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Excel startup problem. Possible problem with stdole32.tlb  Excel Programming  
Colon at the end of excel file name(ex: problem.xls:1, problem.xls  New Users to Excel  
Started out as an Access problem. Now an Excel problem  Excel Discussion (Misc queries)  
Problem when multipple users access shared xlfile at the same time, macrocode for solve this problem?  Excel Programming 