View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sheila
 
Posts: n/a
Default how do I count the number of times text in column A matches text i

I'm trying to count the number of times text in one column, say, A matches
text in another column, say, B. So, if A1=B1, count = 1, then if A2=B2,
count = 2, for the whole of both columns.