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
Attachments

245.1 KB Views: 9