How can I count per year and per week the total number of times a code occurs

General Excel Questions & Answers

Last Post by Philip Treacy 5 years ago

2 Posts

2 Users

0 Reactions

63 Views

RSS

Stefan Deckers

(@stefan-deckers)

Posts: 1

New Member

Topic starter

Dear,

How can I count per year and per week the total number of times a code occurs => only using column “Date” and column “Code”; so without extra “helper”- columns “Weeknumber” & “Year”.

Thank you in advance,

Stefan

Posted : 22/06/2020 5:54 pm

Philip Treacy

(@philipt)

Posts: 1631

Member Admin

Hi Stefan,

If you leave the week number column in the source data table you can use a pivot table to summarise the data as you wish. There are some weeks without data.

Regards

Phil

Posted : 22/06/2020 8:50 pm

26 Forums
7,246 Topics
31.8 K Posts
5 Online
35.2 K Members

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

How can I count per year and per week the total number of times a code occurs

Super Globals

Options and Features