What formula will sort data in a separate worksheet%3f
 

I have a worksheet that I'll call Wksht A. It contains data such as Bill
type, Bill Balance, Monthly Pymt and Interest Rate. I want to sort this
information by Interest Rate (highest to lowest) and then by Bill Balance
(lowest to highest). But I want the information to be sorted on another
worksheet - Wksht B.

What formulas will do this?

Thanks.

Pivot Tables are the best way to go for this.
Check out the help files in Excel.

Nick


"Excel_Challenged" wrote in
message ...
I have a worksheet that I'll call Wksht A. It contains data such as Bill
type, Bill Balance, Monthly Pymt and Interest Rate. I want to sort this
information by Interest Rate (highest to lowest) and then by Bill Balance
(lowest to highest). But I want the information to be sorted on another
worksheet - Wksht B.

What formulas will do this?

Thanks.