Pivot filtering inquiry

[JDeMaro22]

Hello,
I'm not sure this is possible but I have a list of over 8,000 patient ids. The doctors would like to see a list of just their transactions. I can't manually enter each of their id's into the filter so is there a faster way to use a column of patient id's to filter out a pivot table? Also I'm not sure a lookup will work since there will be multiple lines for most of the patient ids.

Thank you very much,

Joshua

[HansV]

Could you provide an example of what you want to accomplish?

[JDeMaro22]

Hi Hans,

The file is too large so I attached a link below. I am looking for a way to filter the "All CPT Codes" worksheet by all of the Patient IDs in the "Patient IDs" worksheet.

Thanks,


https://fromsmash.com/HansData

[HansV]

I'll take a look after dinner (European time)

[HansV]

In theory, you can use Advanced Filter for this purpose, using the list of IDs on the Patient IDs sheet as criteria range.

S2460.png

But the list of IDs is so long that Excel completely bogs down if you try this.
Filtering by a list of some 15000 IDs is rather much! I have a fast PC, but it took Excel more than 5 minutes to filter the list...

S2459.png

It might be better to do this in a relational database such as SQL Server...

[JDeMaro22]

Thank you Hans

[p45cal]

Less than 10 secs here using Power Query. Sheet1 table, right-click and choose Refresh.
It's an inner join of your two tables.
See: https://app.box.com/s/b6y9s0howg4cb59ym63vv44vnwd7m5x7