View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
SirMetro SirMetro is offline
external usenet poster
 
Posts: 4
Default Macro to Count how many times a number occurs on a day

Crazy question, is there a simple macro that will allow me to count how
many times a number occurs on a given day of the week? The current format
of the spread sheet is this:

Column A B C D E F
Day | Date | Series | #1 | #2 | #3
Sun | 1/1/05 | 123 | 1 | 2 | 3

What I want to do is count how many times a number occurs on a given day
of the week without having to manually sort, physically count and rewrite
a plain simple sort routine. Is there any there that can help me with
either a simple macro (or heaven forbid, VBA code)???
Thanks,
Sir Metro