Hello there!
I need some help on a formula I can enter on an Attendance/Score Spreadsheet.
Here is what the sheet looks like:
number__student name___START date___ month/day___ month/day___ month/day___ month/day____ m/d____ m/d____ m/d__ m/d___ m/d..............
1.________ doe, john____ 1/2/14________ Sc ore ______ Score _______"Blank" ______ Score_____ "blank"__ "blank"__"blank" "blank"....................
2. _______ smith, Karen__2/3/14________ "blank" _______ "blank"_____ "Blank"______ "Blank"_____ "blank"__ "blank" __ score score ....................
. .
. .
. .
27. .
We make a new page every 27 students for 2 months , then we make a new excel sheet.
We only count working days so there may be 3 days we are open and taking attendance a week
What I am trying to do is:
count any consecutive blanks(from begin date to current) and flag it, for a student that are "blank" greater than 90 || AND || link the excel sheets&pages in year so that we may count "blanks" in all sheets in consecutive order that way we can count the "blanks" correctly in order from January2014 to January2015.
Thanks so much in advance!!!!
Blanca
I need some help on a formula I can enter on an Attendance/Score Spreadsheet.
Here is what the sheet looks like:
number__student name___START date___ month/day___ month/day___ month/day___ month/day____ m/d____ m/d____ m/d__ m/d___ m/d..............
1.________ doe, john____ 1/2/14________ Sc ore ______ Score _______"Blank" ______ Score_____ "blank"__ "blank"__"blank" "blank"....................
2. _______ smith, Karen__2/3/14________ "blank" _______ "blank"_____ "Blank"______ "Blank"_____ "blank"__ "blank" __ score score ....................
. .
. .
. .
27. .
We make a new page every 27 students for 2 months , then we make a new excel sheet.
We only count working days so there may be 3 days we are open and taking attendance a week
What I am trying to do is:
count any consecutive blanks(from begin date to current) and flag it, for a student that are "blank" greater than 90 || AND || link the excel sheets&pages in year so that we may count "blanks" in all sheets in consecutive order that way we can count the "blanks" correctly in order from January2014 to January2015.
Thanks so much in advance!!!!
Blanca
Last edited: