| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Fill down while skipping cells
I have a long list of data listed as duplicate data points that need to be averaged. For example, A1 and A2 are duplicates that need to be averaged, A3 and A4 are duplicates that need to be averaged, etc. How can I create an AVERAGE function and then fill it down so that it will add 2 cells each time (as in =AVERAGE(A1+2),(A2+2) but this does not work)? Thanks!
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| reference row on another sheet skipping zeros but not skipping li. | Excel Discussion (Misc queries) | |||
| Skipping cells in a formula | Excel Worksheet Functions | |||
| skipping cells | Excel Discussion (Misc queries) | |||
| Skipping Blank Cells | Excel Discussion (Misc queries) | |||
| Autofill skipping cells | Excel Worksheet Functions | |||
Threaded Mode
