Pivot Dropdown using existing list

ReneeDJ73

New Member
Joined
Jul 28, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I have a large set of data that is placed in a pivot table. I want to select multiple criteria in the pivot dropdown from an existing list. i.e. I have a list of items for one department (about 20) and would like to use that list to select multiple criteria from pivot table. I don't want to use a slicer as that is just as time consuming as typing in each individual item. If I was searching on a table, I can use Advanced find, but I haven't found a way to use an existing list in the selection for the pivot drop down.
 

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

ReneeDJ73

New Member
Joined
Jul 28, 2021
Messages
2
Office Version
  1. 365
Platform
  1. Windows
I should add that the item numbers do not follow any sequence, so I can't use between.
 

Forum statistics

Threads
1,147,481
Messages
5,741,400
Members
423,657
Latest member
Medrok2021

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top