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

G

Guest

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.
 
N

Nick

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

Nick
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I copying data from a cell on sheet to a diff cell/sheet 1
Copy a formula to the right increasing the rows from another works 9
Sorting Macro 4
Conditional Sorting 5
Annual Payment Formula if Variable Interest Rate can change Monthl 2
Formula between sheets. 3
Sort a list of furmulated data 1
Get Values from another Worksheet 3

Top