View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
pgarcia pgarcia is offline
external usenet poster
 
Posts: 304
Default 2 part ranking question

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