Forum Discussion
Bonjour, souhait de faire une fonction SI
Thank you so much because i understood your procedure, and i tried to apply it to my work,
For C qnd G columns i used =UNIQUE(B11:B119871) and =UNIQUE(F11:F119871)
For D qnd H columns =NBVAL(UNIQUE(B11:B119871))
COUNTA in french is NBVAL.
So now for the CategoryCountλ i got an error :
Excel does'nt recognize the "categories" word i guess ....
And it is the same for
= IF(MAP(Fournisseur, CategoryCountλ)>=3, "Oui", "Non")
If you can help me to understand this mistake, after i will be good.
Thanks
Just to check, I assume you are using Excel 365 since the tool tip seems to accept UNIQUE and offers the French word 'matrice' rather than the English 'array'.
'Categories' would need to defined in Name Manger to reference the green column of your table, just as 'supplier/fournisseur' refers to the blue column. The error you show may be no more than a complaint about the "," (comma) being used as a separator whereas French localisation requires ";" (semi-colon).
Hopefully you will be allowed to post workbooks soon so that I am better able to examine your formulas. My apologies for addressing you in English, regrettably my attempting French would not improve our communication.