There is a smarter way to build a test from a large question bank, and it does not require manually sifting through 200 rows hoping the right questions surface. The user who asked this question is not looking for a workaround; they are looking for a system, and Excel can absolutely deliver it with the right approach. The core task is straightforward: pull one question per lesson objective, consistently, every time, without losing your mind to formatting chaos.
The practical move here is to stop thinking of the question bank as a flat list and start treating it as a structured dataset. If each question row includes a column for its associated lesson objective, then the solution becomes a matter of using a combination of sorting, filtering, and a formula like INDEX and MATCH, or even a pivot table to isolate the first question per objective. For a bank of 200 questions, you can sort by objective, then use a helper column that flags the first occurrence of each objective, and finally filter for those flags. That gives you a clean, repeatable table of 50 questions without touching a single cell manually. It is not a hack; it is the correct way to handle structured data.
What makes this situation worth commenting on is that the user already knows what they want. They are not asking for a magic button or a complex macro. They are asking if Excel can handle a logical, repeatable selection process. The answer is yes, but the real insight is that the solution lives in how you organize the data before you even open a formula. If the question bank is clean, with objectives labeled consistently, the extraction is trivial. If the labels are messy, the problem is not Excel; it is the data hygiene. So the first step is not to search for a formula but to confirm that the objective column exists and is uniform.
The takeaway for anyone facing this same challenge is to embrace the constraint. Pulling one question per objective is not a limitation; it is a design decision that forces you to be intentional about coverage and balance. It ensures your test is not accidentally weighted toward one topic or another. That is a good thing, and it is worth doing on purpose. So open the bank, check your columns, sort by objective, and let the spreadsheet do the heavy lifting. The 50 questions are already in there. You just need the right structure to pull them out.