values across tables found by name

Aftloon

New Member
Joined
Jun 15, 2022
Messages
7
Office Version
  1. 365
Platform
  1. Windows
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

MMDS STATS.xlsx
ABCDEFGHIJKL
1DAY7WK1NAMEPWRHELPSDAY1WK2NAMEPWRPWR+/-PWR%HELPSDONO
23/07/202217thSenturion3,571,2962574/07/202217thSenturion3,581,836--176800
325Apples4,362,755228225Apples4,459,055--37712900
425Appless2,841,209148325Appless3,021,778--2555800
5Abyss3,566,6521729Abyss3,844,449--1806400
6ACU2,672,8311449ACU2,918,571--23411200
7Aftloon2,573,3851076Aftloon2,806,577--12411000
8Animeda5,917,3682606Animeda6,127,917--19714000
9Arkey4,206,3271259Arkey4,241,455--22212700
10Arnoldsss19,503,3831053Arnoldsss20,154,745--20310400
11Balder4,315,3234364Balder4,392,143--57010100
12Battousai3,239,073536Battousai3,364,992--5711200
13BiBiKuKu2,919,8041570BiBiKuKu2,966,349--2416300
14BlazinRad5,733,1811471BlazinRad6,328,993--20912600
15BlessedDevil3,335,729322BlessedDevil3,472,566--24010300
16BulkyPear2,837,4752220BulkyPear2,965,212--20810500
17CarbonNinja3,973,0501181Can1cai4,537,608--3675200
18Champ6,236,915539CarbonNinja4,104,010--3037800
19Contemption3,674,5071800Champ6,256,815--676800
20Creepybong3,195,3541861Contemption3,993,404--2127500
21Cyclonte2,812,636810Creepybong3,281,898--18610200
22DemonCore3,241,9031853Cyclonte2,900,938--17210600
23Diablo3,183,4081544DemonCore3,384,724--29110500
24DragonHunter4,630,5632165Diablo3,239,770--19314500
25Draztatic9,776,789413DragonHunter4,842,751--33310300
26DuongNguyet4,209,8382363Draztatic10,475,500--14511200
27El Narvalloo3,652,14269DuongNguyet4,391,725--43310000
28emwhel23,072,040555El Narvalloo3,686,548--00
29ET Nguyen3,826,0863114emwhel23,119,933--619600
30EvilBunny2,999,7181806ET Nguyen3,960,754--44910200
31F2P 2nd2,936,9652451EvilBunny3,205,364--3008800
32Forever9,591,350328F2P 2nd3,000,024--208000
33fuze2,096,542680Forever9,591,350--133200
34gildark2,476,740228fuze2,215,789--458100
35Goober5,936,501135gildark2,673,463--919400
36HeroBack6,031,1771240Goober5,983,620--357900
37hidal19972,072,294928HeroBack6,160,599--13810200
38HieuKuKu2,924,445393hidal19972,137,302--1069700
39huynh2,715,815837HieuKuKu2,995,238--1725600
40ImF2P2,755,2801455huynh2,773,459--909900
41JokerC4,733,9891966ImF2P2,800,861--1429600
42Joshua6,843,3011343JokerC5,160,613--21214600
43K2 KAMARO2,830,1991588Joshua7,129,606--20511600
44Kaoru2,611,8651575K2 KAMARO2,977,311--3388700
45Kirito3,179,100910Kaoru2,877,913--1616000
46KurazyKaiko3,085,8191710Kirito3,198,133--577100
47Levine6,018,552550KurazyKaiko3,171,454--777100
48Light2,668,605474Levine6,205,350--614500
49LordBasti2,651,567734Light2,684,627--150
50mamamidnight2,246,102218LordBasti2,756,103--1398600
51MD F2P4,192,2341463mamamidnight2,256,002--144700
52N1v3kdom3,136,995159MD F2P4,399,330--2319800
53NazyaPisyn2,788,034885N1v3kdom3,812,738--464400
54NotDuck5,293,9491881NazyaPisyn2,877,730--13610800
55Obito3,111,031230NotDuck5,388,709--27513100
56Omega5,092,3752692Obito3,129,332--314200
57Oraura3,357,0121179Omega5,159,541--35213300
58Pozharsky3,533,2281322Oraura3,462,785--20210400
59PUNISHER4,109,4881547Pozharsky3,615,483--2465600
60Q8EXTREME3,319,34770PUNISHER4,111,288--00
61Sahil3,709,3272057Q8EXTREME3,442,435--269000
62SallySue4,200,7611577Sahil3,781,855--2588200
63Shade14,290,1711469SallySue4,243,035--28516300
64ShadowKnight4,362,500183Shade15,248,797--1299000
65SheepDuck14,026,9331582ShadowKnight4,377,462--79300
66Shirowe4,491,5832771SheepDuck15,476,150--1829200
67SingleMom2,914,941794Shirowe4,873,000--48916200
68SleepyBoy3,770,5512333SingleMom3,031,157--1068000
69TBoRMaMkaTyT3,218,1912195SleepyBoy3,928,396--2155400
70ThaiBach3,267,6201399TBoRMaMkaTyT3,301,396--26510000
71TheWolf3,615,6471043ThaiBach3,330,985--1647100
72Turtleus3,233,7062011TheWolf3,711,853--8011900
73Wicat3,212,1931104Turtleus3,346,196--24311900
74Winchester2,598,6291105Wicat3,300,382--14110700
75Winnie2,546,2041124Winchester2,655,800--1269900
76xAsi4,297,2651168Winnie2,743,700--3987500
77Yuri2,589,133845xAsi4,540,791--2799600
78Yuri2,649,986--18510300
Sheet1


MMDS STATS.xlsx
NOPQRSTUV
1DAY2WK2NAMEPWRPWR+PWR%HELPSHELPS+DONODONO+
2Arnoldsss-
3Shade-
4SheepDuck-
5Draztatic-
6Forever-
7Joshua-
8Champ-
9HeroBack-
10Levine-
11Goober-
12Animeda-
13BlazinRad-
14NotDuck-
15Omega-
16JokerC-
17DragonHunter-
18Shirowe-
1925Apples-
20Can1cai-
21ShadowKnight-
22Balder-
23xAsi-
24DuongNguyet-
25Arkey-
26SallySue-
27MD F2P-
28PUNISHER-
29CarbonNinja-
30ET Nguyen-
31SleepyBoy-
32Sahil-
33Contemption-
34El Narvalloo-
35TheWolf-
3617thSenturion-
37Abyss-
38Pozharsky-
39Oraura-
40BlessedDevil-
41Q8EXTREME-
42ThaiBach-
43DemonCore-
44Battousai-
45Turtleus-
46TBoRMaMkaTyT-
47Wicat-
48Creepybong-
49Diablo-
50Kirito-
51N1v3kdom-
52Obito-
53KurazyKaiko-
54emwhel2-
55EvilBunny-
56F2P 2nd-
57HieuKuKu-
58BiBiKuKu-
59SingleMom-
6025Appless-
61BulkyPear-
62K2 KAMARO-
63Cyclonte-
64NazyaPisyn-
65ImF2P-
66huynh-
67ACU-
68Light-
69LordBasti-
70Kaoru-
71Winchester-
72Yuri-
73Aftloon-
74Winnie-
75gildark-
76mamamidnight-
77fuze-
78hidal1997-
Sheet1
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).

Forum statistics

Threads
1,223,228
Messages
6,170,876
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top