Thread: Counting the number of cells that have the same value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JCM JCM is offline
external usenet poster
  
Posts: 9
Default Counting the number of cells that have the same value
In column A I have a list of numbers that have many duplicates. In column B
I have a list of numbers. I would like to have a count of the number of
times the number in column b is in column A. I am using Excel 2003

Example
A B C
1 1 3
1 5 0
1 9 1
9
Reply With QuoteReply With Quote