Planning sur talbeau excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1888227%22%20slang%3D%22fr-FR%22%3EPlanning%20on%20talbeau%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1888227%22%20slang%3D%22fr-FR%22%3E%3CP%3EHi%20all%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20create%20an%20Excel%20style%20planning%20table.%20I'm%20a%20site%20manager.%3C%2FP%3E%3CP%3EMy%20chart%20is%20a%20data%20range.%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20lines%20are%20the%20names%20of%20construction%20sites%20and%20the%20columns%20are%20the%20days%20of%20the%20year%20simply.%3C%2FP%3E%3CP%3Ethe%20internal%20cells%20are%20the%20teams%20working%20on%20the%20site.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20like%20to%20be%20able%20to%20extract%20a%20team%20from%20this%20painting%20and%20have%20a%20visual%20on%20the%20construction%20sites%20on%20which%20she%20will%20work%20all%20year%20round.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20that%20possible%3F%20with%20which%20tool%2Ffunction%3F%20I%20tried%20with%20the%20recherveV%20function%20but%20unfortunately%20too%20much%20constraint%20to%20the%20realization.%3C%2FP%3E%3CP%3EThank%20you%20in%20advance%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1888227%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1888309%22%20slang%3D%22en-US%22%3ERe%3A%20Planning%20sur%20talbeau%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1888309%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F869479%22%20target%3D%22_blank%22%3E%40you1303%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESomething%20like%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20888px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F233637i235C0959CA1DAE6D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel%22%3E%3CCODE%3E%3D%20TEXTJOIN(%20CHAR(10)%2C%20%2C%20IF(%20required%3Dteams%2C%20site%26amp%3B%22%2C%20%22%26amp%3Bdays%2C%22%22)%20)%3C%2FCODE%3E%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Bonjour à tous,

 

J'ai créer un tableau Excel style planning. Je suis gestionnaire de chantier.

Mon tableau est une plage de données. 

Les lignes sont les noms de chantiers et les colonnes sont les jours de l'années simplement.

les cellules internes sont les équipes travaillant sur le chantier.

 

Je voudrais pouvoir extraire de ce tableau une équipe et avoir un visuel sur les chantiers sur lesquels elle va travailler toute l'année. 

 

est ce possible ? avec quelle outil/fonction? j'ai tenté avec la fonction recherveV mais malheureusement trop de contrainte à la réalisation.

merci d'avance, 

3 Replies
Highlighted

@you1303 

Something like this?

image.png

= TEXTJOIN( CHAR(10), , IF( required=teams, site&", "&days,"") )
Highlighted

Thnak for the idea. 

In fact i would like to keep the value in cells and not in just one cell on text.

 

i thought it was possible to keep the table and just change the "axes"

 

 

Highlighted

@you1303 

Why don't you show an image of the result you seek?