Hi, I have a large spreadsheet that I have been working on for weeks now and mostly have it working except for one row not calculating how I need it to. I have made a smaller version to work on until I get it right, hoping someone can help me as I am going around in circles. The spreadsheet is a list of students who have completed assessments for each school term. I have data appearing in 3 sections (blue-Mid Term), (Green-End of Term), (Yellow-Combined).
Students have completed either a Mid-Term, End of Term or both or a combined assessment only. I have the spreadsheet working so that if a student completed more than 1 assessment it is to appear on the one row. The issue I am having is I have one student who did not complete a mid term assessment, but completed an end of term assessment only. There assessment is not appearing in the End of Term section (green section). My formula is obviously working in a way that if the student does not complete a mid term, no other assessments show up, but I cannot get it to work. I have highlighted the row not working which is row 13, record ID 54). I have tried every formula in my knowledge, but cannot get it to work. I hope the above makes sense and that someone can help me. I have attached the small trial spreadsheet to assist.
Students have completed either a Mid-Term, End of Term or both or a combined assessment only. I have the spreadsheet working so that if a student completed more than 1 assessment it is to appear on the one row. The issue I am having is I have one student who did not complete a mid term assessment, but completed an end of term assessment only. There assessment is not appearing in the End of Term section (green section). My formula is obviously working in a way that if the student does not complete a mid term, no other assessments show up, but I cannot get it to work. I have highlighted the row not working which is row 13, record ID 54). I have tried every formula in my knowledge, but cannot get it to work. I hope the above makes sense and that someone can help me. I have attached the small trial spreadsheet to assist.