Forum Discussion
Duplicate Billing
- Glad to be of help
Hi and thank you for your help. If I am understanding correctly, the result TRUE will be the duplicate billed items and the result FALSE will essentially be the claims that are billed correctly?
I have added a sample of the data that I am actually working with.
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 hope I didn't confuse you. I am known to overthink things.
Absolutely yes. The result TRUE is the duplicate billed why FALSE is the otherwise. I have opened your workbook and saw many a handful of columns. I need to know which particular column (either column G or I) you're referring to
Hi,
This is wonderful. I am referring to Column G, but I would like to use Column C because I am going by the billing provider versus the provider's name or location.
Thank you again
Based on column C, I created a new column and executed the formula as seen in the caption below
Duplicate Provider Number returned TRUE while unique numbers returned FALSE.