Assuming I do not allow multi select on a slicer e.g.
Option 1
Option 2
How could I extract the text e.g. Option 2 if selected into a cell.
A quick Google wants either PowerBI / Pivot which is incompatible with my current worksheet setup.
Option 1
Option 2
How could I extract the text e.g. Option 2 if selected into a cell.
A quick Google wants either PowerBI / Pivot which is incompatible with my current worksheet setup.