Need help with a Duplicate Exclusion

CFE4130

Forums

Hi,
I've attached an example of the spreadsheet that I'm working on. I'm trying to clean up this spreadsheet so that it does NOT show instances when Procedure Code 80307 is billed with G0480, G0481, G0482, or G0483 for the same ID and Service Date. For example, lines 6 and 7 would stay and lines 8 and 9 would be removed from the results. I was trying to use duplicate exclusion function in IDEA, but I'm educated enough with scripting to figure this out. Thanks for any help.

Anthony.Kariuki Mon, 01/17/2022 - 07:08

How I would do it

  1. Import into IDEA
  2. Append a field call it 'CODE' with equation @LEFT(CLC_Procedure_Code,2)
  3. Run duplication with Criteria  Code<> GO

Hope it makes sense