Hello All:
I am looking to extract data (k-12 registration data) from a large spreadsheet and parse it out to smaller tabs (by grade levels). I've tried reverse engineering a formula from Mr. Excel YouTube #789, but I can't seem to wrap my head around the formula.
For example:
Student ID | Grade_Level (primary search criteria) | LName | FName | DOB | Gender (up to 35 data points)
The data set sample is:
<tbody>
</tbody>
I want to filter all K grade to the K grade tab; 1st grade to 1st grade tab, etc. I think I should have AGGREGATE, MATCH and INDEX somewhere in there, but I can't seem to get the data to extract the way it should.
Help?
Many thanks in advance!
S
I am looking to extract data (k-12 registration data) from a large spreadsheet and parse it out to smaller tabs (by grade levels). I've tried reverse engineering a formula from Mr. Excel YouTube #789, but I can't seem to wrap my head around the formula.
For example:
Student ID | Grade_Level (primary search criteria) | LName | FName | DOB | Gender (up to 35 data points)
The data set sample is:
StudentID | Grade Level | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D | D |
4000 | K | |||||||||||||||||||||||||||||||||
4001 | 1 | |||||||||||||||||||||||||||||||||
4002 | 5 | |||||||||||||||||||||||||||||||||
4003 | 7 |
<tbody>
</tbody>
I want to filter all K grade to the K grade tab; 1st grade to 1st grade tab, etc. I think I should have AGGREGATE, MATCH and INDEX somewhere in there, but I can't seem to get the data to extract the way it should.
Help?
Many thanks in advance!
S