It is outlined on the question like I have tried the reactions (many thanks for those people), but what they do not I'm required.
The Master tab has hundreds of candidates records, which are from a large range of the previous year. I'm interested in 2 columns. Colonel A is included on the date when the candidate will take the test - Colonel candidate is included in the grade (difference, credit, referrals)
On a new tab, how many distinctions I had received, How many credits and how many referrals for last week only
It is easy to repeat it every new week on a new tab (hard boss!) As possible
Please specify the grade List (Column A is said at the beginning of row 1) in B1:
= COUNTIFS (sheet 1! A: A, "> 42005", Sheet 1! A: A, "42012", Sheet 1! B: B, A1) Copy and where your data is considered in Sheet 1. Numbers are numerical representations for ( 42005 , 42012 ) the relevant date range (such as 42005 ) that numeric format in my order 1/1/2015 In)
No comments:
Post a Comment