| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ranking different groups in one column
Sort the three columns by region and score. The store with the highest score
will appear first in the set of data for any region. Then just use VLOOKUP() to get the store name. -- Gary''s Student - gsnu200776 "Marie Bayes" wrote: Hi I have three columns, column A contains a 'region' name, column B, has the store name and column C has a 'score'. I want to rank the stores (B) within the region they're in (A) based on the score (C) and return the result into 1 column (D), is there a way to use the RANK formula so that I get each store's rank within their region returned into the one column (D)? Thanks in advance :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Validating Values Within Sets of Groups in a Column | Excel Discussion (Misc queries) | |||
| Dynamic stacked column chart with ranking | Charts and Charting in Excel | |||
| Ranking System For Large Groups | Excel Discussion (Misc queries) | |||
| Ranking a List which must be within GROUPS | Excel Discussion (Misc queries) | |||
| redistribute a column by a groups of rows | Excel Worksheet Functions | |||
Threaded Mode
