| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Define a range containing the first 10 rows of a filtered list
I have a list of about 200 rows with filters. I need to build a graph with
series referring to that list but displaying only the 10 first (visible) rows (which vary depending on the filters I set). I tried to use a named range with offset(...10) but Excel considers the hidden rows which makes that if the first 10 rows are not visible because filtered, my graph is empty ! Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot Expand Named Range - when size of the Range exceeds | Excel Discussion (Misc queries) | |||
| Excel - return a picture or range rows as the result of a formula | Excel Worksheet Functions | |||
| Macro - define cell range for a sum function | Excel Discussion (Misc queries) | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
| Define Range with an offset | Excel Discussion (Misc queries) | |||
Threaded Mode
