Thread: Match formula
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid
 
Posts: n/a
Default 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