Pivot Dropdown using existing list

ReneeDJ73

New Member
Joined
Jul 28, 2021
Messages
3
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

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
I should add that the item numbers do not follow any sequence, so I can't use between.
 
Upvote 0

Forum statistics

Threads
1,214,653
Messages
6,120,750
Members
448,989
Latest member
mariah3

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
Back
Top