| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I increment from cell to cell by 10?
I have an excel spreadsheet that has 50,000 rows and all info ins in one
column. I would like to consolidate it to 10,000. When I go to B1 and put in =average(A1:A2500) it averages fine. However when copying this code and pasting it in B2 the formula turns into =average(A2:A2501). I would like to have these numbers increment by 10 instead of 1. Is this possible? Please let me know! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| insert date | Excel Worksheet Functions | |||
| Help with this conditional IF statement | Excel Discussion (Misc queries) | |||
| Custom functions calculating time arguments Help Desperate | Excel Worksheet Functions | |||
| Instead of a negative number, I'd like to show zero... | Excel Worksheet Functions | |||
| Possible Lookup Table | Excel Worksheet Functions | |||
Threaded Mode
