| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy formula with adding e.g. 10 cells
James, it works!!! Once again thanks!
"René" wrote: Hello, I've got a data sheet with 1000 values (A1:J100). I would like to calculate the average of every 10th value in the "A" colomn. This will be the average A1:J1; A10:J10;A20:J20 etc I want to transport these average values to sheet 2. Is there anyone who can help me with this case? I want to prevent to make a formula 100 times by doing this manual. René |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically copy formula in column when adding new row.... | Excel Worksheet Functions | |||
| adding cells that contain a formula | Excel Discussion (Misc queries) | |||
| Can I use a formula to copy info while adding a whole new row? | Excel Discussion (Misc queries) | |||
| Formula for Adding cells up | Excel Worksheet Functions | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
![René[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
