SOLVED

Recherche de valeurs et implémentation

%3CLINGO-SUB%20id%3D%22lingo-sub-1255505%22%20slang%3D%22en-US%22%3ERecherche%20de%20valeurs%20et%20impl%C3%A9mentation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1255505%22%20slang%3D%22en-US%22%3E%3CP%3EBonjour%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDans%20la%20colonne%20A%20%3A%20je%20dispose%20de%20lettres%20de%20l'alphabet%20r%C3%A9p%C3%A9t%C3%A9es.%20Certaine%20cellules%20peuvent%20%C3%AAtre%20vides.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20l'aide%20d'une%20%3CU%3Eformule%3C%2FU%3E%20%3CSPAN%3E(plusieurs%20%C3%A9tapes%20possibles)%3C%2FSPAN%3E%20je%20souhaite%20obtenir%20dans%20la%20colonne%20B%2C%20devant%20chacune%20des%20lettres%20pr%C3%A9sentes%20dans%20la%20colonne%20A%2C%20un%20num%C3%A9ro%20d'ordre%20(num%C3%A9rotation).%3C%2FP%3E%3CP%3EDevant%20la%20premi%C3%A8re%20lettre%20C%2C%20je%20souhaite%20obtenir%20C1%2C%20devant%20la%20seconde%20lettre%20C%2C%20je%20souhaite%20obtenir%20C2%20et%20ainsi%20de%20suite%20pour%20toutes%20les%20lettres.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CTABLE%20border%3D%221%22%20width%3D%22100%25%22%3E%3CTBODY%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%3E%3CSTRONG%3EColonne%20A%3C%2FSTRONG%3E%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%3E%3CSTRONG%3EColonne%20B%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%3E%26nbsp%3B%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%3E%3CSTRONG%3Eattendu%20%3A%3C%2FSTRONG%3E%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%3EC%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%3EC1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%3E%3CP%3EB%3C%2FP%3E%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%3EB1%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%3EC%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%3EC2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%3EC%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%3EC3%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%3EB%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%3EB2%3C%2FTD%3E%3C%2FTR%3E%3CTR%3E%3CTD%20width%3D%2250%25%22%3EA%3C%2FTD%3E%3CTD%20width%3D%2250%25%22%3EA1%3C%2FTD%3E%3C%2FTR%3E%3C%2FTBODY%3E%3C%2FTABLE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMerci%20de%20votre%20aide%20!%3C%2FP%3E%3CP%3EMANU%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1255505%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1256827%22%20slang%3D%22en-US%22%3ERe%3A%20Recherche%20de%20valeurs%20et%20impl%C3%A9mentation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1256827%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F596238%22%20target%3D%22_blank%22%3E%40manu60%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThat's%20like%3C%2FP%3E%0A%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%20462px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F179824i4FCAF892763E25AA%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EPlease%20open%20attached%20file%20to%20have%20the%20formula%20in%20your%20locale%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1258542%22%20slang%3D%22fr-FR%22%3EValue%20search%20and%20implementation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1258542%22%20slang%3D%22fr-FR%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20help%20me%3F%3C%2FP%3E%3CP%3ESee%20file.%3C%2FP%3E%3CP%3EThank%20you%2C%20thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1260204%22%20slang%3D%22en-US%22%3ERe%3A%20Recherche%20de%20valeurs%20et%20impl%C3%A9mentation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1260204%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F596238%22%20target%3D%22_blank%22%3E%40manu60%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPerhaps%26nbsp%3B%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-markup%22%3E%3CCODE%3E%3DIF((LEFT(B1)%3D%22S%22)%2B(B1%3D%22%22)%2C%22%22%2CLOOKUP(2%2C1%2F(%24A%241%3A%24A1%3D%22S%22)%2C%24B%241%3A%24B1)%26amp%3B%22-%22%26amp%3BB1)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1260821%22%20slang%3D%22fr-FR%22%3ERe%3A%20Value%20search%20and%20implementation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1260821%22%20slang%3D%22fr-FR%22%3Eit%20is%20a%20track%20to%20be%20deepened.%20thank%20you%20so%20much%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Bonjour,

 

Dans la colonne A : je dispose de lettres de l'alphabet répétées. Certaine cellules peuvent être vides.

 

A l'aide d'une formule (plusieurs étapes possibles) je souhaite obtenir dans la colonne B, devant chacune des lettres présentes dans la colonne A, un numéro d'ordre (numérotation).

Devant la première lettre C, je souhaite obtenir C1, devant la seconde lettre C, je souhaite obtenir C2 et ainsi de suite pour toutes les lettres.

 

Colonne AColonne B
 attendu :
CC1

B

B1
CC2
CC3
BB2
AA1

 

Merci de votre aide !

MANU

4 Replies
Highlighted
Best Response confirmed by manu60 (New Contributor)
Solution

@manu60 

That's like

image.png

Please open attached file to have the formula in your locale

Highlighted

@Sergei Baklan 

 

Hello !

 

Can you help me ?

See file.

Thanks !

@manu60 

Perhaps 

=IF((LEFT(B1)="S")+(B1=""),"",LOOKUP(2,1/($A$1:$A1="S"),$B$1:$B1)&"-"&B1)

 

Highlighted
it is a track to be deepened. thank you so much