t0ny84
Board Regular
- Joined
- Jul 6, 2020
- Messages
- 205
- Office Version
- 365
- 2016
- 2013
- Platform
- Windows
- Mobile
- Web
Hi,
I am wondering if anyone can assist with the below questions, the spreadsheet design would be a single sheet with a table and two slicers setup (one for Name and one for Team).
1) Can SLICERs and their selections be accessed\used in formulas?
2) Can I show the value of what has been selected in the slicer in a cell.
e.g. John selected on Slicer and in Cell A1 says John.
3) Is it possible (preferably) via a formula to have a cell value updated based on filtered tables results.
e.g. On sheet select John - Cell A2 would calculate totals in filtered results for John from column 3 of the table.
4) A formula to show the value of the first cell in the filtered data in another cell.
Thanks In Advance!
t0ny84
I am wondering if anyone can assist with the below questions, the spreadsheet design would be a single sheet with a table and two slicers setup (one for Name and one for Team).
1) Can SLICERs and their selections be accessed\used in formulas?
2) Can I show the value of what has been selected in the slicer in a cell.
e.g. John selected on Slicer and in Cell A1 says John.
3) Is it possible (preferably) via a formula to have a cell value updated based on filtered tables results.
e.g. On sheet select John - Cell A2 would calculate totals in filtered results for John from column 3 of the table.
4) A formula to show the value of the first cell in the filtered data in another cell.
Thanks In Advance!
t0ny84