Stefan Deckers
New Member
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
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