Hi All,
I am struggling to find out a formula to run through my spreadsheet. I am attaching a sample excel sheet. In my first sheet, i want if my student ID has taken Maths/science/physics etc. class or not. There is a reference sheet which shows students have enrolled for which class.
I guess, i am struglling to figure out how to show the data in yes and no in the first sheet.
Thanks,
Abhishek
Bookmarks