| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Return Top Ranks For Certain Categories in Column
ColA ColB Columnc Col Z Col AA Col Ab
Col Ac Apples Ship 3 Apples 1 Apples Train Apples Train 1 2 Apples Tree Apples Tree 2 3 Apples Ship Pears Ball 2 4 Apples Pen Pears Rock 1 Oranges Toy 1 Apples Pen 4 Orange Mack 2 Pears Sack 3 Had data is in the first 3 columns. By inputting text into cell Z1, I would like to return the rank, category and name in the Columns AA, AB and AC in order of rank. What formulas do I use in AA, AB, and AC? Thanks a lot. I know "Max" has something to do with it. Stevec |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| column chart with 3 categories | Charts and Charting in Excel | |||
| Create Stacked column of multiple values across categories | Charts and Charting in Excel | |||
| Column Chart - X axis too thin because of MANY categories. | Charts and Charting in Excel | |||
| How to create column of ranks. | Excel Discussion (Misc queries) | |||
| how do I sort a column with several categories (ie red and blue) | Excel Worksheet Functions | |||
Threaded Mode
