View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
willwork4food willwork4food is offline
external usenet poster
 
Posts: 1
Default How do I count how often a text or number appears in entire worksh

I have a worksheet of scheduled hours:

Sun Mon Tue Wed Thu Fri
off v v 6a^1 7a^2 v
v 8a^3 8a^3 8a^3 8a^3
MD1 MD1 MD1
AM*C* MD1 AM1 AM*C* MD1

How can I get the number of times, for instance, v appears?