Home |
Search |
Today's Posts |
#1
|
|||
|
|||
drop-down sort
hi,
could you please let me know how you can sort from a drop-down? i know you can list items €¦ but how can you make it sort ascending and descending? for example, say , cells/columns a5:bL5 are the titles for the information; "site number", "manager", "region" et cetera ... so what i want is when i do data;validation and insert my drop down ... and source the data off of a5:bL5 when i choose say ... "site number" it'll give me the option to sort by ascending or descending ... or if both isn't applicable then maybe just ascending ... i hope this makes sense. can someone help me? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I sort by row instead of by column? | Excel Worksheet Functions | |||
How do I sort a column of data and have each data row sort accordi | Excel Discussion (Misc queries) | |||
automatic color change in cells using a drop down list | Excel Worksheet Functions | |||
"-" ignored in sort | Excel Discussion (Misc queries) | |||
Excel Sort function should not sort the cell formatting! | Excel Worksheet Functions |