Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting data
I have a range of data and need to sort four colums but when I use the sort
key it only allows me to sort 3 types. For instance I need to sort company name, product name, date ordered, and origin of product. (those are my four colums) and the sort function only allows me to use 3. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sorting data
Sort ONLY the origin of product;
Then Sort the First three - all at once designating how each of the 3 should be sorted. I think the # 4 field will follow along.. "madobbs" wrote: I have a range of data and need to sort four colums but when I use the sort key it only allows me to sort 3 types. For instance I need to sort company name, product name, date ordered, and origin of product. (those are my four colums) and the sort function only allows me to use 3. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ranking query | Excel Discussion (Misc queries) | |||
sorting data and automatic graphs | Charts and Charting in Excel | |||
Inserting a new line when external data changes | Excel Discussion (Misc queries) | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
how do you prevent data from changing values when sorting linked . | Excel Discussion (Misc queries) |