Spreadsheet: 822441d1679351234-need-formula-to-find-duplicates-beyond-repts-vlaue-of-b-and-d-repeat_formula
Sheet: Sheet1

[NAME] | ORDER ID | Parent [NAME] 2 | Ledger | Updated EC | Account | [NAME] Here
[NAME] | 8484885 | XM000|100675|OFSS Australia Primary|0I91|0000 | USA | OFSS India Primary | Corporate | 1 | Original
[NAME] | 8484885 | XM000|100700|OFSS Australia Primary|0I91|0000 | USA | OFSS India Primary | Corporate | 1 | Original
[NAME] | 8484886 | XM000|100700|OFSS Australia Primary|0I91|0I70 | CHINA | RBS Int-0CS7-165880-58681854-USD | Busness | 1 | Original
xxx | 8484887 | XM000|100700|OFSS Australia Primary|0I91|0I71 | CHINA | RBS Int-0CS7-165880-58681854-USD | Busness | 1 | Original
xxx | 8484888 | XM000|100700|OFSS Australia Primary|0I91|0I73 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 1 | Original
xxx | 8484888 | XM000|100700|OFSS Australia Primary|0I91|0I75 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 1 | Original
xxx | 8484888 | XM000|100700|OFSS Australia Primary|0I91|0I77 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 1 | Original
xxx | 8484888 | XM000|100700|OFSS Australia Primary|0I91|0I89 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 1 | Original
xxx | 8484892 | XM000|100700|OFSS Australia Primary|0I91|0I73 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 2 | Duplicate
xxx | 8484892 | XM000|100700|OFSS Australia Primary|0I91|0I75 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 2 | Duplicate
xxx | 8484892 | XM000|100700|OFSS Australia Primary|0I91|0I77 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 2 | Duplicate
xxx | 8484892 | XM000|100700|OFSS Australia Primary|0I91|0I89 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 2 | Duplicate
xxx | 8484765 | XM000|109802|OFSS Australia Primary|0I91|0I89 | CANADA | OFSS-0I88-40807810100501273004-CITI-RU-RUB | Corporate | 1 | Original
xxx | 8484765 | XM000|109802|OFSS Australia Primary|0I91|0I89 | CANADA | OFSS-0I88-40807810100501273004-CITI-RU-RUB | Corporate | 1 | Original
xxx | 8484809 | XM000|100700|OFSS Australia Primary|0I91|0I70 | CHINA | RBS Int-0CS7-165880-58681854-USD | Busness | 2 | Duplicate
xxx | 8484809 | XM000|100700|OFSS Australia Primary|0I91|0I71 | CHINA | RBS Int-0CS7-165880-58681854-USD | Busness | 2 | Duplicate
xxx | 454444 | XM000|100701|OFSS Australia Primary|0I91|0000 | IND | OFSS-0I70-[PHONE]-HDFC-HO-USD | Commercial | 1 | Original
xxx | 454444 | XM000|120001|OFSS Australia Primary|0I91|0000 | IND | OFSS-0I70-[PHONE]-HDFC-HO-USD | Commercial | 1 | Original
xxx | 454443 | XM000|129502|OFSS Australia Primary|0I91|0000 | IND | Corp Inbound Freight | Busness | 1 | Original
[NAME] | E54444 | XM000|100700|OFSS Australia Primary|0I91|0I70 | CHINA | RBS Int-0CS7-165880-58681854-USD | Busness | 2 | Duplicate
[NAME] | 9737471 | XM000|100700|OFSS Australia Primary|0I91|0I73 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 3 | Duplicate
[NAME] | 9737471 | XM000|100700|OFSS Australia Primary|0I91|0I75 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 3 | Duplicate
[NAME] | 9737471 | XM000|100700|OFSS Australia Primary|0I91|0I77 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 3 | Duplicate
[NAME] | 9737471 | XM000|100700|OFSS Australia Primary|0I91|0I89 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 3 | Duplicate