Forum Discussion
Formulas and Functions
I'll give you some backstory so you understand what I'm trying to accomplish. The school I work at accepts student enrollment based on a lottery process. Registrations are submitted, and then we draw...
=IFERROR(INDEX(Summary!C$2:C$1000, SMALL(IF( Summary!$J$2:$J$1000=4, ROW($J$2:$J$1000)-1),ROW($A1))),"")
An alternative could be this formula. The formula is in cell C2 of the "grade 4" sheet and filled across range C2:AD51. Enter the formula with ctrl+shift+enter if you don't work with Office 365 or Excel for the web or Excel 2021.
If i correctly understand column J in sheet "Summary" is where the grade is entered. The above formula selects all rows with grade = 4 in column J.
=FILTER(Summary!C2:AD1000,Summary!J2:J1000=4)
If you have access to the FILTER function you can apply the above formula in cell C2 of the "grade 4" sheet. This formula spills the results.