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))
Jan 13, 2023 in Others 553 views

## 1 answer to this question.

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:

• 63,720 points

## how to show the <meta> values of yoast seo with some function?

check this folder : wordpress-seo\src\presenters\open-graph you can ...READ MORE

## How to get the JasperReports into Excel format with proper alignment

Remove at least one parameter: exporter.setParameter(JRXlsExporterParameter.IS_COLLAPSE_ROW_SPAN,Boolean.TRUE) Note that JRXlsExportParameter is deprecated the correct ...READ MORE

## Help needed with Median If in Excel

Try entering the formula =MEDIAN(IF(\$A\$1:\$A\$6="Airline",\$B\$1:\$B\$6,"")) in another ...READ MORE

## Excel feet and inches to millimeters

There are certain direct formulas to convert ...READ MORE

## Convert image (jpg, png, jpeg) to base64

Try this - it will perform the ...READ MORE

## IF function in combination with an Round function Excel

I'm not sure if it is a ...READ MORE