Hi guys
I've been struggling with a formula all afternoon and thought I had it working a few times - I was sadly mistaken.
This spreadsheet is for checking that data has been entered for each student for every subject that they study - it is not obvious from the spreadsheet how difficult that is to see because the spreadsheet I have attached is so cut down from the one that we actually use. I can only say that this spreadsheet saves us hours of work every time we collect data for students - anyway I digress!
Most subjects work as they are very straigtforward - I've left a Spanish column in showing the formulas that we normally use. however, the Technology subjects are different in that the class names state which strand of technology the student is studying but all the grades are collected in one column - they only study one strand a term so there is never the need for grades for each strand and this makes reporting much much easier so we don't want to change the way we work.
We run a report that lists all the classes that students take and paste it into the table in StudentClass - here you can see the three types of technology that are studied by the students.
Data is also pasted into Subjects Status, in the grey areas of the table with the numeric grades they have achieved this data harvest.
The yellow headed columns check if the student studies a technology class and if so, checks for a grade in the grey cells, if there is not one there it returns "msng" - I have got this part working
The green headed columns check the yellow area for cells that contain "msng" and then I want the class name returned instead. I thought it was working but then realised it was only returning the final default option, the if(isnumber(search wasn't doing what I thought it was.
Can anyone help please?
Thank you in advance
Sue
Bookmarks