Forum Discussion

CW_Excel123's avatar
CW_Excel123
Copper Contributor
Mar 25, 2020
Solved

Excel pivot table search question

Hi, Does anyone know how to check multiple boxes when you create an excel pivot table, where the options are different numbers? Basically, I create a pivot table and want to display the results that ...
excel
Formulas and Functions
  • SergeiBaklan's avatar
    SergeiBaklan
    Mar 26, 2020

    CW_Excel123 

    This sample on PivotTable with dates, but that doesn't matter. My initial filter

    after I do the search and add data to filter

    Result is

SergeiBaklan's avatar
SergeiBaklan
Diamond Contributor
Mar 26, 2020

CW_Excel123 

This sample on PivotTable with dates, but that doesn't matter. My initial filter

after I do the search and add data to filter

Result is

CW_Excel123's avatar
CW_Excel123
Copper Contributor
Mar 26, 2020

SergeiBaklan 

 

Hi Sergei, This is exactly what I need. It does work! Thank you very much!

Resources