Home 
Search 
Today's Posts 
#1




adding three consecutive columns
I am trying to write a formula and I am looking for help:
I have thirteen columns of data, kw, each of these columns is a range of specific gravity: K: <1.070 L: 1.0701.075 M: 1.0751.080 N: 1.0801.085 O: 1.0851.090 P: 1.0901.095 Q: 1.0951.100 R: 1.1001.105 S: 1.1051.110 T: 1.1101.115 U: 1.1151.120 V: 1.1201.125 W: 1.125 Each row of data is a sample of objects, and the percentage by weight of the objects is recorded in the appropriate column, ie the percentage of the total weight that has a specific gravity that falls in that .005 range in gravity. What I want to to is to write a formula that calculates what the highest percentage of the sample falls within three consecutive columns, ie a range of .015 in specific gravity. It has to be three consecutive columns. It might be that for sample #1, the three consecutive columns with the highest percentage by weight might be O,P,Q containing 77% of the objects by weight, and for sample #2 S,T,U might contain 68% or whatever. Its not important which columns it is for each row, just the total of those three. Its easy to find the highest number, second highest, third highest but how can I find the highest three consecutive? Suggestions? 
#2




adding three consecutive columns
This may seem silly, but its very easy to implement:
In X1 put =K1+L1+M1 and copy across. this will put =L1+M1+N1 in Y1, etc. and then copy down. You started with 13 columns of data and you will now have 10 additional columns of 3 sample sums. Just get the MAX for each row across the 10 new columns.  Gary's Student "Darin Gibson" wrote: I am trying to write a formula and I am looking for help: I have thirteen columns of data, kw, each of these columns is a range of specific gravity: K: <1.070 L: 1.0701.075 M: 1.0751.080 N: 1.0801.085 O: 1.0851.090 P: 1.0901.095 Q: 1.0951.100 R: 1.1001.105 S: 1.1051.110 T: 1.1101.115 U: 1.1151.120 V: 1.1201.125 W: 1.125 Each row of data is a sample of objects, and the percentage by weight of the objects is recorded in the appropriate column, ie the percentage of the total weight that has a specific gravity that falls in that .005 range in gravity. What I want to to is to write a formula that calculates what the highest percentage of the sample falls within three consecutive columns, ie a range of .015 in specific gravity. It has to be three consecutive columns. It might be that for sample #1, the three consecutive columns with the highest percentage by weight might be O,P,Q containing 77% of the objects by weight, and for sample #2 S,T,U might contain 68% or whatever. Its not important which columns it is for each row, just the total of those three. Its easy to find the highest number, second highest, third highest but how can I find the highest three consecutive? Suggestions? 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Adding columns (one with a formula)  New Users to Excel  
adding columns  Excel Discussion (Misc queries)  
How can i set consecutive columns in an excel worksheet to differ.  Charts and Charting in Excel  
problem with adding columns of numbers  Excel Worksheet Functions  
Disable Adding or Deleting Rows and Columns  Excel Discussion (Misc queries) 