Tri d'un tableau par élément non isolé

%3CLINGO-SUB%20id%3D%22lingo-sub-2195354%22%20slang%3D%22fr-FR%22%3ESorting%20a%20table%20by%20non-isolated%20item%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2195354%22%20slang%3D%22fr-FR%22%3E%3CP%3EGood%20morning%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20problem%20that%20I%20can't%20solve.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20data%20table%2C%20and%20on%20one%20of%20the%20columns%2C%20the%20cells%20correspond%20to%20several%20elements%20grouped%20together%20and%20separated%20by%20one%3B%3C%2FP%3E%3CP%3EI%20would%20like%2C%20for%20this%20column%2C%20that%20the%20sorting%20proposed%20by%20the%20table%20be%20on%20the%20separate%20elements%20and%20not%20on%20the%20concatenation%2C%20is%20it%20possible%3F%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELike%20what%3A%3C%2FP%3E%3CP%3EMy%20column%20includes%20the%20cell%3CEM%3E%22word1%3Bword2%3Bword3%22%3C%2FEM%3E%3C%2FP%3E%3CP%3EThe%20sorting%20of%20the%20table%20therefore%20proposes%3CEM%3E%22word1%3Bword2%3Bmot3%22%20%3C%2FEM%3Eto%20check%20or%20not.%3C%2FP%3E%3CP%3EI%20wish%20I%20could%20check%3CEM%3E%22word1%2C%22%3C%2FEM%3E%3CEM%3E%22word2%22%3C%2FEM%3E%20and%3CEM%3E%22word3%22%3C%2FEM%3E%20separately.%3C%2FP%3E%3CP%3EAll%20while%20keeping%20the%20other%20sort%20of%20the%20table%20accessible.%3C%2FP%3E%3CP%3EWould%20have%20seen%20a%20solution%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3EQuentin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2195354%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Regular Visitor

Bonjour

 

J'ai un problème que je n'arrive pas à résoudre.

 

J'ai un tableau de donnée, et sur l'une des colonnes, les cellules correspondent à plusieurs éléments regroupées ensemble et séparé par un ; 

Je souhaiterais, pour cette colonne que le tri proposé par le tableau soit sur les éléments séparé et non sur la concaténation, est-ce possible??

 

Par exemple:

Ma colonne comprend la cellule "mot1;mot2;mot3"

Le tri du tableau propose donc  "mot1;mot2;mot3" à cocher ou non.

Je souhaiterais pouvoir cocher "mot1", "mot2" et "mot3" séparément.

Le tout en gardant les autres tri du tableau accessible.

Auriez vus une solution?

 

Cordialement

Quentin

0 Replies