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

  • Thread starter Excel_Challenged
  • Start date
E

Excel_Challenged

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
Sorting Macro 4
sumproduct using criteria from multiple columns in a separate wksh 1
sumproduct using criteria from 2 worksheets 1
Automation of scanned file storage based on content 0
Best 3 Consecutive Months 13
sum product with criteria from 2 wkshts 3
Additonal info into newly created Subtotal row 1

Top