Spreadsheet: 842589d1694616523-need-formula-to-list-out-ratio-of-ledger-from-duplicates-ledger_calculation-alternative-solution-
Sheet: Metrics_Rank

Co Code | [NAME] | Count | Percentage | Count |  | [NAME] |  | Co Code | Australia Primary | Chile Primary | China Primary | [NAME] | France Primary | GB Primary | Germany Primary | Greece Primary | Total | [NAME] | Ledger | Rank Mertics
0I91_117043_A11999 | Australia Primary |  | 0.6 |  |  | Less than 100% |  | 0I91_117043_A11999
0I91_117043_A11999 | Chile Primary |  | 0.2 |  |  | 1 |  | 0I91_120000_A12099
0I91_117043_A11999 | Australia Primary |  | 0.6 |  |  |  |  | 0I91_120988_A12099
0I91_117043_A11999 | [NAME] |  | 0.2 |  |  |  |  | 0I91_125111_A12829
0I91_117043_A11999 | Australia Primary |  | 0.6 |  |  |  |  | 0I91_125400_A12549
0I91_120000_A12099 | Chile Primary |  | 0.6 |  |  |  |  | 0I91_132350_A13239
0I91_120000_A12099 | Chile Primary |  | 0.6 |  |  |  |  | 0I91_132600_A13269
0I91_120000_A12099 | [NAME] |  | 0.2 |  |  |  |  | 0I91_151000_A15199
0I91_120000_A12099 | Greece Primary |  | 0.2 |  |  |  |  | 0I91_160300_A16999
0I91_120000_A12099 | Chile Primary |  | 0.6
0I91_120988_A12099 | [NAME] |  | 0.1428571428571428 |  |  |  |  |  | expected result in top table
0I91_120988_A12099 | France Primary |  | 0.1428571428571428 |  |  |  |  | Co Code | Australia Primary | Chile Primary | China Primary | [NAME] | France Primary | GB Primary | Germany Primary | Greece Primary | Total | [NAME] | Ledger | Rank Mertics
0I91_120988_A12099 | China Primary |  | 0.4285714285714285 |  |  |  |  | 0I91_117043_A11999 | 3 (60%) | 1 (20%) | - | 1 (20%) | - | - | - | - | 1 | 3 (60%) | Australia Primary | 3
0I91_120988_A12099 | Australia Primary |  | 0.1428571428571428 |  |  |  |  | 0I91_120000_A12099 | - | 3 (60%) | - | 1 (20%) | - | - | - | 1 (20%) | 1 | 3 (60%) | Chile Primary | 3
0I91_120988_A12099 | China Primary |  | 0.4285714285714285 |  |  |  |  | 0I91_120988_A12099 | - | 1 (14.29%) | 3 (42.86%) | 1 (14.29%) | 1 (14.29%) | - | - | - | 1 | 3 (42.86%) | China Primary | 4
0I91_120988_A12099 | Chile Primary |  | 0.1428571428571428 |  |  |  |  | 0I91_125111_A12829 | 1 (16.67%) | 1 (16.67%) | - | 4 (66.67%) | - | - | - | - | 1 | 4 (86.74%) | [NAME] | 2
0I91_120988_A12099 | China Primary |  | 0.4285714285714285 |  |  |  |  | 0I91_125400_A12549 | - | - | - | - | (6) 100% | - | - | - | 1 | (6) 100% | France Primary | 1
0I91_125111_A12829 | [NAME] |  | 0.6666666666666666 |  |  |  |  | 0I91_132350_A13239 | - | - | - | - | - | (2) 100% | - | - | 1 | (2) 100% | GB Primary | 1
0I91_125111_A12829 | Chile Primary |  | 0.1666666666666667 |  |  |  |  | 0I91_132600_A13269 | - | - | - | - | 2 (33.33%) | 2 (33.33%) | 1 (16.67%) | 1 (16.67%) | 1 | 2 (33.33%) & 2 (33.33%) | France Primary & GB Primary | 6
0I91_125111_A12829 | Australia Primary |  | 0.1666666666666667 |  |  |  |  | 0I91_151000_A15199 | - | - | - | - | 1 (20%) | 1 (20%) | 3 (60%) | - | 1 | 3 (60%) | Germany Primary | 3
0I91_125111_A12829 | [NAME] |  | 0.6666666666666666 |  |  |  |  | 0I91_160300_A16999 | - | - | - | - | 1 (20%) | 1 (20%) | 1 (20%) | 2 (40%) | 1 | 2 (40%) | Greece Primary | 5
0I91_125111_A12829 | [NAME] |  | 0.6666666666666666
0I91_125111_A12829 | [NAME] |  | 0.6666666666666666
0I91_125400_A12549 | France Primary |  | 1
0I91_125400_A12549 | France Primary |  | 1
0I91_125400_A12549 | France Primary |  | 1
0I91_125400_A12549 | France Primary |  | 1
0I91_125400_A12549 | France Primary |  | 1
0I91_125400_A12549 | France Primary |  | 1
0I91_132350_A13239 | GB Primary |  | 1
0I91_132350_A13239 | GB Primary |  | 1
0I91_132600_A13269 | GB Primary |  | 0.3333333333333333
0I91_132600_A13269 | GB Primary |  | 0.3333333333333333
0I91_132600_A13269 | Germany Primary |  | 0.1666666666666667
0I91_132600_A13269 | Greece Primary |  | 0.1666666666666667
0I91_132600_A13269 | France Primary |  | 0.3333333333333333
0I91_132600_A13269 | France Primary |  | 0.3333333333333333
0I91_151000_A15199 | Germany Primary |  | 0.6
0I91_151000_A15199 | France Primary |  | 0.2
0I91_151000_A15199 | GB Primary |  | 0.2
0I91_151000_A15199 | Germany Primary |  | 0.6
0I91_151000_A15199 | Germany Primary |  | 0.6
0I91_160300_A16999 | Greece Primary |  | 0.4
0I91_160300_A16999 | France Primary |  | 0.2
0I91_160300_A16999 | GB Primary |  | 0.2
0I91_160300_A16999 | Germany Primary |  | 0.2
0I91_160300_A16999 | Greece Primary |  | 0.4