XL 2019 Besoin d'aide avec ces formules. Please

papaabdoufall

XLDnaute Nouveau
- Anime le mieux noté (colonne B) par chaque studio (colonne H) selon le score (colonne D)
- Anime le mieux noté (colonne G) par année (colonne G) selon le score (colonne D)
- Anime le plus populaire (colonne G) par genre (colonne J) selon la popularité (colonne F)
- Thème d'anime le plus populaire (colonne K) par chaque studio (colonne H) selon la popularité (colonne F)
 

papaabdoufall

XLDnaute Nouveau
NameTypeScoreScore RankPopularity RankAir DateStudioNum. of episodesGenresTheme(s)Demographic
0​
Fullmetal Alchemist: BrotherhoodTV9.14
1​
3​
Apr 5, 2009 to Jul 4, 2010['Bones']
64​
['Action', 'Adventure', 'Drama', 'Fantasy']['Military']Shounen
1​
Spy x FamilyTV9.09
2​
350​
Apr 9, 2022 to ?['Wit Studio', ' CloverWorks']
12​
['Action', 'Comedy']['Childcare']Shounen
2​
Shingeki no Kyojin Season 3 Part 2TV9.08
3​
32​
Apr 29, 2019 to Jul 1, 2019['Wit Studio']
10​
['Action', 'Drama']['Gore', 'Military', 'Survival']Shounen
3​
Steins;GateTV9.08
4​
13​
Apr 6, 2011 to Sep 14, 2011['White Fox']
24​
['Drama', 'Sci-Fi', 'Suspense']['Psychological', 'Time Travel']None
4​
Gintama°TV9.08
5​
335​
Apr 8, 2015 to Mar 30, 2016['Bandai Namco Pictures']
51​
['Action', 'Comedy', 'Sci-Fi']['Gag Humor', 'Historical', 'Parody', 'Samurai']Shounen
5​
Gintama'TV9.05
6​
385​
Apr 4, 2011 to Mar 26, 2012['Sunrise']
51​
['Action', 'Comedy', 'Sci-Fi']['Gag Humor', 'Historical', 'Parody', 'Samurai']Shounen
6​
Gintama: The FinalMovie9.05
7​
1746​
Jan 8, 2021['Bandai Namco Pictures']
1​
['Action', 'Comedy', 'Drama', 'Sci-Fi']['Gag Humor', 'Historical', 'Parody', 'Samurai']Shounen
7​
Hunter x Hunter (2011)TV9.05
8​
10​
Oct 2, 2011 to Sep 24, 2014['Madhouse']
148​
['Action', 'Adventure', 'Fantasy']['None']Shounen
8​
Fruits Basket: The FinalTV9.04
9​
551​
Apr 6, 2021 to Jun 29, 2021['TMS Entertainment']
13​
['Drama', 'Romance', 'Slice of Life', 'Supernatural']['None']Shoujo
9​
Gintama': EnchousenTV9.04
10​
695​
Oct 4, 2012 to Mar 28, 2013['Sunrise']
13​
['Action', 'Comedy', 'Sci-Fi']['Gag Humor', 'Historical', 'Parody', 'Samurai']Shounen
10​
Ginga Eiyuu DensetsuOVA9.03
11​
697​
Jan 8, 1988 to Mar 17, 1997['K-Factory', ' Kitty Film Mitaka Studio']
110​
['Drama', 'Sci-Fi']['Adult Cast', 'Military', 'Space']None
11​
Gintama.TV8.99
12​
735​
Jan 9, 2017 to Mar 27, 2017['Bandai Namco Pictures']
12​
['Action', 'Comedy', 'Sci-Fi']['Gag Humor', 'Historical', 'Parody', 'Samurai']Shounen
12​
Kaguya-sama wa Kokurasetai: Ultra RomanticTV8.97
13​
433​
Apr 9, 2022 to ?['A-1 Pictures']
0​
['Comedy']['Psychological', 'Romantic Subtext', 'School']Seinen
13​
3-gatsu no Lion 2nd SeasonTV8.96
14​
535​
Oct 14, 2017 to Mar 31, 2018['Shaft']
22​
['Drama', 'Slice of Life']['Childcare', 'Iyashikei', 'Strategy Game']Seinen
14​
Koe no KatachiMovie8.96
15​
19​
Sep 17, 2016['Kyoto Animation']
1​
['Drama']['Romantic Subtext']Shounen
15​
GintamaTV8.95
16​
127​
Apr 4, 2006 to Mar 25, 2010['Sunrise']
201​
['Action', 'Comedy', 'Sci-Fi']['Gag Humor', 'Historical', 'Parody', 'Samurai']Shounen
16​
Violet Evergarden MovieMovie8.95
17​
424​
Sep 18, 2020['Kyoto Animation']
1​
['Drama', 'Fantasy', 'Slice of Life']['None']None
17​
Clannad: After StoryTV8.94
18​
103​
Oct 3, 2008 to Mar 27, 2009['Kyoto Animation']
24​
['Comedy', 'Drama', 'Romance', 'Slice of Life', 'Supernatural']['None']None
18​
Gintama Movie 2: Kanketsu-hen - Yorozuya yo Eien NareMovie8.93
19​
939​
Jul 6, 2013['Sunrise']
1​
['Action', 'Comedy', 'Sci-Fi']['Gag Humor', 'Historical', 'Parody', 'Samurai', 'Time Travel']Shounen
19​
Code Geass: Hangyaku no Lelouch R2TV8.91
20​
47​
Apr 6, 2008 to Sep 28, 2008['Sunrise']
25​
['Action', 'Drama', 'Sci-Fi']['Mecha', 'Military', 'Super Power']None
20​
Owarimonogatari 2nd SeasonTV8.90
21​
538​
Aug 12, 2017 to Aug 13, 2017['Shaft']
7​
['Comedy', 'Mystery', 'Supernatural']['Vampire']None
21​
Shingeki no Kyojin: The Final Season Part 2TV8.90
22​
164​
Jan 10, 2022 to Apr 4, 2022['MAPPA']
12​
['Action', 'Drama']['Gore', 'Military', 'Survival']Shounen
22​
Kimetsu no Yaiba: Yuukaku-henTV8.89
23​
161​
Dec 5, 2021 to Feb 13, 2022['ufotable']
11​
['Action', 'Fantasy']['Historical']Shounen
23​
Gintama.: Shirogane no Tamashii-hen - Kouhan-senTV8.88
24​
1194​
Jul 9, 2018 to Oct 8, 2018['Bandai Namco Pictures']
14​
['Action', 'Comedy', 'Sci-Fi']['Gag Humor', 'Historical', 'Parody', 'Samurai']Shounen
24​
Kimi no Na wa.Movie8.87
25​
11​
Aug 26, 2016['CoMix Wave Films']
1​
['Drama', 'Supernatural']['Romantic Subtext']None
25​
Shingeki no Kyojin: The Final SeasonTV8.85
26​
46​
Dec 7, 2020 to Mar 29, 2021['MAPPA']
16​
['Action', 'Drama']['Gore', 'Military', 'Survival']Shounen
26​
MonsterTV8.83
27​
156​
Apr 7, 2004 to Sep 28, 2005['Madhouse']
74​
['Drama', 'Mystery', 'Suspense']['Adult Cast', 'Psychological']Seinen
27​
Mob Psycho 100 IITV8.81
28​
85​
Jan 7, 2019 to Apr 1, 2019['Bones']
13​
['Action', 'Comedy', 'Supernatural']['Super Power']None
28​
Gintama.: Shirogane no Tamashii-henTV8.81
29​
1089​
Jan 8, 2018 to Mar 26, 2018['Bandai Namco Pictures']
12​
['Action', 'Comedy', 'Sci-Fi']['Gag Humor', 'Historical', 'Parody', 'Samurai']Shounen
29​
Kizumonogatari III: Reiketsu-henMovie8.80
30​
457​
Jan 6, 2017['Shaft']
1​
['Action', 'Mystery', 'Supernatural']['Vampire']None
30​
Shiguang DailirenONA8.80
31​
973​
Apr 30, 2021 to Jul 9, 2021['Studio LAN']
11​
['Drama', 'Supernatural']['Time Travel']None
31​
Sen to Chihiro no KamikakushiMovie8.79
32​
43​
Jul 20, 2001['Studio Ghibli']
1​
['Adventure', 'Award Winning', 'Supernatural']['Mythology']None
32​
Haikyuu!!: Karasuno Koukou vs. Shiratorizawa Gakuen KoukouTV8.79
33​
111​
Oct 8, 2016 to Dec 10, 2016['Production I.G']
10​
['Sports']['School', 'Team Sports']Shounen
33​
Kingdom 3rd SeasonTV8.78
34​
2238​
Apr 6, 2020 to Oct 17, 2021['Pierrot Plus', ' Studio Signpost']
26​
['Action']['Historical', 'Military']Seinen
34​
Monogatari Series: Second SeasonTV8.78
35​
272​
Jul 7, 2013 to Dec 29, 2013['Shaft']
26​
['Comedy', 'Mystery', 'Romance', 'Supernatural']['Vampire']None
35​
Cowboy BebopTV8.76
36​
42​
Apr 3, 1998 to Apr 24, 1999['Sunrise']
26​
['Action', 'Sci-Fi']['Adult Cast', 'Space']None
36​
Mushoku Tensei: Isekai Ittara Honki Dasu Part 2TV8.75
37​
308​
Oct 4, 2021 to Dec 20, 2021['Studio Bind']
12​
['Drama', 'Fantasy', 'Ecchi']['Isekai', 'Reincarnation']None
37​
Odd TaxiTV8.75
38​
647​
Apr 6, 2021 to Jun 29, 2021['OLM', ' P.I.C.S.']
13​
['Mystery']['Anthropomorphic']None
38​
Shouwa Genroku Rakugo Shinjuu: Sukeroku Futatabi-henTV8.75
39​
1140​
Jan 7, 2017 to Mar 25, 2017['Studio Deen']
12​
['Drama']['Historical', 'Love Polygon', 'Performing Arts']Josei
39​
Mushishi Zoku Shou 2nd SeasonTV8.74
40​
826​
Oct 19, 2014 to Dec 21, 2014['Artland']
10​
['Adventure', 'Fantasy', 'Mystery', 'Slice of Life', 'Supernatural']['Adult Cast', 'Historical', 'Iyashikei']Seinen
40​
Hajime no IppoTV8.74
41​
375​
Oct 4, 2000 to Mar 27, 2002['Madhouse']
75​
['Sports']['Combat Sports']Shounen
41​
Vinland SagaTV8.73
42​
102​
Jul 8, 2019 to Dec 30, 2019['Wit Studio']
24​
['Action', 'Adventure', 'Drama']['Historical']Seinen
42​
86 Part 2TV8.72
43​
666​
Oct 3, 2021 to Mar 19, 2022['A-1 Pictures']
12​
['Action', 'Drama', 'Sci-Fi']['Mecha', 'Military']None
43​
Fate/stay night Movie: Heaven's Feel - III. Spring SongMovie8.72
44​
727​
Aug 15, 2020['ufotable']
1​
['Action', 'Fantasy', 'Supernatural']['None']None
44​
Ashita no Joe 2TV8.71
45​
2920​
Oct 13, 1980 to Aug 31, 1981['Tokyo Movie Shinsha']
47​
['Action', 'Drama', 'Slice of Life', 'Sports']['Combat Sports']Shounen
45​
Mushishi Zoku ShouTV8.71
46​
728​
Apr 5, 2014 to Jun 21, 2014['Artland']
10​
['Adventure', 'Fantasy', 'Mystery', 'Slice of Life', 'Supernatural']['Adult Cast', 'Historical', 'Iyashikei']Seinen
46​
Rurouni Kenshin: Meiji Kenkaku Romantan - Tsuioku-henOVA8.71
47​
762​
Feb 20, 1999 to Sep 22, 1999['Studio Deen']
4​
['Action', 'Drama', 'Romance']['Adult Cast', 'Historical', 'Martial Arts', 'Samurai']Shounen
47​
Mo Dao Zu Shi: Wanjie PianONA8.70
48​
2520​
Aug 7, 2021 to Oct 16, 2021['B.CMAY PICTURES']
12​
['Action', 'Drama', 'Supernatural']['Historical', 'Mythology']None
48​
Code Geass: Hangyaku no LelouchTV8.70
49​
17​
Oct 6, 2006 to Jul 29, 2007['Sunrise']
25​
['Action', 'Drama', 'Sci-Fi']['Mecha', 'Military', 'School', 'Super Power']None
49​
Great Teacher OnizukaTV8.69
50​
215​
Jun 30, 1999 to Sep 17, 2000['Studio Pierrot']
43​
['Comedy', 'Drama']['Delinquents', 'School', 'Workplace']Shounen
 

Phil69970

XLDnaute Barbatruc
Bonjour @papaabdoufall ,@Deadpool_CC
Bienvenu sur XLD

@papaabdoufall

Quelques remarques :

1) Pour ton titre je te conseille de relire la Charte § 2.2 (Tu peux éditer ton titre et le modifier)

2) Pour ton 1er post je te conseille de relire la Charte § 1.3 (Tu peux éditer ton post et le modifier)

3) Pour ton 3eme post je te conseille de relire la Charte § 1.12

4) Pour ton 4eme post je te conseille de relire la Charte § 2.5

Bref je te suggère de lire l'intégralité de la charte car pour un début sur le site tu frappes fort o_O

Si ton fichier est trop gros tu postes qu'une copie réduite à un nombre de ligne représentatif de ce que tu veux faire tout en respectant le RGPD si nécessaire.
Et pour que l'on comprenne bien tu mets d'un coté ce que tu as et de l'autre ce que tu veux .

Bonne lecture

@Phil69970
 

Discussions similaires

Réponses
9
Affichages
401
Réponses
18
Affichages
660