View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
tmirelle tmirelle is offline
external usenet poster
 
Posts: 26
Default Top 5 records by month

Need to graph top 5 reasons over time

Column A..... Column E
Date Issue
04-06-2006 Issue 1
04-06-2006 Issue 2
04-06-2006 Issue 2
04-12-2007 Issue 5

need to (on separate sheet)
list the top 5 issues by the month & the number of times the occured, as below

Apr 06 ...Mayetc...Dec06
Issue 2 2 Issue 5 1
Issue 1 1

Ultimately will produce a graph, but they want to see the data.

Open to better suggestions on achieving but need help!