Pulling data if a different data set reaches a specific value??

Hello.
I'm not super experienced in Excel but I've been teaching myself (and probably using it in ways that don't really make sense) in my new job as an office manager at a preschool. Currently, I use Excel for a lot of things - one of which is to do attendance and keep track of excused and unexcused absences.

What I would really like is to be able to automatically pull names of kids who reach a certain number of unexcused absences to a separate sheet that I can print for our director. So, if the value of AH10 (number of unexcused absences reaches 8 I would want it to pull the data from B10 (the name) and place it in a different sheet.

I would love help figuring out a way to do this, or just someone to tell me it's not possible.

I've attached (I think) a simplified version of the sheet as I use it now, but usually it has 8-15 classrooms, not just the one

Sample.xlsx

=IFERROR(INDEX(Ladybug!B:B,AGGREGATE(15,6,ROW(Ladybug!$B$4:$B$17)/(Ladybug!$AH$4:$AH$17>=8),ROWS(B$3:B3))),"")

copy down. In your real data, adjust the bit in red to match the cell reference of the cell you FIRST use the formula in. Careful to get the $ correct.

Mmm. So you don't want a list for each sheet. Multi-sheet formulae are HUGELY messy, unless you have O365.

Options


1. Have a list per class. I assumed that that was what you wanted.

2. Use PowerQuery (we'd need to see a sample with - at least - 2 class sheets).

3. use VBA. ditto re sample sheets.

How many sheets in total? If it's 8-15... forget formulae (without O365).