Forum Discussion
Return a text value into different cells in a column based on specific criteria
I am an educator attempting to create a sophisticated spreadsheet for our school's student growth tracking. I've gotten pretty far, but need support (and my DOT's isn't helping) in populating the names of my students in different categories based on their score averages. For example: I have students names listed in A4:A60 and their average scores on an assessment in B4:B60. I want to create a range where all students who scored <3 have their names populated in a new worksheet in ONE particular column and all of the names of students who scored between 2 and 3 to populate in a different column. As the scores change (as they get better at the skill), their names should MOVE to the correct column automatically. I've tried VLOOKUP, but I can't seem to get it to do what I want in the entire column (not just one cell).
Also, I am trying to create a "perminent record" of all of the strategies we try for particular students. Every time a change is made for a student, I want the original row for that students to automatically populate in a seperate worksheet. Is this even possible?
The file I've been working in is attached.
1 Reply
Hello,
you could create different pivot tables to report on students with specific grade averages. You can filter each pivot table to show only students with a specific average range.
Your workbook is a bit too overwhelming (too much information). It's not quite clear where the source is.
In general, you should avoid the practice of entering empty columns to separate chunks of your data. Enter data into contiguous tables, then it's easy to report on the data.
With regards to your second question: yes, this can be done, but it will probably require VBA. It would be easier to give better advice if you could be a bit more specific. Provide a small (!) data sample, mock up the desired result and explain what logic leads to the result. Since this is a second question in the same thread, you may want to start a new question for that specific issue, so each question can be marked as solved separately.
