Home |
Search |
Today's Posts |
#1
|
|||
|
|||
is there a more efficient formula than...
If I have the following data:
0.630301621 0.735538614 1.112178958 1.075829421 1.794418509 1.661534827 0.723790191 0.736495518 0.808701582 0.9371253 -0.085016535 0.052665338 0.063743977 0.064828284 1.051556997 1.155830979 0.621846568 0.70646412 0.862235718 1.07312007 2.212618417 2.021491808, and want to average every pair of values...B3 & B4, B5 & B6, etc..., is there a more efficent formula than: =IF(MOD(ROW(),2)=1,AVEDEV(INDIRECT(ADDRESS(ROW(),C OLUMN()-2)),INDIRECT(ADDRESS(ROW()+1,COLUMN()-2))),"") This data set can get quite large, so having a formula that can be filled in a series is a big help. Curiously, wazooli |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |