Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sorting logic
Hi,
Is it safe to assume that when a sheet of 5 col and say 50 rows, and you sort by col two, the rows with the save value to col 2 (now together) will be in the same order as the orginal sheet -- Loyal |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel sorting logic
Are you asking if the sorting will reorder the fields that aren't used as keys?
Then the answer is no. Excel will keep those non-key fields in the same order as before the sort. Try a few experiments and you should be able to convince yourself. Loyal wrote: Hi, Is it safe to assume that when a sheet of 5 col and say 50 rows, and you sort by col two, the rows with the save value to col 2 (now together) will be in the same order as the orginal sheet -- Loyal -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What formulas to use for logic in excel | New Users to Excel | |||
Need help w/ logic statement in excel | Excel Worksheet Functions | |||
Excel Logic Statements | Excel Discussion (Misc queries) | |||
Excel logic | Excel Discussion (Misc queries) | |||
Excel Logic Function | Excel Discussion (Misc queries) |