| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Rank - Specific match only
Hi there,
I would like to Scan the Region column and rank the Revenue column, only if the Region matches 'SK'. Right now it ranks based on the entire list a1:a9....I want it to only rank on the number of entries equal to region 'SK' Any suggestions? Thanks Tim A B C 1 Region Revenue Rank 2 SK 2,500 3 North-AB 3,000 4 SK 3,300 5 South-AB 1,985 6 North-AB 1,650 7 SK 2,300 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| Look up data in colum a and find match in colum b | Excel Discussion (Misc queries) | |||
| formula to extract specific data if match occurs | Excel Worksheet Functions | |||
| Find a match that;s not exact | Excel Worksheet Functions | |||
| Vlookup, Index & Match | Excel Worksheet Functions | |||
Threaded Mode
