Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sort Order?
Excel2003 ... Data Sort ... Sort, Then by, Then by ... Just a general
curiosity question. Col A contains PNs Col B contains Ops Col C contains Equip To have Equip (Ascend), inside of Ops (Ascend), inside of PNs (Ascend) I must Sort Equip, Ops, PN all Ascend & in this order if performing single Col Sorts of all data. If however, I am using the multiple sort ... Sort, Then by, Then by ... Does Excel perform the Sort in the same order as above ... or ... does it sort PNs, hold them in place ... then sort Ops within PNs, hold PNs & Ops in place .... then sort Equip inside of PN/Ops? Just curious ... so I am turning to those of you that are intimate with Excel ... My ongoing "Thanks" for your continued guidance ... Kha |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort order in 2007 | Excel Discussion (Misc queries) | |||
Default Sort Order | Excel Worksheet Functions | |||
sort last name order | Excel Discussion (Misc queries) | |||
sort order | Excel Discussion (Misc queries) | |||
sort in reverse order | Excel Discussion (Misc queries) |