Excel Magic ✨ Find Students Scoring 81–90 Using FILTER (Perfect Logic!)

Finding students above 90 is easy.
But can you correctly extract students between 81 and 90 in Excel without overlap? 🤔

In this video, I use Excel’s powerful FILTER function to extract names and marks of students scoring 81–90 using this formula:
=FILTER(A2:B36,(B2:B36greator than symbol80)*(B2:B36lessthan symbol=90))
This method ensures:
✔ Clean ranges
✔ No duplicate names
✔ Correct analytical logic

👉 In the next video, I’ll show how to make this fully dynamic using cell-based limits.

Видео Excel Magic ✨ Find Students Scoring 81–90 Using FILTER (Perfect Logic!) канала Vedabala Vidyalaya