How can I get excel to not only do a ranking using the sales of all the
employees, but also a rank by region as well? The real spreadsheet is much
larger and would take a lot of time to rank by hand. I would like to have a
formula do this, not sorting the list and then filling down. Thanks.

Steve