Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello all,
I have a list that changes daily. The data is a 3 digit station code, e.g. LAX, GGV, JFX, ect. First, I need to rank the station by occurrence, e.g. if LAX comes up 15x and GGV comes up 5x then LAX would be ranked 1 and GGV 2, ect. Then, rank the station to the division it finds it's self, e.g. LAX is Western, GGV Western, JFX Eastern, ect. (there are only three division, Western, Southern and Eastern). Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Ranking Formula Question | Excel Discussion (Misc queries) | |||
Tricky Ranking Question | Excel Discussion (Misc queries) | |||
Ranking question (ties) | Excel Discussion (Misc queries) | |||
Ranking formula question? | Excel Discussion (Misc queries) | |||
Another ranking question | Excel Worksheet Functions |