| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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. |
|
#2
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get a formula to use data from a fixed location(NOT vicev | Excel Discussion (Misc queries) | |||
| sort column data with hidden columns - excel 2003 | Excel Discussion (Misc queries) | |||
| Formula to post data in another spreadsheet | Excel Worksheet Functions | |||
| How do I plot data in Excel that is captured on separate sheets; . | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Linear Mode
