Spreadsheet: 195842d1353686282-how-to-extract-duplicate-records-from-4-spreadsheet-into-a-separate-spreedsheet-sample-spreadsheet5
Sheet: Sample

Sr# | Insurance | Name | Account # | Encounter# | DOB | DOD | Control# | ID# | Status | Entity | ITEM | Multiples | Amount1 | Amount2 | Amount3 | Amount4 | Amount5 | Amount6 | Amount7 | Amount8 | Other Info | Status | IVR /  Live | Go Date | Remarks1 | CODE | Remarks2 | Reason 3 | Remarks3 | Reason2 | Re-Worked
1 | Geha | [NAME], [NAME] | 398334 | 928739 | 1957-06-23 00:00:00 | 2011-03-07 00:00:00 | 659841523 | 154G82154 | Primary | Smith, George | 36542 | 65 | 651 |  | 0 | 0 | 0 | 687 |  | 0 |  | Not Finished | IVR | 2001-08-07 00:00:00 | dsajfoajfoa sdfjas fdlajldf ajdfajsdlk f | FINISHED | LKJDFLK | TOL | 2L3J42J3LJ4 2L | Late
 | Geha |  |  |  |  |  |  |  |  |  | 85045 | 22 | 213 |  | 0 | 0 | 0 | 18 |  | 0 |  |  |  |  |  | IN PROGRESS |  | TOL |  | Late
 | Geha |  |  |  |  |  |  |  |  |  | J9212 | 0 | 56 |  | 0 | 0 | 0 | 654 |  | 0 |  |  |  |  |  | IN PROGRESS |  | WOB |  | Late
 | Geha |  |  |  |  |  |  |  |  |  | 96154 | 2 | 41 |  | 0 | 0 | 0 | 16 |  | 0 |  |  |  |  |  | IN PROGRESS |  | In Progress |  | Late
 | Geha |  |  |  |  |  |  |  |  |  | J1542 | 21 | 165 |  | 0 | 0 | 0 | 34 |  | 0 |  |  |  |  |  | IN PROGRESS |  | INWN |  | Late
 | Geha |  |  |  |  |  |  |  |  |  | J8452 | 3 | 32 |  | 0 | 0 | 0 | 168 |  | 0 |  |  |  |  |  | INWN |  | WOB |  | Late
 | Geha |  |  |  |  |  |  |  |  |  | [NAME] | 22 | 345 |  | 0 | 0 | 0 | 34 |  | 0 |  |  |  |  |  | INWN |  | INWN |  | Late
 | Geha |  |  |  |  |  |  |  |  |  |  |  | 2423 | 4324 |  | 0 |  | 464 | 9896 |  |  |  |  |  |  | INWN |  | FINISHED |  | Late
2 | Cigna | [NAME], Connor | 78382 | 923832 | 1931-10-21 00:00:00 | 2011-03-24 00:00:00 | 26487954 | U15489751255 | Tertiary | Claudia, [NAME] | 78302 | 59 | 56 |  | 0 | 0 | 0 | 546 |  | 0 |  | Outstanding | IVR | 2011-02-21 00:00:00 | [NAME] f;askd;l | INWN | LKAFADSFDFJSAFJSDA | FINISHED | 098F0S FS0F8 09SD809F 8SD09F DS0 | Late
 | Cigna |  |  |  |  |  |  |  |  |  | J8452 | 4 | 51 |  | 0 | 0 | 0 | 14 |  | 0 |  |  |  |  |  | IN PROGRESS |  | INWN |  | Late
 | Cigna |  |  |  |  |  |  |  |  |  |  |  | 516 | 3 | 0 | 0 |  | 14 | 4376 |  |  |  |  |  |  | IN PROGRESS |  | TOL |  | Late
3 | Cigna | [NAME], Connor | 78382 | 923823 | 1931-10-21 00:00:00 | 2011-04-20 00:00:00 | 26487954 | U15489751255 | Tertiary | Claudia, [NAME] | 92735 | 22 | 51 |  | 0 | 0 | 0 | 655416 |  | 0 |  | Finsihed | IVR | 2012-11-13 00:00:00 | afpokfpkapfk pasdkfpoa sdpofkopasdf | IN PROGRESS | DS;ALKPASFLDJ SPODAFLDSJF POSJDAPOF JSAD | WOB | S;LDJ AS09DFS0DF9 DS | Late
 | Cigna |  |  |  |  |  |  |  |  |  | 48124 | 5 | 6 |  | 0 | 0 | 0 | 15 |  | 0 |  |  |  |  |  | IN PROGRESS |  | TOL |  | Late
 | Cigna |  |  |  |  |  |  |  |  |  | 15481 | 6 | 651 |  | 0 | 0 | 0 | 5 |  | 0 |  |  |  |  |  | FINISHED |  | WOB |  | Late
 | Cigna |  |  |  |  |  |  |  |  |  | 32482 | 16 | 121 |  | 0 | 0 | 0 | 21 |  | 0 |  |  |  |  |  | IN PROGRESS |  | FINISHED |  | Late
 | Cigna |  |  |  |  |  |  |  |  |  | 96154 | 22 | 24 |  | 0 | 0 | 0 | 161 |  | 0 |  |  |  |  |  | FINISHED |  | WOB |  | Late
 | Cigna |  |  |  |  |  |  |  |  |  | J1611 | 24 | 1 |  | 0 | 0 | 0 | 14 |  | 0 |  |  |  |  |  | IN PROGRESS |  | WOB |  | Late
 | Cigna |  |  |  |  |  |  |  |  |  |  |  | 15 | 35 | 0 | 0 |  | 145 | 5114 |  |  |  |  |  |  | IN PROGRESS |  | TOL |  | Late
