| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Return Top values with changing criteria
I am trying to return the top N values from a list with corresponding
names. The criteria for ranking changes. ColA:C contain my data (thousands of rows). ColD:E contain my criteria (note below I want to return top 3 values). ColF sorts in Top3 order. ColA ColB ColC ColD ColE ColF Movie Friday $25 Movie Friday $26 Movie Friday $26 Movie Friday $25 Movie Friday $18 Movie Friday $18 TV Tues $12 Movie Tues $21 TV Tues $19 Movie Tues $19 TV Tues $21 Movie Tues $12 I would like to use a formla that can rank the data when the two criteria in ColD & E are met. So when Movie and Friday show up in the list of thousands, just return the top 3 values. Then when Movie and Tues are met, return the top 3 values. I know this can be done, but I am having trouble fixing my formulas when the two criteria change. Thanks in advance for your help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| Return all values found for criteria | Excel Discussion (Misc queries) | |||
| Return across Row Numeric Values Matching EXACT Month & Year for Criteria | Excel Worksheet Functions | |||
| Return Numeric Values Matching EXACT Date for Criteria | Excel Worksheet Functions | |||
| Search multiple values to return single values | Excel Worksheet Functions | |||
Threaded Mode
