| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Cell Range
Thanks, I got what I want
Cell C5=MAX(B5:OFFSET(Sheet1!B5,0,0,Sheet1!$E$1,1)) Where my colum of data starts in B5 and n is in cell E1. When I drag/copy into the rest of the cells in column C it updates the B5 to B6, B7, etc. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range Defined by Value of Cell | Excel Worksheet Functions | |||
| Dynamic range where the reference cell can change | Excel Discussion (Misc queries) | |||
| Dynamic cell range for functions | Excel Worksheet Functions | |||
| copying dynamic range based on cell outside of range | Excel Programming | |||
| Cell Data Validation with dynamic Range | Excel Programming | |||
Threaded Mode
