Excel Formula Challenge #6 – Get Student Count
Here is another query which came to our Excel VBA WhatsApp Group yesterday. Have a look at the screenshot below. Left table is the data table, Right table is the Result we need by excel formulas. Teacher 1 shows 15 in output, You can count the yellow cells row to get the idea to build your logic.
Download Sample Data hereFormula Challange #6 (168 downloads)
See more formula Challenges here