Compteur

%3CLINGO-SUB%20id%3D%22lingo-sub-1947587%22%20slang%3D%22fr-FR%22%3ECounter%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1947587%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20everyone!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20help%20with%20a%20problem%20that%20has%20been%20weighing%20on%20me%20for%20a%20while.%3C%2FP%3E%3CP%3EThat's%20it%2C%20I'd%20like%20to%20do%20a%20counter.%3C%2FP%3E%3CP%3EWhat%20kind%20of%20guy%3F%26nbsp%3B%3C%2FP%3E%3CP%3ESo%2C%20for%20example%2C%20I'd%20like%20that%20every%20time%20A2%20and%20A3%20have%203%2C%20put%20one%20to%20A5.%3C%2FP%3E%3CP%3ELike%20if%20there's%20six%20in%20A2%20and%206%20in%20A3%2C%20put%202%20to%20A5.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20there%20are%206%20in%20A2%20and%205%20in%20A3%2C%20just%20put%201%20to%20A5%2C%20since%20there%20are%20no%203%20and%203.%3C%2FP%3E%3CP%3EI%20would%20really%20like%20something%20like%20this%2C%20please!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20advance%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EKind%20regards%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEdgeer%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1947587%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1947749%22%20slang%3D%22de-DE%22%3ESubject%3A%20Compteur%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1947749%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F888133%22%20target%3D%22_blank%22%3E%40Edgeer%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWith%20your%20permission%2C%20if%20I%20can%20recommend%20you%2C%20add%20a%20file%20(without%20sensitive%20data)%20to%20your%20project.%3C%2FP%3E%3CP%3EExplain%20your%20plans%20in%20relation%20to%20this%20file.%20So%20you%20can%20get%20a%20solution%20that%20is%20tailored%20to%20your%20needs%20much%20faster.%3C%2FP%3E%3CP%3EAt%20the%20same%20time%2C%20it%20is%20much%20easier%20for%20someone%20who%20wants%20to%20help%20understand%20the%20subject.%3C%2FP%3E%3CP%3EA%20win-win%20situation%20for%20everyone.%3C%2FP%3E%3CP%3EPlease%20no%20Picture%2C%20even%20if%20it%20is%20said%20that%20a%20picture%20can%20say%20a%20thousand%20words%2C%20it%20is%20certainly%20not%20in%20the%20case%20of%20Excel%2C%20on%20the%20contrary%20in%20some%20case%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Knowing%20the%20Excel%20version%20and%20operating%20system%20would%20be%20an%20advantage.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EP.s%3A%20In%20order%20not%20to%20be%20misunderstood%2C%20in%20the%20community%20it%20is%20the%20aim%20of%20excel%20users%20to%20give%20help%20on%20their%20project%20(from%20Excel%20users)%2C%20or%20rather%2C%20to%20provide%20food%20for%20thought%20and%20not%20to%20deliver%20finished%20work%20or%20finished%20ideas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENevertheless%2C%20here%20is%20a%20formula%20to%20get%20you%20started%3A%3C%2FP%3E%3CP%3E%3DIF(AND(A2%3D3)%2CIF(A3%3D3%2C1%2C%22))%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20understanding%20and%20patience%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Bonjour tout le monde !

 

J'ai besoin d'aide sur un soucis qui me pèse depuis un moment.

Voilà, j'aimerais faire un compteur.

De quel type ? 

Alors, par exemple, j'aimerais que à chaque fois que A2 et A3 ont 3, mettre un à A5.

Genre si il y a 6 dans A2 et 6 dans A3, mettre 2 à A5.

 

Si il y a 6 dans A2 et 5 dans A3, juste mettre 1 à A5, vu qu'il n'y a pas 3 et 3.

J'aimerais vraiment un truc de ce style, s'il vous plaît!!

 

Merci d'avance,

 

Cordialement,

 

Edgeer

2 Replies

@Edgeer 

 

With your permission, if I can recommend you, add a file (without sensitive data) to your project.

Explain your plans in relation to this file. So you can get a solution that is tailored to your needs much faster.

At the same time, it is much easier for someone who wants to help to understand the subject.

A win-win situation for everyone.

Please no Picture, even if it is said that a picture can say a thousand words, it is certainly not in the case of Excel, on the contrary in some case

 

* Knowing the Excel version and operating system would also be an advantage.

 

P.s: In order not to be misunderstood, in the community it is the aim of excel users to give help on their project (from Excel users), or rather, to provide food for thought and not to deliver finished work or finished ideas.

 

Nevertheless, here is a formula to get you started:

=IF(AND(A2=3),IF(A3=3,1,""))

 

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

@Edgeer 

What's about other combinations, e.g. 12 in A2 and 3 in A3 or 99 both in A2 and A3? Perhaps some more general formal logic exists?