| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Advancing formula
Hi When I write a formula for a cell and the click and drag to adjacent cells, excel advances the formula in a certain manner. I am using person's names. For example =Barker!Z11 becomes =Barker!Z12 in the next cell. Is there anyway of making excel advance the formula in a certain way? In this case I want it to advance by 7 so the formula for adjacent cells reads =Barker!Z18 and =Barker!Z25 and then =Barker!Z32 and so on? Also can you rename part of a formula across a range of cells so that Barker is replaced by Ball. In other words =Barker!Z11 becomes =Ball!Z11 etc... thanks Steve -- spankydata ------------------------------------------------------------------------ spankydata's Profile: http://www.excelforum.com/member.php...o&userid=37217 View this thread: http://www.excelforum.com/showthread...hreadid=569315 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Creating a check mark box | Setting up and Configuration of Excel | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Threaded Mode
