Excel 2007 : Help with sorting a data table

Hi all,

I'm not sure if this is a solver problem or a sorting problem. I have a table of data with headers, I need to sort the data table based on several columns. The problem is I need to sort based on high to low on ALL the columns. I tried custom sorting, but this doesn't work, because I need to optimize each column at the same time.

For example,
A B
1 550000 550000
2 550000 880
3 90500 74000

Upon optimizing and sorting row three would be second, because I want highest to lowest in BOTH columns.

So my question is where do I start looking? Solver?

Thanks,

Max