title: Selecting groups of cells by condition?
body: <p>i have an excel sheet like this:</p>
  
  <pre>
  Category     Gender      Age    Max male age
  A             M          49
                F          38
                F          47
                M          41
  B             M          49
                F          38
                F          47
                M          41
  
  </pre>
  
  <p>I want to display the max. male age for each category. The number of people in each category isn't fixed. Is this possible using excel formulas, or do i have to use VBA?</p>