Thread: [Solved] How can I count per year and per week the total number of times a code occurs
View Single Post
 
Old 06-25-2020, 11:32 AM
Stefan_Deckers Stefan_Deckers is offline Windows 10 Office 2010
Novice
  
Join Date: Jun 2020
Posts: 2
Stefan_Deckers is on a distinguished road
Default How can I count per year and per week the total number of times a code occurs
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”.
My idea is to use only a formula, so without using pivot table, etc.

Thank you in advance,

Stefan
Attached Files
File Type: xlsx Number of times code occurs per week in 2020.xlsx (245.1 KB, 12 views)
Reply With Quote