Forum Discussion
Filter data and construct table
ajl_ahmed wouldn't it be easier to say: please filter list for all subjects with passing grade when the try#2 final result is "failed"? See attached.
mtarler Hi
I collected semester 1 results for the first and second attempts (the blue and yellow area in the attached file)and filtered them for the failed students only (I think this step will simplify the filtering of passed subjects process of the failed students). The student is considered to fail in a semester if it fails in both attempts of a semester. The same thing is done for the second semester. The final result of semester 1 is shown in column (WI) and for semester 2 column (XR) of the attached file. for each subject in semesters 1 and 2, a failed student can have:
- two marks (<50) in the first and second attempt respectively and this mark is not needed in the exception table.
- one mark (>=50) in the first attempt only and this mark and other details related to it is needed in the exception table. while in the second attempt, the mark of this subject should be blank ( blank cell information of the second attempt is not needed in the exception table).
- two marks; one mark (<50) in the first attempt and another mark (>=50) in the second attempt respectively. the mark (>=50) is needed in the exception table.
Could you please filter sheet P2 of the attached file to collect only subjects that have (mark>=50) and construct the table shown in the exception table sheet? it is better or me to keep the sequence of columns as it is and not change it, please. Many thanks for your efforts and time.
- I don't understand.
Didn't the previous solution do what you need?
You can just use the prior formula and change the ranges for the inputs. I think their names are clear enough.
If you have the list filtered like this you could also just use conditional formatting to HIGHLIGHT the passing grades so you can find them easily. You could even 'hide' the failing grades by making their text the same as the background.