Forum

Notifications
Clear all

Track data rows by weekly

2 Posts
2 Users
0 Reactions
91 Views
(@nearph)
Posts: 3
Active Member
Topic starter
 

Hi admin/everyone,

 

Thank you for the answer especially to Purfleet on my first thread.

I have another issue for the formula to use in tracking data in terms of week submissions.

 

Logic in excel:

* I want to track a person's data/rows made by days, and track the rows by 'weekly', so for example, for person A, committed 6 data rows and added it on March 3, & March 6. How can I track it using an excel formula by tracking it in March first week... and so forth.

 

Thank you very much admin/everyone.

 
Posted : 24/03/2020 5:32 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Raf,

You can use a PivotTable and group the dates. See example attached.

Mynda

 
Posted : 24/03/2020 7:54 pm
Share: