extraction de données d'un tableau

%3CLINGO-SUB%20id%3D%22lingo-sub-2177145%22%20slang%3D%22fr-FR%22%3Eextracting%20data%20from%20a%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2177145%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3EI%20have%20a%20table%20that%20represents%20a%20work%20schedule%20with%20different%20schedules%20per%20team.%20I%20want%20to%20group%20all%20people's%20names%20into%20one%20time%20slot.%20I%20do%20this%20with%20a%20TDC%20but%20the%20selected%20filters%20change%20regularly.Kind%20regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2177145%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2177976%22%20slang%3D%22en-US%22%3ERe%3A%20extraction%20de%20donn%C3%A9es%20d'un%20tableau%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2177976%22%20slang%3D%22en-US%22%3EUnfortunately%2C%20I%20don't%20fully%20understand%20(due%20to%20the%20language%20differences)%20here.%20To%20the%20extent%20that%20I%20do%2C%20I%20think%20your%20goal%20could%20be%20achieved%20by%20the%20new%20FILTER%20function%2C%20making%20use%20of%20a%20variable%20selection%20criterion.%20This%20requires%20the%20newest%20release%20of%20Excel.%20Here's%20a%20YouTube%20video%20(in%20English)%20that%20explains%20it.%20%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3D9I9DtFOVPIg%3C%2FA%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour,

J'ai un tableau qui représente un planning de travail avecles différents horaires par équipe. Je souhaite regrouper tous les noms des personnes dans une même plage horaire. Je fais cela avec un TDC mais le filtres sélectionnés change régulièrement.  Cordialement

1 Reply
Unfortunately, I don't fully understand (due to the language differences) here. To the extent that I do, I think your goal could be achieved by the new FILTER function, making use of a variable selection criterion. This requires the newest release of Excel. Here's a YouTube video (in English) that explains it. https://www.youtube.com/watch?v=9I9DtFOVPIg