| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
min in a subgroup
A variation of a multiple criteria lookup question, this time using the "max"
function: Column A Column B Column C Apples text1 1 Apples text23 2 Apples text52 20 Apples etc 14 Oranges 2 Oranges 23 Cell D2 = Apples What formula in cell E2 will find the maximum value Column C for all Apples, and return the associated cell in Column B (in this case, "text52") thanks a lot! Stevec |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Top 10 filter within subgroup | Excel Discussion (Misc queries) | |||
| Selecting number of hours per subgroup | Excel Discussion (Misc queries) | |||
| Finding max value within a subgroup | Excel Worksheet Functions | |||
| Matching max in a subgroup with corresponding data pair | Excel Worksheet Functions | |||
| how can I rank within a subgroup? | Excel Worksheet Functions | |||
Threaded Mode
