Comparer des cellules et afficher resultat

%3CLINGO-SUB%20id%3D%22lingo-sub-1600465%22%20slang%3D%22fr-FR%22%3ECompare%20cells%20and%20show%20results%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1600465%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%2C%20%3CBR%20%2F%3E%20I%20would%20need%20your%20help%20to%20achieve%20the%20following%3A%20%3CBR%20%2F%3E%201-Open%20an%20Excel%20Table%2C%20where%20each%20cell%20contains%20a%20number%20of%203%20%3CBR%20%2F%3E%20digits%202-Select%20a%20part%20or%20all%20table%20%3CBR%20%2F%3E%203-Lancer%20a%20search%20for%20comparison%20of%20cells%20between%20them%20whose%20result%20will%20have%20to%20display%20all%20possible%20combinations.%3C%2FP%3E%3CP%3EExample%201%2C%20if%20there%20are%20two%20or%20more%20cells%2C%20containing%20123%2C%20132%2C%20321...then%20Resultat%3A%20one%20of%20them%20appears.%20%3CBR%20%2F%3E%20Example%202%3A%20if%20there%20are%20two%20or%20more%20cells%2C%20containing%20121%2C%20211%2C%20then%20Result%3A%20one%20of%20them%20appears.%20%3CBR%20%2F%3E%20Example%203%3A%20If%20the%20contents%20of%20a%20cell%20are%20unique%2C%20then%20nothing%20appears.%20%3CBR%20%2F%3E%20Thank%20you%20already.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1600465%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Bonjour,
j'aurais besoin de votre aide pour réaliser la suivante:
1-Ouvrire un Tableau Excel, où chaque cellule contient un nombre de 3 chiffres
2-Selectionner une partie ou tout le Tableau
3-Lancer une recherche de comparaison des cellules entres elles dont le résultat devra afficher toutes les combinaisons possibles.

Exemple 1, s'il existe deux cellules ou plus, contenant 123, 132, 321...alors Resultat: l'une d'elles s'affiche.
Exemple 2: s'il existe deux cellules ou plus, contenant 121, 211, alors Resultat: l'une d'elles s'affiche.
Exemple 3: Si le contenue d'une cellule est unique, alors rien ne s'affiche.
Merci déjà.

0 Replies