=AND(COUNT(B1:B3)<2;COUNT(C1:C3)<2;COUNT(D1:D3)<2; COUNT(E1:E3)<2;COUNT(F1:F3)<2)
Has 20 fewer keystrokes.




--
www.stfx.ca/people/bliengme


"ytayta555" wrote:

Good night

I need strongly an equivalent for this function ,
how is it posted here , but better with another
functions :

=AND(COUNT(B1;B2;B3)<=1;COUNT(C1;C2;C3)<=1;COUNT(D 1;D2;D3)<=1;COUNT(E1;E2;E3)<=1;COUNT(F1;F2;F3)<=1)

many thanks