Seeking Help in counting the changes week by week for a certain criteria

[dlealb]

Hi All,

For all Pro out there, please help a newbie in counting/tracking changes week by week to identify x number of changes in a weekly basis for our roster.

Please see the sample excel file below

[dlealb]

Content Deleted by Poster.

[dlealb]

Hi All,

We have attached a sample excel file.

Highlighted in yellow are the expected results
Apologies for the hassle any help would be greatly appreciated

Ultimately we would just like to identify how many changes were made on a certain Position on a weekly basis

[JeteMc]

The formulas in column K suggest that the data in columns A:F should extend to row 3734, however the data in the file extends only to row 342 and there is no data for the weeks of 9/14 nor 9/21.
That said I feel as if the following will do what you want.
For counting by position: =COUNTIFS($C$34:$C$3734,$J4,$E$34:$E$3734,K$3)
For counting by queue: =COUNTIFS($B$34:$B$3734,$J26,$E$34:$E$3734,K$3)
Let us know if you have any questions.

[dlealb]

Thanks a Lot this definitely did it...
I really appreciate the assistance Sir

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Administrative Note:

Please don't quote whole posts, especially when you are responding to the one immediately preceding your own - it's just clutter. It's OK to quote if you are responding to a post out of sequence, but limit quoted content to a few relevant lines that makes clear to whom and what you are responding. Thanks!

For normal conversational replies, try using the QUICK REPLY box below or the REPLY button instead of REPLY WITH QUOTE.

[JeteMc]

You're Welcome and thank you for the feedback. I hope that you have a blessed day.