•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How to grab one example from a row by name?
Our take
Are you looking to streamline your testing process by selecting one question per lesson objective from a substantial question bank? If you have over 200 questions and need to extract 50 to build an effective table, Excel can help. With its powerful functions, you can easily reference and pull specific questions based on their names or categories. This approach not only saves time but also ensures that your assessments are aligned with your learning objectives. Let’s explore how to efficiently accomplish this task in Excel.
Hey all, i'm looking to create a test from a bank of questions, and am trying to pull one question per lesson objective. Example:
If I wanted to take one question from each unit, and build a table from that, is there a way to do this with Excel? The question bank is 200+ questions, and I'm trying to pull 50 from the bank.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience