ExcelVisual
New Member
- Joined
- Feb 23, 2025
- Messages
- 4
- Office Version
- 365
- 2024
How to correctly select filtered results from smart table? Is it possible to use such a formula:
Or is this a sign of bad taste and there are more thoughtful solutions???
Excel Formula:
=FILTER(mydata[Month],SUBTOTAL(103,INDIRECT("Data!"&ADDRESS(ROW(mydata[Month]),COLUMN(mydata[Month]))))>0)