| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how copy formula that contains ranges so ranges do not overlap
I have a formula on one worksheet that finds the max value of 3 cells on
another worksheet. I want the formula below it to move to the next three cells not overlap the rows. When I drag them it copies overlapping cells. What I am looking for is example: =MAX(Spread!B118:B120) next row the formula would be =MAX(Spread!B121:B123) how do you do that where you do not have to enter each formula for each row? thank you -- Patty |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how copy formula that contains ranges so ranges do not overlap
Patty,
Try this This does B118 - B120 but dragged down 1 cell becomes B121 B123 =MAX(OFFSET(Spread!B$118,(ROWS($1:1)-1)*3,,3)) Mike "Patty" wrote: I have a formula on one worksheet that finds the max value of 3 cells on another worksheet. I want the formula below it to move to the next three cells not overlap the rows. When I drag them it copies overlapping cells. What I am looking for is example: =MAX(Spread!B118:B120) next row the formula would be =MAX(Spread!B121:B123) how do you do that where you do not have to enter each formula for each row? thank you -- Patty |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I copy formula but only increment certain ranges? | Excel Discussion (Misc queries) | |||
| how can i networkdays date ranges where dates overlap | Excel Worksheet Functions | |||
| copy Ranges to other workbook. | Excel Discussion (Misc queries) | |||
| Copy and SUM functions with different ranges | Excel Worksheet Functions | |||
| Copy entire ranges | Excel Worksheet Functions | |||
Linear Mode
