Forum Discussion
Solved
Cell display the "slicer choice" in excel
Hi community, I need help about connected a cell to a slicer. I created a table with some diameter intervals. For each intervals, a number is corresponding (like 7 for diameters from 5 to 10 mm)....
NicoF06ppt Create a small pivot table that you can hide under the slicer (linked to the pivot table, not the diameter list) and then connect the cell that should display the number corresponding to the selected diameter to a named cell in the pivot table. See attached example.
NicoF06ppt Create a small pivot table that you can hide under the slicer (linked to the pivot table, not the diameter list) and then connect the cell that should display the number corresponding to the selected diameter to a named cell in the pivot table. See attached example.
Thank you very much Riny_van_Eekelen !
That's the first time I use this support chat and I am very happy to see that my problem is solved so fast 🙂
Have a nice day
That's the first time I use this support chat and I am very happy to see that my problem is solved so fast 🙂
Have a nice day