Thread: How do I calculate how many instances of a number appear in a wksh
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JC in Aus JC in Aus is offline
external usenet poster
  
Posts: 1
Default How do I calculate how many instances of a number appear in a wksh
For instance, if I have a worksheet which has 3000 cells with difference
numbers in each, how can i report on how many cells contain the number 11,
and so on?

I want to report on around 50 numbers, and show how many times all 50
numbers appear in the worksheet in some sort of report.

Would really appreciate it if someone could help.
Reply With QuoteReply With Quote