View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Piet Piet is offline
external usenet poster
 
Posts: 5
Default count identical values in 2 rows

I use Excel 2007

I have a table of about 50 columns and 60 rows.
Each row must be compared with the first row of the table:
Is there a formula, that counts the number of cells in each row that has an
identical value with the corresponding cell in the header?