In this short video I use a couple of Excel tools to compare two spreadsheets and find what data is missing from one spreadsheet but exists in the other.
Here's the setup - one spreadsheet is a list of patients that have been discharged and the other spreadsheet is a list of patients that have been sent bills for their visit. These lists have about 75,000 visits on each one and 1,000 of them have not been billed.
Before the HIPAA police gets all excited - this is not a list of names, it is a list of randomly generated numbers that I labeled "account number" which represents a patient visit. All made up data. :)
END OF DISCLAIMER
Ok, where was I? Oh yeah - If I wanted to manually compare both lists to find the "missing 1000" I would likely have at least one birthday before I was done. And I'd probably make a bunch of mistakes. Double yuck.
Watch the video, follow the steps and you could do this same comparison yourself in a couple of minutes. Yeah, not a typo - you can find 1000 "needles" in a 75,000 line item "haystack" in a couple minutes!