Spreadsheet: 794382d1662024715-top-25-revenues-and-relative-revenue-for-a-specifc-country-in-a-big-table-forum1
Sheet: Blad5

Product & country | Product | Country | Revenu | Volume | Revenu per product | % from total for that country | Rank for that country | If revenue in top 25% of that country, 'yes', if not 'no'. Will only show 'yes' in cell i13, i24, i26 and i27 (add up to 25% ---> i24 is OK to add even is crosses 25%)
 | A | NL | 15 | 1 |  |  |  | Which formula? Must show 'no'
 | B | NL | 2 | 3 |  |  |  | Which formula? Must show 'no'
 | C | NL | 6 | 5 |  |  |  | Which formula? Must show 'no'
 | D | NL | 4 | 7 |  |  |  | Which formula? Must show 'no'
 | E | NL | 6 | 9 |  |  |  | Which formula? Must show 'no'
 | F | NL | 6 | 11 |  |  |  | Which formula? Must show 'no'
 | G | NL | 7 | 13 |  |  |  | Which formula? Must show 'no'
 | H | NL | 8 | 15 |  |  |  | Which formula? Must show 'no'
 | I | NL | 9 | 17 |  |  |  | Which formula? Must show 'no'
 | J | NL | 10 | 19 |  |  |  | Which formula? Must show 'no'
 | K | NL | 11 | 21 |  |  |  | Which formula? Must show 'no'
 | L | NL | 42 | 6 |  |  |  | Which formula? Must show 'yes'
 | M | NL | 8 | 25 |  |  |  | Which formula? Must show 'no'
 | N | NL | 14 | 27 |  |  |  | Which formula? Must show 'no'
 | O | NL | 15 | 54 |  |  |  | Which formula? Must show 'no'
 | P | NL | 16 | 31 |  |  |  | Which formula? Must show 'no'
 | Q | NL | 17 | 33 |  |  |  | Which formula? Must show 'no'
 | R | NL | 18 | 35 |  |  |  | Which formula? Must show 'no'
 | S | NL | 19 | 37 |  |  |  | Which formula? Must show 'no'
 | T | NL | 20 | 8 |  |  |  | Which formula? Must show 'no'
 | U | NL | 21 | 41 |  |  |  | Which formula? Must show 'no'
 | V | NL | 22 | 43 |  |  |  | Which formula? Must show 'no'
 | W | NL | 23 | 9 |  |  |  | Which formula? Must show 'yes'
 | X | NL | 9 | 47 |  |  |  | Which formula? Must show 'no'
 | Y | NL | 25 | 49 |  |  |  | Which formula? Must show 'yes'
 | Z | NL | 26 | 51 |  |  |  | Which formula? Must show 'yes'
 | A | FR | 21 | 41 |  | Can formula in cell g1-g27 be rebuild so it applies to all countries (just one formula to drag down iso per country?) | Can formula in cell h1-h27 be rebuild so it applies to all countries (just one formula to drag down per country?) | Which formula? Must show 'no'
 | B | FR | 22 | 43 |  | Can formula in cell g1-g27 be rebuild so it applies to all countries (just one formula to drag down iso per country?) | Can formula in cell h1-h27 be rebuild so it applies to all countries (just one formula to drag down per country?) | Which formula? Must show 'no'
 | C | FR | 23 | 9 |  | Can formula in cell g1-g27 be rebuild so it applies to all countries (just one formula to drag down iso per country?) | Can formula in cell h1-h27 be rebuild so it applies to all countries (just one formula to drag down per country?) | Which formula? Must show 'no'
 | D | FR | 9 | 47 |  | Can formula in cell g1-g27 be rebuild so it applies to all countries (just one formula to drag down iso per country?) | Can formula in cell h1-h27 be rebuild so it applies to all countries (just one formula to drag down per country?) | Which formula? Must show 'no'
 | E | FR | 25 | 49 |  | Can formula in cell g1-g27 be rebuild so it applies to all countries (just one formula to drag down iso per country?) | Can formula in cell h1-h27 be rebuild so it applies to all countries (just one formula to drag down per country?) | Which formula? Must show 'no'
 | F | FR | 26 | 51 |  | Can formula in cell g1-g27 be rebuild so it applies to all countries (just one formula to drag down iso per country?) | Can formula in cell h1-h27 be rebuild so it applies to all countries (just one formula to drag down per country?) | Which formula? Must show 'no'
 | G | FR | 3 | 51 |  | Can formula in cell g1-g27 be rebuild so it applies to all countries (just one formula to drag down iso per country?) | Can formula in cell h1-h27 be rebuild so it applies to all countries (just one formula to drag down per country?) | Which formula? Must show 'no'
 | H | FR | 9 | 51 |  | Can formula in cell g1-g27 be rebuild so it applies to all countries (just one formula to drag down iso per country?) | Can formula in cell h1-h27 be rebuild so it applies to all countries (just one formula to drag down per country?) | Which formula? Must show 'no'
 | I | FR | 5 | 51 |  | Can formula in cell g1-g27 be rebuild so it applies to all countries (just one formula to drag down iso per country?) | Can formula in cell h1-h27 be rebuild so it applies to all countries (just one formula to drag down per country?) | Which formula? Must show 'no'
 |  | Many more countries to add
 |  | Many more countries to add
 |  | Many more countries to add
 |  | Many more countries to add
 |  | Many more countries to add
 |  | Many more countries to add
 |  | Many more countries to add
 |  | Many more countries to add
 |  | Many more countries to add
 |  | Many more countries to add