On Jul 29, 10:50 am, Mark R <Mark
wrote:
I have a spreadsheet that has clients names and then the date that I
submitted the business for them i.e

Mr Jones 12/12/2006 Abbey
Mrs Smith 12/01/2007 Natwest

What is the best way to count all the submitted business in 1 month say for
January only. Also how would i count all the Abbey cases in say 2007, or 2006

Use, from the Data Menu, Filter /Auto_Filter and or Sort. You can
do almost anything with these powerfull tools.

ed