How to Find Slicer value - Excel advanced trick

[@Curic-Ivan]

Interesting ideas. Thank you for sharing!

[@kalpanachaudhari2268]

Thanks for the informative way of using slicers to get values. However when multiple values are selected how do we return the the array data. I seem to be getting an error. Can you please help out

[@prakavids]

Thanks for the reply Kalpana. Please reach me out in LinkedIn for any further assistance. Also mention the error details. There I will be able to help on your issue. www.linkedin.com/in/praveenkarthikk

[@prakavids]

One issue that suspect is, your dynamic array could be interrupted by any other values down the cells. If that is the case, you may be getting SPILL error. Else please check if you have enabled grand total for your pivot table.

[@khalidmajeed2886]

great sir

[@prakavids]

Thanks Khalid