| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Creating a dynamic range always using the last 10 rows of data
Hi
One way =INDEX(Yearly!$CX:$CX,COUNTA(Yearly!$CX:$CX)-10):INDEX(Yearly!$CX:$CX,COUNTA(Yearly!$CX:$CX)) -- Regards Roger Govier "yak141" wrote in message ... I know how to setup a dynamic range. However, I need a set of formula that'll allow the dynamic range to always use the last 10 rows on data in that range. My current set of formula is "=OFFSET(Yearly!$CX$2,0,0,COUNTA(Yearly!$CX:$CX),1 )". It allows me to use the entire range, but I only need the last 10 rows. Please help!Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range including some blank rows | Excel Discussion (Misc queries) | |||
| NUMBER OF ROWS IN A DYNAMIC RANGE | Excel Worksheet Functions | |||
| Number rows in a dynamic range | Excel Worksheet Functions | |||
| Dynamic Data Range | Excel Worksheet Functions | |||
| Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
![Roger Govier[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
