#1
|
|||
|
|||
Repeat formula 5 times and repeat?
Hi
Trying to figure out if it's possible to repeat the same formula 5 times on a range of cells, and then restart the formula 5 times on the following 5 cells and then again... E.g. I have a cell range from A1 to A20 I want the formula to run in B1 to B20 E.g. of how the formula will run over 5 cells: First in B1: I want: A1 / 2, Then in B2: A2 / 2 + B1, Then in B3: A3 /2 + B2, Then in B4: A4 /2 +B3, Then in B5: A5/2 +B4. Then I want the whole shebang to repeat its self over the next 5 cells etc. Not sure if this is possible? Jenny |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Bibliography Hyphen for repeat author | grantgibson45 | Word | 3 | 02-25-2013 04:32 AM |
Text will repeat in the fields | ypurcaro | Word | 1 | 02-07-2013 01:46 AM |
Repeat Spell check in a doc that has already been checked | mawigfie | Word | 1 | 08-22-2012 01:16 PM |
how to repeat row in header | gsrikanth | Excel | 10 | 06-28-2012 02:31 AM |
i want to insert page break without repeat row on top | gsrikanth | Excel | 0 | 05-24-2012 04:07 AM |