Forum Discussion
Duplicate Billing
- Glad to be of help
Assuming you want to find duplicate values in Provide Number in column C, you can have an helper column and execute the formula =COUNTIFS(C2:C100,C2)>1.
Click Enter and copy the formula down.. The values that are duplicated will return TRUE and unique Provider Number will return FALSE.
Another way of identify duplicate values is to use the Conditional Formatting.. Although, this is bot formula based
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