i have a list of scores with mutliple groups that i am trying to rank within
each group. the RANK function only lets you rank by one range and not by the
group within the range. I am sure i can figure out a macro to accomplish it,
but i would prefer a formula.