Excel 2007 : Rank If Formula

[bleeg10]

Hi everyone,


I have a series of data that I need ranked based on a set criteria and I don't know how to proceed.

I have a bunch of sales agents that are ranked from highest paid to lowest paid. I rank them by "Overall Rank" which is the easy part. The hard part is, I have another column that I want to rank based on which market they belong to (see attached list). How would I do this?

[FDibbins]

If this is something you have to only perhaps once a day, could you try using the sort function (data/sort)?

For instance, you could sort 1st by "market", and then add another sort on "Overall Rank"?

If you have to do this very often, you could add a macro (button) that would do the sort in a single click. If this would be a better solution for you, an easy way to create the macro yourself would be to use the "learn" mode. It records your actions as you do them. When finished, create a "text Box" and link the macro to it.

Hope this helps