Match formula
I think you need something like:
=SUM(--(COUNTIF(A1:E1,A2:E2)<0))
entered as array formula (i.e. confirmed with Shift+Ctrl+Enter). The
philosophy of this formula is that it goes over each element in row 2
and asks if the element appears at least once.
Is it what you want?
Kostis Vezerides
|