wsnyder
Board Regular
- Joined
- Sep 23, 2018
- Messages
- 223
- Office Version
- 365
- Platform
- Windows
Hi,
How can I create a Dynamic Named Range of values only?
For example the entire range is $I$4:$I$21. However, only some cells have values, others have #N/A which results from this formula:
=IFERROR(GETPIVOTDATA("Sales",$E$3,"App",$H10,NA()).
So based on the Slicer selection, a varying number of cells are returned with values.
Thanks,
w
How can I create a Dynamic Named Range of values only?
For example the entire range is $I$4:$I$21. However, only some cells have values, others have #N/A which results from this formula:
=IFERROR(GETPIVOTDATA("Sales",$E$3,"App",$H10,NA()).
So based on the Slicer selection, a varying number of cells are returned with values.
Thanks,
w