Hello,
I have a pivot table that contains about 10,000 accounts and I want to filter on only a specific 300 accounts from that list.
Is there a way to do so without having to check the box to select each of the 300 accounts 1 by 1? I was hoping that you could add multiple selections by pasting into the 'Value Search' window, separated by a , or ; or something, but have had no luck so far in doing so.
I hope this makes sense?
Thanks!
I have a pivot table that contains about 10,000 accounts and I want to filter on only a specific 300 accounts from that list.
Is there a way to do so without having to check the box to select each of the 300 accounts 1 by 1? I was hoping that you could add multiple selections by pasting into the 'Value Search' window, separated by a , or ; or something, but have had no luck so far in doing so.
I hope this makes sense?
Thanks!