Selecting groups of cells by condition?

excel, excel-formula

Solution

You can do this by

- Filling out your categories

- Using a PivotTable on your date

Filling Out Column A

- Select column A

- Press F5 .... Special

- pick Blanks and hit 'Ok'

- in the formula bar type =A2 (your first category cell)

- hit cntrlenter together

see Debra Dalgleish'site for a good reference on this method

Insert a PivotTable - Select your data (A1:C9 in my screenshot) - Insert .... PivotTable (in Excel 2010) - As a `Row` label drag in Category, for `Column` label drag in Gender - for`Values` drag in Age, and left click the field and pick `Max`

Again,a good reference from Debra

Problem

i have an excel sheet like this: ``` Category Gender Age Max male age A M 49 F 38 F 47 M 41 B M 49 F 38 F 47 M 41 ``` 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?

Original source