| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Ranking different groups in one column
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
