View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Count of times a number is repeated by date?

A Pivot Table should do what you want to do:
http://peltiertech.com/Excel/Pivots/pivottables.htm

Regards,
Ryan---

--
RyGuy


"bjkeyt" wrote:

My spreadsheet has a record of every time a problems exsists. Problems are
classified by numbers 1-9.
A date may occur more than onces on the spread sheet, a classification may
occur more than onceon a date.
I need to summarized;
how many times a date occurs in spread sheet then how many times a
classification occures on that date.