Forum Discussion
Bonjour, souhait de faire une fonction SI
The Excel is like that so when i write the formula; Neither the Supplier; neither Oui or Non works
Hopefully this is a step in the right direction.
= IF(MAP(Fournisseur, CategoryCountλ)>=3, "Oui", "Non")
CategoryCountλ
= COUNTA(UNIQUE(FILTER(Category, Fournisseur = s)))
- alternatively by sql：
select Fournisseur,(select iif(count(distinct Category)>2,'Oui','Non') from count_distinct_category_of_each_suppliers b where a.Fournisseur=b.Fournisseur) Analyse,Category
from count_distinct_category_of_each_suppliers a; 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.
ThanksJust 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.
- Ahah no worry for the french, i understood your explanation so don't worry
- I wrote Suppliers instead of Fournisseurs to be easier for you
