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
Pivot filtering inquiry
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Pivot filtering inquiry
Could you provide an example of what you want to accomplish?
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 94
- Joined: 16 Oct 2021, 16:22
Re: Pivot filtering inquiry
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
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
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
-
- Administrator
- Posts: 78631
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Pivot filtering inquiry
In theory, you can use Advanced Filter for this purpose, using the list of IDs on the Patient IDs sheet as criteria range.
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...
It might be better to do this in a relational database such as SQL Server...
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...
It might be better to do this in a relational database such as SQL Server...
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 94
- Joined: 16 Oct 2021, 16:22
Re: Pivot filtering inquiry
Thank you Hans
-
- 2StarLounger
- Posts: 151
- Joined: 11 Jun 2012, 20:37
Re: Pivot filtering inquiry
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
It's an inner join of your two tables.
See: https://app.box.com/s/b6y9s0howg4cb59ym63vv44vnwd7m5x7