Thread: How can I count the number of repeats in a list of data?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
vezerid
 
Posts: n/a
Default How can I count the number of repeats in a list of data?
Then you probably need something like:

=SUMPRODUCT((A1:A100=1)*(B1:B100=2))

HTH
Kostis Vezerides

Reply With QuoteReply With Quote