LuisPulido
New Member
- Joined
- Apr 27, 2021
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
So I have I have a list with categories and base o the category that I select a Dynamic Range with subcategories is created with Filter,Unique and Order functions. In the following columns I have the sales from Jan to Dec which is connected to s spark lines.
The thing is that not all categories have the same number of sub categories so what I need is to make the location range of sparklines dynamic.
I already try creating a name with following formula:
=OFFSET(sheet1!$A$1,0,0,COUNTA(sheet1!$A$1#),1)
where in A1 start the dynamic range of subcategories.
The thing is that not all categories have the same number of sub categories so what I need is to make the location range of sparklines dynamic.
I already try creating a name with following formula:
=OFFSET(sheet1!$A$1,0,0,COUNTA(sheet1!$A$1#),1)
where in A1 start the dynamic range of subcategories.
