I'm newer to using excel on a daily basis. I have to create a "pretty" report that will keep track of the amount of entries for a specific team as well as identify individual members and their participation in submitting entries. I have a report that is pulled that has a separate line for each entry received. I would like to "tally" the amount of times someone's name appears in the lines as well as create a graph that shows total number of entries received weekly which I can then hopefully compile to monthly/quarterly. What is the best way to track this information and also create a graph that shows overall summaries?
TIA
Bookmarks