EXCEL-Function to find how many people does the oldest female live with

Question

I have the following data collected: 

 

persnum: Person number within the household Age: age of the person, htval: height of the person
I have highlighted them in the screenshot.
Finding a formula that indicates how many persons the tallest female respondent lives with is my goal.
I am aware that I must use the IF and max functions, but I am missing the function that returns the persnum since I am unsure of which to use.
This is my formula so far (missing the persnum part)

=MAX(IF(data!G11:G9291=2,data!T11:T9291))

Answer 1

You can try something like this:

=ROWS(FILTER(B11:B9291, T11:T9291=MAXIFS(T11:T9291,G11:G9291,2)))

It doesn't matter which column you use as the first input parameter for FILTER; all that matters is that it have the same form as the second input argument. It presumes that column T in the representation of height. Similar to adding additional limitations to MAXIFS, you can add as many criteria as you like (the only restriction is that it needs to be a range, not an array). For instance, I'm not sure how you can tell if someone is living based on the input data.

You can also use the entire column, if it makes sense for your case. As the following example: