Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to average every 10 numeric values
How can I create automatically an average of every 10 numeric value in one column and display the result in the next column? For example, I have 3000 Readings in one column and want to see the average of every 10 readings in the next column. So the next column will show 300 averaged readings without any blanc fields in between. Is this possible? -- emel24 ------------------------------------------------------------------------ emel24's Profile: http://www.excelforum.com/member.php...o&userid=20004 View this thread: http://www.excelforum.com/showthread...hreadid=394821 |
#2
|
|||
|
|||
If your data is in A1:A3000, in B1 enter:
=AVERAGE(OFFSET(B$1,10*(ROW(B1)-1),-1):OFFSET(B$1,10*(ROW(B1)-1)+10,-1)) Copy down as needed. Lightly tested, but should work. -- Vasant "emel24" wrote in message ... How can I create automatically an average of every 10 numeric value in one column and display the result in the next column? For example, I have 3000 Readings in one column and want to see the average of every 10 readings in the next column. So the next column will show 300 averaged readings without any blanc fields in between. Is this possible? -- emel24 ------------------------------------------------------------------------ emel24's Profile: http://www.excelforum.com/member.php...o&userid=20004 View this thread: http://www.excelforum.com/showthread...hreadid=394821 |
#3
|
|||
|
|||
Hi!
Values in A1:A3000 In B1 enter: =AVERAGE(OFFSET(A$1,(ROW(1:1)-1)*10,,10)) Copy down to B300 Biff "emel24" wrote in message ... How can I create automatically an average of every 10 numeric value in one column and display the result in the next column? For example, I have 3000 Readings in one column and want to see the average of every 10 readings in the next column. So the next column will show 300 averaged readings without any blanc fields in between. Is this possible? -- emel24 ------------------------------------------------------------------------ emel24's Profile: http://www.excelforum.com/member.php...o&userid=20004 View this thread: http://www.excelforum.com/showthread...hreadid=394821 |
#4
|
|||
|
|||
Nice, Biff; better than my solution! :-)
Regards, Vasant "Biff" wrote in message ... Hi! Values in A1:A3000 In B1 enter: =AVERAGE(OFFSET(A$1,(ROW(1:1)-1)*10,,10)) Copy down to B300 Biff "emel24" wrote in message ... How can I create automatically an average of every 10 numeric value in one column and display the result in the next column? For example, I have 3000 Readings in one column and want to see the average of every 10 readings in the next column. So the next column will show 300 averaged readings without any blanc fields in between. Is this possible? -- emel24 ------------------------------------------------------------------------ emel24's Profile: http://www.excelforum.com/member.php...o&userid=20004 View this thread: http://www.excelforum.com/showthread...hreadid=394821 |
#5
|
|||
|
|||
Thank you very much to you all! It works very good!!! :-) -- emel24 ------------------------------------------------------------------------ emel24's Profile: http://www.excelforum.com/member.php...o&userid=20004 View this thread: http://www.excelforum.com/showthread...hreadid=394821 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text values to numeric values | Excel Discussion (Misc queries) | |||
Error Handling #N/A with AVERAGE Function - Average of values in Row | Excel Worksheet Functions | |||
How to use an array or matrix to return text vs. numeric values | Excel Worksheet Functions | |||
Leading Zeros in Numeric Values | Excel Worksheet Functions | |||
Calculating Average Values Using Arithmetic Equations | Excel Worksheet Functions |