need to query for value under name and header i.e. NAME, PWR to get x
pretty sure this is ineffective asf but im a noob
2nd minisheet shows next table, to include fixed +/- values & % change
thanks in advance :D
pretty sure this is ineffective asf but im a noob
2nd minisheet shows next table, to include fixed +/- values & % change
thanks in advance :D
| MMDS STATS.xlsx | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | J | K | L | |||
| 1 | DAY7WK1 | NAME | PWR | HELPS | DAY1WK2 | NAME | PWR | PWR+/- | PWR% | HELPS | DONO | |||
| 2 | 3/07/2022 | 17thSenturion | 3,571,296 | 257 | 4/07/2022 | 17thSenturion | 3,581,836 | - | - | 17 | 6800 | |||
| 3 | 25Apples | 4,362,755 | 2282 | 25Apples | 4,459,055 | - | - | 377 | 12900 | |||||
| 4 | 25Appless | 2,841,209 | 1483 | 25Appless | 3,021,778 | - | - | 255 | 5800 | |||||
| 5 | Abyss | 3,566,652 | 1729 | Abyss | 3,844,449 | - | - | 180 | 6400 | |||||
| 6 | ACU | 2,672,831 | 1449 | ACU | 2,918,571 | - | - | 234 | 11200 | |||||
| 7 | Aftloon | 2,573,385 | 1076 | Aftloon | 2,806,577 | - | - | 124 | 11000 | |||||
| 8 | Animeda | 5,917,368 | 2606 | Animeda | 6,127,917 | - | - | 197 | 14000 | |||||
| 9 | Arkey | 4,206,327 | 1259 | Arkey | 4,241,455 | - | - | 222 | 12700 | |||||
| 10 | Arnoldsss | 19,503,383 | 1053 | Arnoldsss | 20,154,745 | - | - | 203 | 10400 | |||||
| 11 | Balder | 4,315,323 | 4364 | Balder | 4,392,143 | - | - | 570 | 10100 | |||||
| 12 | Battousai | 3,239,073 | 536 | Battousai | 3,364,992 | - | - | 57 | 11200 | |||||
| 13 | BiBiKuKu | 2,919,804 | 1570 | BiBiKuKu | 2,966,349 | - | - | 241 | 6300 | |||||
| 14 | BlazinRad | 5,733,181 | 1471 | BlazinRad | 6,328,993 | - | - | 209 | 12600 | |||||
| 15 | BlessedDevil | 3,335,729 | 322 | BlessedDevil | 3,472,566 | - | - | 240 | 10300 | |||||
| 16 | BulkyPear | 2,837,475 | 2220 | BulkyPear | 2,965,212 | - | - | 208 | 10500 | |||||
| 17 | CarbonNinja | 3,973,050 | 1181 | Can1cai | 4,537,608 | - | - | 367 | 5200 | |||||
| 18 | Champ | 6,236,915 | 539 | CarbonNinja | 4,104,010 | - | - | 303 | 7800 | |||||
| 19 | Contemption | 3,674,507 | 1800 | Champ | 6,256,815 | - | - | 67 | 6800 | |||||
| 20 | Creepybong | 3,195,354 | 1861 | Contemption | 3,993,404 | - | - | 212 | 7500 | |||||
| 21 | Cyclonte | 2,812,636 | 810 | Creepybong | 3,281,898 | - | - | 186 | 10200 | |||||
| 22 | DemonCore | 3,241,903 | 1853 | Cyclonte | 2,900,938 | - | - | 172 | 10600 | |||||
| 23 | Diablo | 3,183,408 | 1544 | DemonCore | 3,384,724 | - | - | 291 | 10500 | |||||
| 24 | DragonHunter | 4,630,563 | 2165 | Diablo | 3,239,770 | - | - | 193 | 14500 | |||||
| 25 | Draztatic | 9,776,789 | 413 | DragonHunter | 4,842,751 | - | - | 333 | 10300 | |||||
| 26 | DuongNguyet | 4,209,838 | 2363 | Draztatic | 10,475,500 | - | - | 145 | 11200 | |||||
| 27 | El Narvalloo | 3,652,142 | 69 | DuongNguyet | 4,391,725 | - | - | 433 | 10000 | |||||
| 28 | emwhel2 | 3,072,040 | 555 | El Narvalloo | 3,686,548 | - | - | 0 | 0 | |||||
| 29 | ET Nguyen | 3,826,086 | 3114 | emwhel2 | 3,119,933 | - | - | 61 | 9600 | |||||
| 30 | EvilBunny | 2,999,718 | 1806 | ET Nguyen | 3,960,754 | - | - | 449 | 10200 | |||||
| 31 | F2P 2nd | 2,936,965 | 2451 | EvilBunny | 3,205,364 | - | - | 300 | 8800 | |||||
| 32 | Forever | 9,591,350 | 328 | F2P 2nd | 3,000,024 | - | - | 20 | 8000 | |||||
| 33 | fuze | 2,096,542 | 680 | Forever | 9,591,350 | - | - | 13 | 3200 | |||||
| 34 | gildark | 2,476,740 | 228 | fuze | 2,215,789 | - | - | 45 | 8100 | |||||
| 35 | Goober | 5,936,501 | 135 | gildark | 2,673,463 | - | - | 91 | 9400 | |||||
| 36 | HeroBack | 6,031,177 | 1240 | Goober | 5,983,620 | - | - | 35 | 7900 | |||||
| 37 | hidal1997 | 2,072,294 | 928 | HeroBack | 6,160,599 | - | - | 138 | 10200 | |||||
| 38 | HieuKuKu | 2,924,445 | 393 | hidal1997 | 2,137,302 | - | - | 106 | 9700 | |||||
| 39 | huynh | 2,715,815 | 837 | HieuKuKu | 2,995,238 | - | - | 172 | 5600 | |||||
| 40 | ImF2P | 2,755,280 | 1455 | huynh | 2,773,459 | - | - | 90 | 9900 | |||||
| 41 | JokerC | 4,733,989 | 1966 | ImF2P | 2,800,861 | - | - | 142 | 9600 | |||||
| 42 | Joshua | 6,843,301 | 1343 | JokerC | 5,160,613 | - | - | 212 | 14600 | |||||
| 43 | K2 KAMARO | 2,830,199 | 1588 | Joshua | 7,129,606 | - | - | 205 | 11600 | |||||
| 44 | Kaoru | 2,611,865 | 1575 | K2 KAMARO | 2,977,311 | - | - | 338 | 8700 | |||||
| 45 | Kirito | 3,179,100 | 910 | Kaoru | 2,877,913 | - | - | 161 | 6000 | |||||
| 46 | KurazyKaiko | 3,085,819 | 1710 | Kirito | 3,198,133 | - | - | 57 | 7100 | |||||
| 47 | Levine | 6,018,552 | 550 | KurazyKaiko | 3,171,454 | - | - | 77 | 7100 | |||||
| 48 | Light | 2,668,605 | 474 | Levine | 6,205,350 | - | - | 61 | 4500 | |||||
| 49 | LordBasti | 2,651,567 | 734 | Light | 2,684,627 | - | - | 15 | 0 | |||||
| 50 | mamamidnight | 2,246,102 | 218 | LordBasti | 2,756,103 | - | - | 139 | 8600 | |||||
| 51 | MD F2P | 4,192,234 | 1463 | mamamidnight | 2,256,002 | - | - | 14 | 4700 | |||||
| 52 | N1v3kdom | 3,136,995 | 159 | MD F2P | 4,399,330 | - | - | 231 | 9800 | |||||
| 53 | NazyaPisyn | 2,788,034 | 885 | N1v3kdom | 3,812,738 | - | - | 46 | 4400 | |||||
| 54 | NotDuck | 5,293,949 | 1881 | NazyaPisyn | 2,877,730 | - | - | 136 | 10800 | |||||
| 55 | Obito | 3,111,031 | 230 | NotDuck | 5,388,709 | - | - | 275 | 13100 | |||||
| 56 | Omega | 5,092,375 | 2692 | Obito | 3,129,332 | - | - | 31 | 4200 | |||||
| 57 | Oraura | 3,357,012 | 1179 | Omega | 5,159,541 | - | - | 352 | 13300 | |||||
| 58 | Pozharsky | 3,533,228 | 1322 | Oraura | 3,462,785 | - | - | 202 | 10400 | |||||
| 59 | PUNISHER | 4,109,488 | 1547 | Pozharsky | 3,615,483 | - | - | 246 | 5600 | |||||
| 60 | Q8EXTREME | 3,319,347 | 70 | PUNISHER | 4,111,288 | - | - | 0 | 0 | |||||
| 61 | Sahil | 3,709,327 | 2057 | Q8EXTREME | 3,442,435 | - | - | 26 | 9000 | |||||
| 62 | SallySue | 4,200,761 | 1577 | Sahil | 3,781,855 | - | - | 258 | 8200 | |||||
| 63 | Shade | 14,290,171 | 1469 | SallySue | 4,243,035 | - | - | 285 | 16300 | |||||
| 64 | ShadowKnight | 4,362,500 | 183 | Shade | 15,248,797 | - | - | 129 | 9000 | |||||
| 65 | SheepDuck | 14,026,933 | 1582 | ShadowKnight | 4,377,462 | - | - | 7 | 9300 | |||||
| 66 | Shirowe | 4,491,583 | 2771 | SheepDuck | 15,476,150 | - | - | 182 | 9200 | |||||
| 67 | SingleMom | 2,914,941 | 794 | Shirowe | 4,873,000 | - | - | 489 | 16200 | |||||
| 68 | SleepyBoy | 3,770,551 | 2333 | SingleMom | 3,031,157 | - | - | 106 | 8000 | |||||
| 69 | TBoRMaMkaTyT | 3,218,191 | 2195 | SleepyBoy | 3,928,396 | - | - | 215 | 5400 | |||||
| 70 | ThaiBach | 3,267,620 | 1399 | TBoRMaMkaTyT | 3,301,396 | - | - | 265 | 10000 | |||||
| 71 | TheWolf | 3,615,647 | 1043 | ThaiBach | 3,330,985 | - | - | 164 | 7100 | |||||
| 72 | Turtleus | 3,233,706 | 2011 | TheWolf | 3,711,853 | - | - | 80 | 11900 | |||||
| 73 | Wicat | 3,212,193 | 1104 | Turtleus | 3,346,196 | - | - | 243 | 11900 | |||||
| 74 | Winchester | 2,598,629 | 1105 | Wicat | 3,300,382 | - | - | 141 | 10700 | |||||
| 75 | Winnie | 2,546,204 | 1124 | Winchester | 2,655,800 | - | - | 126 | 9900 | |||||
| 76 | xAsi | 4,297,265 | 1168 | Winnie | 2,743,700 | - | - | 398 | 7500 | |||||
| 77 | Yuri | 2,589,133 | 845 | xAsi | 4,540,791 | - | - | 279 | 9600 | |||||
| 78 | Yuri | 2,649,986 | - | - | 185 | 10300 | ||||||||
Sheet1 | ||||||||||||||
| MMDS STATS.xlsx | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| N | O | P | Q | R | S | T | U | V | |||
| 1 | DAY2WK2 | NAME | PWR | PWR+ | PWR% | HELPS | HELPS+ | DONO | DONO+ | ||
| 2 | Arnoldsss | - | |||||||||
| 3 | Shade | - | |||||||||
| 4 | SheepDuck | - | |||||||||
| 5 | Draztatic | - | |||||||||
| 6 | Forever | - | |||||||||
| 7 | Joshua | - | |||||||||
| 8 | Champ | - | |||||||||
| 9 | HeroBack | - | |||||||||
| 10 | Levine | - | |||||||||
| 11 | Goober | - | |||||||||
| 12 | Animeda | - | |||||||||
| 13 | BlazinRad | - | |||||||||
| 14 | NotDuck | - | |||||||||
| 15 | Omega | - | |||||||||
| 16 | JokerC | - | |||||||||
| 17 | DragonHunter | - | |||||||||
| 18 | Shirowe | - | |||||||||
| 19 | 25Apples | - | |||||||||
| 20 | Can1cai | - | |||||||||
| 21 | ShadowKnight | - | |||||||||
| 22 | Balder | - | |||||||||
| 23 | xAsi | - | |||||||||
| 24 | DuongNguyet | - | |||||||||
| 25 | Arkey | - | |||||||||
| 26 | SallySue | - | |||||||||
| 27 | MD F2P | - | |||||||||
| 28 | PUNISHER | - | |||||||||
| 29 | CarbonNinja | - | |||||||||
| 30 | ET Nguyen | - | |||||||||
| 31 | SleepyBoy | - | |||||||||
| 32 | Sahil | - | |||||||||
| 33 | Contemption | - | |||||||||
| 34 | El Narvalloo | - | |||||||||
| 35 | TheWolf | - | |||||||||
| 36 | 17thSenturion | - | |||||||||
| 37 | Abyss | - | |||||||||
| 38 | Pozharsky | - | |||||||||
| 39 | Oraura | - | |||||||||
| 40 | BlessedDevil | - | |||||||||
| 41 | Q8EXTREME | - | |||||||||
| 42 | ThaiBach | - | |||||||||
| 43 | DemonCore | - | |||||||||
| 44 | Battousai | - | |||||||||
| 45 | Turtleus | - | |||||||||
| 46 | TBoRMaMkaTyT | - | |||||||||
| 47 | Wicat | - | |||||||||
| 48 | Creepybong | - | |||||||||
| 49 | Diablo | - | |||||||||
| 50 | Kirito | - | |||||||||
| 51 | N1v3kdom | - | |||||||||
| 52 | Obito | - | |||||||||
| 53 | KurazyKaiko | - | |||||||||
| 54 | emwhel2 | - | |||||||||
| 55 | EvilBunny | - | |||||||||
| 56 | F2P 2nd | - | |||||||||
| 57 | HieuKuKu | - | |||||||||
| 58 | BiBiKuKu | - | |||||||||
| 59 | SingleMom | - | |||||||||
| 60 | 25Appless | - | |||||||||
| 61 | BulkyPear | - | |||||||||
| 62 | K2 KAMARO | - | |||||||||
| 63 | Cyclonte | - | |||||||||
| 64 | NazyaPisyn | - | |||||||||
| 65 | ImF2P | - | |||||||||
| 66 | huynh | - | |||||||||
| 67 | ACU | - | |||||||||
| 68 | Light | - | |||||||||
| 69 | LordBasti | - | |||||||||
| 70 | Kaoru | - | |||||||||
| 71 | Winchester | - | |||||||||
| 72 | Yuri | - | |||||||||
| 73 | Aftloon | - | |||||||||
| 74 | Winnie | - | |||||||||
| 75 | gildark | - | |||||||||
| 76 | mamamidnight | - | |||||||||
| 77 | fuze | - | |||||||||
| 78 | hidal1997 | - | |||||||||
Sheet1 | |||||||||||
