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

32 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: 1633

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,209 Topics
31.6 K Posts
1 Online
35.1 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