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 |