Hi everybody,
I prepared an excel spreadsheet for my students. It contains their marks and grades. The spreadsheet is divided into to worksheets. The first contains their marks and grades and in the second worksheet i want to include a list of those who failed. Would you please help me in finding a suitable function which will automatically add the names and data of failure students into the second worksheet. I do not want the list of failures to include any blank rows. For example, if I passed one of those who failed, his name will disappear from the list of failures and the row itself will be removed. I attached my spreadsheet so that you will get a clearer idea.
Bookmarks