Spreadsheet: 822495d1679383602-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 | Expected Result |  | formula result
[NAME] | 8484885 | XM000|100675|OFSS Australia Primary|0I91|0000 | USA | OFSS India Primary | Corporate | 1
[NAME] | 8484885 | XM000|100700|OFSS Australia Primary|0I91|0000 | USA | OFSS India Primary | Corporate | 1
[NAME] | 8484886 | XM000|100700|OFSS Australia Primary|0I91|0I70 | CHINA | RBS Int-0CS7-165880-58681854-USD | Busness | 1
xxx | 8484887 | XM000|100700|OFSS Australia Primary|0I91|0I71 | CHINA | RBS Int-0CS7-165880-58681854-USD | Busness | 1
xxx | 8484888 | XM000|100700|OFSS Australia Primary|0I91|0I73 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 1
xxx | 8484888 | XM000|100700|OFSS Australia Primary|0I91|0I75 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 1
xxx | 8484888 | XM000|100700|OFSS Australia Primary|0I91|0I77 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 1
xxx | 8484888 | XM000|100700|OFSS Australia Primary|0I91|0I89 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 1
xxx | 8484892 | XM000|100700|OFSS Australia Primary|0I91|0I73 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 2
xxx | 8484892 | XM000|100700|OFSS Australia Primary|0I91|0I75 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 2
xxx | 8484892 | XM000|100700|OFSS Australia Primary|0I91|0I77 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 2
xxx | 8484892 | XM000|100700|OFSS Australia Primary|0I91|0I89 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 2
xxx | 8484765 | XM000|109802|OFSS Australia Primary|0I91|0I89 | CANADA | OFSS-0I88-40807810100501273004-CITI-RU-RUB | Corporate | 1
xxx | 8484765 | XM000|109802|OFSS Australia Primary|0I91|0I99 | CANADA | OFSS-0I88-40807810100501273004-CITI-RU-CAN | Corporate | 1
xxx | 8484809 | XM000|100700|OFSS Australia Primary|0I91|0I70 | CHINA | RBS Int-0CS7-165880-58681854-USD | Busness | 2
xxx | 8484809 | XM000|100700|OFSS Australia Primary|0I91|0I71 | CHINA | RBS Int-0CS7-165880-58681854-USD | Busness | 2
xxx | 454444 | XM000|100701|OFSS Australia Primary|0I91|0000 | IND | OFSS-0I70-[PHONE]-HDFC-HO-USD | Commercial | 1
xxx | 454444 | XM000|120001|OFSS Australia Primary|0I91|0000 | IND | OFSS-0I70-[PHONE]-HDFC-HO-USD | Commercial | 1
xxx | 454443 | XM000|129502|OFSS Australia Primary|0I91|0000 | IND | Corp Inbound Freight | Busness | 1
[NAME] | E54444 | XM000|100700|OFSS Australia Primary|0I91|0I70 | CHINA | RBS Int-0CS7-165880-58681854-USD | Busness | 2
[NAME] | 9737471 | XM000|100700|OFSS Australia Primary|0I91|0I73 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 3
[NAME] | 9737471 | XM000|100700|OFSS Australia Primary|0I91|0I75 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 3
[NAME] | 9737471 | XM000|100700|OFSS Australia Primary|0I91|0I77 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 3
[NAME] | 9737471 | XM000|100700|OFSS Australia Primary|0I91|0I89 | JAPAN | OFSS-0IA1-[PHONE]-HDFC-Mauritius-USD | Commercial | 3
xxx | 33333 | XM000|100700|OFSS Australia Primary|0I91|0I73 | RUSSIA | Corp Inv Adj/PI/Cycle Count/Other | Busness | 1
[NAME] | 33333 | XM000|129502|OFSS Australia Primary|0I91|0000 | RUSSIA | Corp Inv Adj/PI/Cycle Count/Other | Busness | 1
xxx | 484884 | XM000|100700|OFSS Australia Primary|0I91|0I73 | RUSSIA | Corp Inv Adj/PI/Cycle Count/Other | Busness | 2
[NAME] | 484884 | XM000|129502|OFSS Australia Primary|0I91|0000 | RUSSIA | Corp Inv Adj/PI/Cycle Count/Other | Busness | 2