Forum Discussion
Duplicate Billing
- Glad to be of help
It's hard to draw a connection between your description and the image of the data you provided. You say What I am looking for the formula to do is match the same patient on the same date of service that has a claim paid by different providers, but in what you show there's no column that specifies a date of service; nor is there a patient ID. Finally, there's a lot of different info on Providers, so it would help to know which of those columns are relevant.
Is it possible to upload a sample of the actual spreadsheet? Just make sure no real people (or, for that matter, real providers) can be identified.
mathetes Hi,
I have attached the data that I am working with. It's a small sample, but is exactly formatted to what I am working on.
I am in the end result looking for duplicate billing. The "correct" billing provider is EYE KRAZY OPTICAL. I am looking to identify the additional provider's billing for the same member on the same date of service as EYE KRAZY OPTICAL.
I am probably making this harder than what it is lol, but I am trying to work on my formulas.