4 | Medicare | [NAME], [NAME] | 31067 | 84829742 | 1963-01-01 00:00:00 | 2012-03-07 00:00:00 | 269784 | 354469148A | Primary | Claudia, [NAME] | 91505-25 | 22 | 242 |  | 0 | 0 | 0 | 415 | 457 | 0 |  | Crossover | IVR | 2012-04-19 00:00:00 | adlakpfka;sdkfadskf dsasa asdf asdfads | IN PROGRESS |  | WOB | [NAME] | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | J9125 | 26 | 35 |  | 0 | 0 | 0 | 196 |  | 0 |  |  |  |  |  | FINISHED |  | INWN |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | 36784 | 113 | 234 |  | 0 | 0 | 0 | 16 |  | 0 |  |  |  |  |  | FINISHED |  | INWN |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  |  |  | 1 | 23 | 0 | 0 |  | 19 |  |  |  |  |  |  |  | FINISHED |  | WOB |  | Overdue
5 | Medicare | [NAME], [NAME] | 31067 | 5626453 | 1963-01-01 00:00:00 | 2012-03-21 00:00:00 | 269784 | 354469148A | Primary | Claudia, [NAME] | 99125-25 | 22 | 2165 | 243 | 0 | 0 | 0 | 196 | 124 | 0 |  | Reject | IVR | 2012-05-05 00:00:00 | s a fdaf asdafdaf aadsfa ad ad | FINISHED |  | WOB | SDF9-S 9F-S | Overdue
6 | Medicare | [NAME], [NAME] | 31067 | 936928 | 1963-01-01 00:00:00 | 2012-03-29 00:00:00 | 269784 | 354469148A | Primary | Claudia, [NAME] | 91254 | 23 | 13 |  | 0 | 0 | 0 | 196 | 437 | 0 |  | Finsihed | IVR | 2012-06-08 00:00:00 | af;kasdkdsa;k fafkd;ld ska;lfk; | IN PROGRESS |  | WOB | SF-09SF -0DS | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | J9988 | 21 | 54 |  | 0 | 0 | 0 | 165 |  | 0 |  |  |  |  |  | TOL |  | TOL |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | 93671 | 22 | 46 |  | 0 | 0 | 0 | 59 |  | 0 |  |  |  |  |  | TOL |  | TOL |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | G1548 | 2 | 186 |  | 0 | 0 | 0 | 46 |  | 0 |  |  |  |  |  | TOL |  | TOL |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  |  |  | 1 | 35 | 0 | 0 |  | 13 |  |  |  |  |  |  |  | TOL |  | TOL |  | Overdue
7 | Medicare | [NAME], [NAME] | 31067 | 1836549 | 1963-01-01 00:00:00 | 2012-04-05 00:00:00 | 269784 | 354469148A | Primary | Claudia, [NAME] | J9145 | 36 | 8 |  | 0 | 0 | 0 | 16 | 337 | 0 |  | Reject | IVR | 2012-08-07 00:00:00 | afdpokafpdkfp-0fd08342-0 r-s dfpoka [NAME] | IN PROGRESS |  | WOB | S-0FI-S -F-S0 | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | [NAME] | 33 | 4 |  | 0 | 0 | 0 | 1896 |  | 0 |  |  |  |  |  | IN PROGRESS |  | WOB |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | J0125 | 1 | 564 |  | 0 | 0 | 0 | 198 |  | 0 |  |  |  |  |  | IN PROGRESS |  | WOB |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  |  |  | 1 | 67 | 0 | 0 |  | 189 |  |  |  |  |  |  |  | IN PROGRESS |  | WOB |  | Overdue
8 | Medicare | [NAME], [NAME] | 31067 | 293754 | 1963-01-01 00:00:00 | 2012-04-12 00:00:00 | 269784 | 354469148A | Primary | Smith, George | 88219-25 | 1 | 1 |  | 0 | 0 | 0 | 189 | 543.01 | 0 |  | Delay | IVR | 2012-11-22 00:00:00 | afapofapsk pdspdpf as-pfiusa | IN PROGRESS |  | FINISHED | S-F8S F- | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | 54156 | 2 | 132 |  | 0 | 0 | 0 | 186 |  | 0 |  |  |  |  |  | FINISHED |  | FINISHED |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | 25164 | 1 | 33 |  | 0 | 0 | 0 | 186 |  | 0 |  |  |  |  |  | NOE |  | WOB |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | 95715 | 66 | 132 |  | 0 | 0 | 0 | 3674 |  | 0 |  |  |  |  |  | NOE |  | WOB |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | 95481 | 2 | 32 |  | 0 | 0 | 0 | 678 |  | 0 |  |  |  |  |  | NOE |  | WOB |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | 25418 | 4 | 31 |  | 0 | 0 | 0 | 687 |  | 0 |  |  |  |  |  | NOE |  | TOL |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | J7854 | 9 | 31 |  | 0 | 0 | 0 | 1896 |  | 0 |  |  |  |  |  | NOE |  | TOL |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  |  |  | 31 | 467 | 0 | 0 |  | 37 |  |  |  |  |  |  |  | NOE |  | TOL |  | Overdue
9 | Medicare | [NAME], [NAME] | 31067 | 4278124 | 1963-01-01 00:00:00 | 2012-04-19 00:00:00 | 269784 | 354469148A | Primary | Smith, George | 95236 | 22 | 31 |  | 0 | 0 | 0 | 5466 | 337 | 0 |  | Crossover | IVR | 2012-11-11 00:00:00 | [NAME] posadfjk | NOE |  | TOL | SF8 SFSD80FS-F - | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | 14524 | 21 | 311 |  | 0 | 0 | 0 | 186 |  | 0 |  |  |  |  |  | NOE |  | INWN |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | J2541 | 22 | 54 |  | 0 | 0 | 0 | 6387 |  | 0 |  |  |  |  |  | IN PROGRESS |  | INWN |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  |  |  | 1321 | 6743 | 0 | 0 |  | 196 |  |  |  |  |  |  |  | NOE |  | INWN |  | Overdue
 | Medicare | [NAME], [NAME] | 31067 | 1128947 | 1963-01-01 00:00:00 | 2012-04-26 00:00:00 | 269784 | 354469148A | Primary | Smith, George | 25682 | 22 | 21 |  | 0 | 0 | 0 | 687 | 337 | 0 |  | Delay | IVR | 2011-11-16 00:00:00 | Denied on 06/11/2012 as "This care may be Overdue per COB" | INWN |  | WOB | SPFUS0-F 8SD0FS | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | J1414 | 21 | 43 |  | 0 | 0 | 0 | 189 |  | 0 |  |  |  |  |  | INWN |  | WOB |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  | J8585 | 22 | 1321 |  | 0 | 0 | 0 | 419 |  | 0 |  |  |  |  |  | INWN |  | TOL |  | Overdue
 | Medicare |  |  |  |  |  |  |  |  |  |  |  |  | 476 | 0 | 0 |  | 678 |  |  |  |  |  |  |  | INWN |  | TOL |  | Overdue
10 | UHC | Morgan, [NAME] | 6306 | 1128465 | 1988-12-26 00:00:00 | 2011-10-26 00:00:00 | 111548795 | 981542689 | Primary | Smith, George | 91254-25 | 25 | 32132 |  | 0 | 0 | 0 | 19 |  | 374.04 |  | Finsihed | IVR | 2011-12-01 00:00:00 | afa;fljasd;l f;ska;f ;lsad | IN PROGRESS | ;LJKF DKSFJ;LSADJF;S A | TOL | SD9 8FSF80S8F0D 8S09FS | Payment
 | UHC |  |  |  |  |  |  |  |  |  | 87978 | 1 | 31 |  | 0 | 0 | 0 | 674 |  | 0 |  |  |  |  |  | IN PROGRESS |  | FINISHED |  | Payment
 | UHC |  |  |  |  |  |  |  |  |  | 87845 | 2 | 1 |  | 0 | 0 | 0 | 198 |  | 0 |  |  |  |  |  | IN PROGRESS |  | FINISHED |  | Payment
 | UHC |  |  |  |  |  |  |  |  |  | 58426 | 9 | 4 |  | 0 | 0 | 0 | 489 |  | 0 |  |  |  |  |  | IN PROGRESS |  | In Progress |  | Payment
 | UHC |  |  |  |  |  |  |  |  |  | 95715 | 22 | 3 |  | 0 | 0 | 0 | 687 |  | 0 |  |  |  |  |  | WOB |  | In Progress |  | Payment
 | UHC |  |  |  |  |  |  |  |  |  |  |  | 321132 | 458498 | 0 | 0 |  | 189 | 4582 |  |  |  |  |  |  | WOB |  | WOB |  | Payment
11 | UHC | Morgan, [NAME] | 6306 | 2291747 | 1988-12-26 00:00:00 | 2011-11-23 00:00:00 | 111548795 | 981542689 | Primary | Smith, George | 14362-25 | 1 | 113 |  | 0 | 0 | 0 | 49 |  | 374.04 |  | Delay | IVR | 2012-01-05 00:00:00 | qrpueiwpri a;zk ;vckk;vc k;l | FINISHED | S;DJF ADSJL;FJ ;SDA J | WOB | [NAME] | Payment
 | UHC |  |  |  |  |  |  |  |  |  | 24397 | 15 | 45 |  | 0 | 0 | 0 | 687 |  | 0 |  |  |  |  |  | INWN |  | In Progress |  | Payment
 | UHC |  |  |  |  |  |  |  |  |  | 24695 | 27 | 3 |  | 0 | 0 | 0 | 19 |  | 0 |  |  |  |  |  | INWN |  | TOL |  | Payment
 | UHC |  |  |  |  |  |  |  |  |  | 12544 | 16 | 2 |  | 0 | 0 | 0 | 67 |  | 0 |  |  |  |  |  | NOE |  | TOL |  | Payment
 | UHC |  |  |  |  |  |  |  |  |  | 25189 | 11 | 321 |  | 0 | 0 | 0 | 19 |  | 0 |  |  |  |  |  | NOE |  | TOL |  | Payment
 | UHC |  |  |  |  |  |  |  |  |  |  |  | 3213 | 2545 | 0 | 0 |  | 678 | 4582 |  |  |  |  |  |  | INWN |  | TOL |  | Payment
12 | Cigna | Smith,[NAME] | 5740 | 4862948 | 1938-03-15 00:00:00 | 2011-12-28 00:00:00 | 2547811 | U154871523 | Primary | Smith, George | 36259 | 1 | 5 |  | 0 | 0 | 31 | 149 |  | 0 |  | Finsihed | IVR | 2012-01-31 00:00:00 | faf;lkas f;lakf ;;sdk f a | IN PROGRESS | AJF ASJ;F ;LJDSJF | TOL | S=-9F SF9- [NAME] D9F- | Payment
 | Cigna |  |  |  |  |  |  |  |  |  |  |  | 1458 | 563 | 0 | 0 | 0 | 67 | 34 | 0 |  |  |  |  |  | INWN |  | FINISHED |  | Payment
13 | Cigna | Lucas, [NAME] | 7895 | 2442344 | 1960-11-19 00:00:00 | 2011-11-07 00:00:00 | 2547811 | U115421125 | Primary | Smith, George | 25411 | 36 | 12154 | 56 | 0 | 0 | 0 | 189 | 120 | 0 |  | Crossover | IVR | 2012-06-04 00:00:00 | afad;lk pfjpodk pof akjspofjposda | FINISHED |  | TOL | S-09F S9-F9 S- F-0 | Another