{"id":3242,"date":"2018-10-29T08:37:02","date_gmt":"2018-10-29T08:37:02","guid":{"rendered":"http:\/\/officetuts.net\/excel\/?p=3242"},"modified":"2024-03-30T11:30:10","modified_gmt":"2024-03-30T11:30:10","slug":"find-max-or-min-value-based-on-multiple-criteria","status":"publish","type":"post","link":"https:\/\/officetuts.net\/excel\/formulas\/find-max-or-min-value-based-on-multiple-criteria\/","title":{"rendered":"Find Max or Min Value Based on Multiple Criteria"},"content":{"rendered":"\n
Let\u2019s suppose you have an example with a list of people with names, age, and place of residence. What we want to do here is to select the youngest and the oldest woman who lives in Texas.<\/p>\n\n\n\n You can copy the following example and paste it into a worksheet.<\/p>\n\n\n\n Here, is what you need to do in order to find the highest and the lowest values.<\/p>\n\n\n\nFirst name<\/td> Last name<\/td> Sex<\/td> Age<\/td> State<\/td><\/tr> Emma<\/td> Smith<\/td> female<\/td> 75<\/td> California<\/td><\/tr> Logan<\/td> Johnson<\/td> male<\/td> 36<\/td> California<\/td><\/tr> Olivia<\/td> Williams<\/td> female<\/td> 2<\/td> Texas<\/td><\/tr> James<\/td> Jones<\/td> male<\/td> 75<\/td> California<\/td><\/tr> Noah<\/td> Brown<\/td> male<\/td> 56<\/td> Texas<\/td><\/tr> Ava<\/td> Davis<\/td> female<\/td> 68<\/td> Texas<\/td><\/tr> Sophia<\/td> Miller<\/td> female<\/td> 41<\/td> Texas<\/td><\/tr> Mia<\/td> Wilson<\/td> female<\/td> 14<\/td> California<\/td><\/tr> Liam<\/td> Moore<\/td> male<\/td> 3<\/td> Texas<\/td><\/tr> Amelia<\/td> Taylor<\/td> female<\/td> 42<\/td> Texas<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n Find max or min value based on multiple criteria<\/h2>\n\n\n\n
\n
=MAX(IF(C2:C11=\"female\",IF(E2:E11=\"Texas\",D2:D11)))<\/pre>\n\n\n\n