Forum Discussion
Solved
create dynamic range of table including headers and footers
Hello, I'm using Office 365 on Windows 10. I wanted to create a Dynamic Named Range of a Table called Table1, including it's Headers and Footers (Totals Row). By Default, when you enter the D...
The range consisting of the header row + the data rows is Table1[[#Headers],[#Data]]
The range consisting of the header row + the data rows + the total row is Table1[#All]
The range consisting of the data rows + the total row is Table1[[#Data],[#Totals]]
Thank you for the correct Formula Sergei! It works now!
You are welcome. But again, it's better to use native =Table1[#All]