--Given an array of student scores, Return each Header of First Three Empty Cells within a Row--
Hello,
I often must report to my students their next three missing assignments. Each student's learning is individualized so each missing-assignment-list is unique.
Given an array of scores where each row is a student's name and a contiguous section of columns are the assignments, I'd like to add to each student row the following: first missing score header, second missing score header and third missing score header. This could be placed on a new sheet instead of at end of row.
I will have to add the columns or sheet I am seeking frequently (or paste data to a template) because I get new data frequently.
The list of students changes weekly but the assignment columns seldom changes.
Can you help?
Bookmarks