I have a worksheet that looks like this (titled assignments)
Hospitalist Room # Patient Name Age/***/DOB MRN Admit Date/Time Attending PCP Nursing Home Class Notes
And then I also have a list of providers (titled- do not admit providers) that I would like to search for within the worksheet above.
How could I make a pivot table type template that would allow me to search the daily assignment worksheet for the do not admit providers?
Using excel 2013
Bookmarks