Spreadsheet: 786982d1657573851-identifying-most-to-least-with-up-to-8-duplicates-book4
Sheet: Public

1st try with Large  (Doesn’t yield desired results) | Data to test fx | Data to test fx | Data to test fx | fx testing it find solution |  |  |  |  |  |  | This is the way I am designing my solution in my Real-world implementation.
Most to Least | Collection Name | Index# | Count | TieBreakerCount | Rank | Match | Index Name | Index Count | Index TieBreak/BackTest
 | Bulbasaur | 1 | 42
 | Ivysaur | 2 | 64 |  |  |  |  |  |  | Col | [NAME]
 | Venusaur | 3 | 18 |  |  |  |  |  |  | J | 1 | Index TieBreak/BackTest
 | Charmander | 4 | 20 |  |  |  |  |  |  | I | 2 | Index Count
 | Charmeleon | 5 | 11 |  |  |  |  |  |  | H | 3 | Index Name
 | Charizard | 6 | 5 |  |  |  |  |  |  | G | 4 | Match
 | Squirtle | 7 | 23 |  |  |  |  |  |  | F | 5 | Rank
 | Wartortle | 8 | 34 |  |  |  |  |  |  | E | 6 | TieBreakerCount
 | [NAME] | 9 | 202 |  |  |  |  |  |  | D | 7 | Count | 42 | 64 | 18 | 20 | 11 | 5 | 23 | 34 | 202 | 19 | 35 | 52 | 22 | 347 | 7 | 19 | 10 | 739 | 30 | 13 | 30 | 7 | 58 | 22 | 190 | 95 | 29 | 4 | 67 | 35 | 4 | 12 | 16 | 17 | 4 | 63 | 5 | 87 | 10 | 19 | 100 | 43 | 41 | 40 | 28 | 8 | 39 | 45 | 2104 | 28 | 28 | 3 | 10 | 10 | 13 | 28 | 19 | 44 | 12 | 61 | 12 | 9 | 29 | 15 | 72 | 1 | 15 | 21 | 44 | 8 | 18 | 17 | 15 | 71 | 53 | 30 | 11 | 5 | 7 | 30 | 57 | 143 | 8 | 57 | 18 | 21 | 10 | 90 | 56 | 22 | 59 | 22 | 36 | 14 | 65 | 23 | 9 | 19 | 11 | 14 | 11 | 13 | 12 | 7 | 34 | 18 | 33 | 18 | 18 | 20 | 39 | 26 | 20 | 29 | 17 | 27 | 22 | 19 | 53 | 37 | 26 | 30 | 65 | 417 | 7 | 248 | 137 | 19 | 37 | 54 | 80 | 55 | 28 | 23 | 60 | 4 | 8 | 9 | 15 | 16 | 19 | 7 | 22 | 4 | 37 | 15 | 15 | 24 | 18
 | Caterpie | 10 | 19 |  |  |  |  |  |  | C | 8 | Index# | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149
 | Metapod | 11 | 35 |  |  |  |  |  |  | B | 9 | Collection Name | Bulbasaur | Ivysaur | Venusaur | Charmander | Charmeleon | Charizard | Squirtle | Wartortle | [NAME] | Caterpie | Metapod | Butterfree | Weedle | Kakuna | Beedrill | Pidgey | Pidgeotto | Pidgeot | Rattata | Raticate | Spearow | Fearow | Ekans | Arbok | Pikachu | Raichu | Sandshrew | Sandslash | Nidoran♀ | Nidorina | Nidoqueen | Nidoran♂ | Nidorino | Nidoking | Clefairy | Clefable | Vulpix | Ninetales | Jigglypuff | Wigglytuff | [NAME] | Golbat | Oddish | Gloom | Vileplume | Paras | Parasect | Venonat | Venomoth | Diglett | Dugtrio | Meowth | Persian | Psyduck | Golduck | Mankey | Primeape | Growlithe | Arcanine | Poliwag | Poliwhirl | Poliwrath | Abra | Kadabra | Alakazam | Machop | Machoke | Machamp | Bellsprout | Weepinbell | Victreebel | Tentacool | Tentacruel | Geodude | Graveler | Golem | Ponyta | [NAME] | Slowpoke | Slowbro | Magnemite | [NAME] | Farfetch'd | Doduo | Dodrio | Seel | Dewgong | [NAME] | Muk | Shellder | Cloyster | Gastly | Haunter | Gengar | Onix | Drowzee | Hypno | Krabby | Kingler | Voltorb | Electrode | Exeggcute | Exeggutor | Cubone | [NAME] | [NAME] | Hitmonchan | [NAME] | Koffing | Weezing | Rhyhorn | Rhydon | Chansey | [NAME] | Kangaskhan | Horsea | Seadra | Goldeen | Seaking | Staryu | Starmie | Mr. [NAME] | Scyther | Jynx | Electabuzz | [NAME] | Pinsir | Tauros | Magikarp | Gyarados | Lapras | Ditto | Eevee | Vaporeon | Jolteon | Flareon | Porygon | [NAME] | Omastar | Kabuto | Kabutops | Aerodactyl | Snorlax | Articuno | Zapdos | Moltres | Dratini | Dragonair | Dragonite
 | Butterfree | 12 | 52
 | Weedle | 13 | 22
 | Kakuna | 14 | 347
 | Beedrill | 15 | 7
 | Pidgey | 16 | 19
 | Pidgeotto | 17 | 10
 | Pidgeot | 18 | 739
 | Rattata | 19 | 30
 | Raticate | 20 | 13
 | Spearow | 21 | 30
 | Fearow | 22 | 7
 | Ekans | 23 | 58
 | Arbok | 24 | 22
 | Pikachu | 25 | 190
 | Raichu | 26 | 95
 | Sandshrew | 27 | 29
 | Sandslash | 28 | 4
 | Nidoran♀ | 29 | 67
 | Nidorina | 30 | 35
 | Nidoqueen | 31 | 4
 | Nidoran♂ | 32 | 12
 | Nidorino | 33 | 16
 | Nidoking | 34 | 17
 | Clefairy | 35 | 4
 | Clefable | 36 | 63
 | Vulpix | 37 | 5
 | Ninetales | 38 | 87
 | Jigglypuff | 39 | 10
 | Wigglytuff | 40 | 19
 | [NAME] | 41 | 100
 | Golbat | 42 | 43
 | Oddish | 43 | 41
 | Gloom | 44 | 40
 | Vileplume | 45 | 28
 | Paras | 46 | 8
 | Parasect | 47 | 39
 | Venonat | 48 | 45
 | Venomoth | 49 | 2104
 | Diglett | 50 | 28
 | Dugtrio | 51 | 28
 | Meowth | 52 | 3
 | Persian | 53 | 10
 | Psyduck | 54 | 10
 | Golduck | 55 | 13
 | Mankey | 56 | 28
 | Primeape | 57 | 19
 | Growlithe | 58 | 44
 | Arcanine | 59 | 12
 | Poliwag | 60 | 61
 | Poliwhirl | 61 | 12
 | Poliwrath | 62 | 9
 | Abra | 63 | 29
 | Kadabra | 64 | 15
 | Alakazam | 65 | 72
 | Machop | 66 | 1
 | Machoke | 67 | 15
 | Machamp | 68 | 21
 | Bellsprout | 69 | 44
 | Weepinbell | 70 | 8
 | Victreebel | 71 | 18
 | Tentacool | 72 | 17
 | Tentacruel | 73 | 15
 | Geodude | 74 | 71
 | Graveler | 75 | 53
 | Golem | 76 | 30
 | Ponyta | 77 | 11
 | [NAME] | 78 | 5
 | Slowpoke | 79 | 7
 | Slowbro | 80 | 30
 | Magnemite | 81 | 57
 | [NAME] | 82 | 143
 | Farfetch'd | 83 | 8
 | Doduo | 84 | 57
 | Dodrio | 85 | 18
 | Seel | 86 | 21
 | Dewgong | 87 | 10
 | [NAME] | 88 | 90
 | Muk | 89 | 56
 | Shellder | 90 | 22
 | Cloyster | 91 | 59
 | Gastly | 92 | 22
 | Haunter | 93 | 36
 | Gengar | 94 | 14
 | Onix | 95 | 65
 | Drowzee | 96 | 23
 | Hypno | 97 | 9
 | Krabby | 98 | 19
 | Kingler | 99 | 11
 | Voltorb | 100 | 14
 | Electrode | 101 | 11
 | Exeggcute | 102 | 13
 | Exeggutor | 103 | 12
 | Cubone | 104 | 7
 | [NAME] | 105 | 34
 | [NAME] | 106 | 18
 | Hitmonchan | 107 | 33
 | [NAME] | 108 | 18
 | Koffing | 109 | 18
 | Weezing | 110 | 20
 | Rhyhorn | 111 | 39
 | Rhydon | 112 | 26
 | Chansey | 113 | 20
 | [NAME] | 114 | 29
 | Kangaskhan | 115 | 17
 | Horsea | 116 | 27
 | Seadra | 117 | 22
 | Goldeen | 118 | 19
 | Seaking | 119 | 53
 | Staryu | 120 | 37
 | Starmie | 121 | 26
 | Mr. [NAME] | 122 | 30
 | Scyther | 123 | 65
 | Jynx | 124 | 417
 | Electabuzz | 125 | 7
 | [NAME] | 126 | 248
 | Pinsir | 127 | 137
 | Tauros | 128 | 19
 | Magikarp | 129 | 37
 | Gyarados | 130 | 54
 | Lapras | 131 | 80
 | Ditto | 132 | 55
 | Eevee | 133 | 28
 | Vaporeon | 134 | 23
 | Jolteon | 135 | 60
 | Flareon | 136 | 4
 | Porygon | 137 | 8
 | [NAME] | 138 | 9
 | Omastar | 139 | 15
 | Kabuto | 140 | 16
 | Kabutops | 141 | 19
 | Aerodactyl | 142 | 7
 | Snorlax | 143 | 22
 | Articuno | 144 | 4
 | Zapdos | 145 | 37
 | Moltres | 146 | 15
 | Dratini | 147 | 15
 | Dragonair | 148 | 24
 | Dragonite | 149 | 18