XL 2019 Besoin d'aide avec ces formules. Please

[papaabdoufall]

- 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)

 

[Deadpool_CC]

un fichier exemple ? avec donnée de base et ce que tu attends
Et c'est quoi "Anime" pour toi ? ou "Thème d'anime" ? je comprend pas à quoi cela correspond
c'est spécifique aux dernières version Excel ?

 

[papaabdoufall]

Salut,

Desolé le fichier est en anglais je l'avais oublié mais en faites ils y a differents nom de dessins animés '' Name'' dans le fichier.

 

[Deadpool_CC]

fichier exemple ?

 

[papaabdoufall]

est ce possible que vous me passiez votre adresse mail, Ca ne passe pas.

 

[Deadpool_CC]

Dsl non ...
Sur une copie vous ne conservez que 50 lignes d'exemple (et pas d'information nominative) et vous fournissez cela.

 

[papaabdoufall]

	Name	Type	Score	Score Rank	Popularity Rank	Air Date	Studio	Num. of episodes	Genres	Theme(s)	Demographic
0​	Fullmetal Alchemist: Brotherhood	TV	9.14	1​	3​	Apr 5, 2009 to Jul 4, 2010	['Bones']	64​	['Action', 'Adventure', 'Drama', 'Fantasy']	['Military']	Shounen
1​	Spy x Family	TV	9.09	2​	350​	Apr 9, 2022 to ?	['Wit Studio', ' CloverWorks']	12​	['Action', 'Comedy']	['Childcare']	Shounen
2​	Shingeki no Kyojin Season 3 Part 2	TV	9.08	3​	32​	Apr 29, 2019 to Jul 1, 2019	['Wit Studio']	10​	['Action', 'Drama']	['Gore', 'Military', 'Survival']	Shounen
3​	Steins;Gate	TV	9.08	4​	13​	Apr 6, 2011 to Sep 14, 2011	['White Fox']	24​	['Drama', 'Sci-Fi', 'Suspense']	['Psychological', 'Time Travel']	None
4​	Gintama°	TV	9.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'	TV	9.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 Final	Movie	9.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)	TV	9.05	8​	10​	Oct 2, 2011 to Sep 24, 2014	['Madhouse']	148​	['Action', 'Adventure', 'Fantasy']	['None']	Shounen
8​	Fruits Basket: The Final	TV	9.04	9​	551​	Apr 6, 2021 to Jun 29, 2021	['TMS Entertainment']	13​	['Drama', 'Romance', 'Slice of Life', 'Supernatural']	['None']	Shoujo
9​	Gintama': Enchousen	TV	9.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 Densetsu	OVA	9.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.	TV	8.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 Romantic	TV	8.97	13​	433​	Apr 9, 2022 to ?	['A-1 Pictures']	0​	['Comedy']	['Psychological', 'Romantic Subtext', 'School']	Seinen
13​	3-gatsu no Lion 2nd Season	TV	8.96	14​	535​	Oct 14, 2017 to Mar 31, 2018	['Shaft']	22​	['Drama', 'Slice of Life']	['Childcare', 'Iyashikei', 'Strategy Game']	Seinen
14​	Koe no Katachi	Movie	8.96	15​	19​	Sep 17, 2016	['Kyoto Animation']	1​	['Drama']	['Romantic Subtext']	Shounen
15​	Gintama	TV	8.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 Movie	Movie	8.95	17​	424​	Sep 18, 2020	['Kyoto Animation']	1​	['Drama', 'Fantasy', 'Slice of Life']	['None']	None
17​	Clannad: After Story	TV	8.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 Nare	Movie	8.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 R2	TV	8.91	20​	47​	Apr 6, 2008 to Sep 28, 2008	['Sunrise']	25​	['Action', 'Drama', 'Sci-Fi']	['Mecha', 'Military', 'Super Power']	None
20​	Owarimonogatari 2nd Season	TV	8.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 2	TV	8.90	22​	164​	Jan 10, 2022 to Apr 4, 2022	['MAPPA']	12​	['Action', 'Drama']	['Gore', 'Military', 'Survival']	Shounen
22​	Kimetsu no Yaiba: Yuukaku-hen	TV	8.89	23​	161​	Dec 5, 2021 to Feb 13, 2022	['ufotable']	11​	['Action', 'Fantasy']	['Historical']	Shounen
23​	Gintama.: Shirogane no Tamashii-hen - Kouhan-sen	TV	8.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.	Movie	8.87	25​	11​	Aug 26, 2016	['CoMix Wave Films']	1​	['Drama', 'Supernatural']	['Romantic Subtext']	None
25​	Shingeki no Kyojin: The Final Season	TV	8.85	26​	46​	Dec 7, 2020 to Mar 29, 2021	['MAPPA']	16​	['Action', 'Drama']	['Gore', 'Military', 'Survival']	Shounen
26​	Monster	TV	8.83	27​	156​	Apr 7, 2004 to Sep 28, 2005	['Madhouse']	74​	['Drama', 'Mystery', 'Suspense']	['Adult Cast', 'Psychological']	Seinen
27​	Mob Psycho 100 II	TV	8.81	28​	85​	Jan 7, 2019 to Apr 1, 2019	['Bones']	13​	['Action', 'Comedy', 'Supernatural']	['Super Power']	None
28​	Gintama.: Shirogane no Tamashii-hen	TV	8.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-hen	Movie	8.80	30​	457​	Jan 6, 2017	['Shaft']	1​	['Action', 'Mystery', 'Supernatural']	['Vampire']	None
30​	Shiguang Dailiren	ONA	8.80	31​	973​	Apr 30, 2021 to Jul 9, 2021	['Studio LAN']	11​	['Drama', 'Supernatural']	['Time Travel']	None
31​	Sen to Chihiro no Kamikakushi	Movie	8.79	32​	43​	Jul 20, 2001	['Studio Ghibli']	1​	['Adventure', 'Award Winning', 'Supernatural']	['Mythology']	None
32​	Haikyuu!!: Karasuno Koukou vs. Shiratorizawa Gakuen Koukou	TV	8.79	33​	111​	Oct 8, 2016 to Dec 10, 2016	['Production I.G']	10​	['Sports']	['School', 'Team Sports']	Shounen
33​	Kingdom 3rd Season	TV	8.78	34​	2238​	Apr 6, 2020 to Oct 17, 2021	['Pierrot Plus', ' Studio Signpost']	26​	['Action']	['Historical', 'Military']	Seinen
34​	Monogatari Series: Second Season	TV	8.78	35​	272​	Jul 7, 2013 to Dec 29, 2013	['Shaft']	26​	['Comedy', 'Mystery', 'Romance', 'Supernatural']	['Vampire']	None
35​	Cowboy Bebop	TV	8.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 2	TV	8.75	37​	308​	Oct 4, 2021 to Dec 20, 2021	['Studio Bind']	12​	['Drama', 'Fantasy', 'Ecchi']	['Isekai', 'Reincarnation']	None
37​	Odd Taxi	TV	8.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-hen	TV	8.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 Season	TV	8.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 Ippo	TV	8.74	41​	375​	Oct 4, 2000 to Mar 27, 2002	['Madhouse']	75​	['Sports']	['Combat Sports']	Shounen
41​	Vinland Saga	TV	8.73	42​	102​	Jul 8, 2019 to Dec 30, 2019	['Wit Studio']	24​	['Action', 'Adventure', 'Drama']	['Historical']	Seinen
42​	86 Part 2	TV	8.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 Song	Movie	8.72	44​	727​	Aug 15, 2020	['ufotable']	1​	['Action', 'Fantasy', 'Supernatural']	['None']	None
44​	Ashita no Joe 2	TV	8.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 Shou	TV	8.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-hen	OVA	8.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 Pian	ONA	8.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 Lelouch	TV	8.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 Onizuka	TV	8.69	50​	215​	Jun 30, 1999 to Sep 17, 2000	['Studio Pierrot']	43​	['Comedy', 'Drama']	['Delinquents', 'School', 'Workplace']	Shounen

 

[Phil69970]

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

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