| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
a sort of GROUP BY data extraction question...
Example...
Data is in 3 columns. I have a drop-down list containing distinct values from col 1 (A,B,C,D). On selection of a value from this list I want find to find it's 2 highest values in column 2, and sum the corresponding column 3 values. I'm guesssing this will be some horrible kind of INDEX, MATCH, LARGE type array formula. A,12,1 B,28,2 C,34,3 D,46,4 A,52,5 D,66,6 C,77,7 A,83,8 B,95,9 D,51,10 C,42,11 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) | |||
| How do I sort (or group?) a spreadsheet by similar rows? | Excel Worksheet Functions | |||
| How do I group rows prior to a data sort so they stay together? | Excel Discussion (Misc queries) | |||
| How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
| Question about combining data from multiple workbooks into one rep | Excel Discussion (Misc queries) | |||
Threaded Mode
