ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Sorting with a drop down list (https://www.excelbanter.com/excel-programming/352096-sorting-drop-down-list.html)

[email protected]

Sorting with a drop down list
 
so i made the drop down list and sorted the sheet by that
column.....the problem is that many of the items (rows) need more then
one choice from the list.....so i had to manually enter the additional
list choices for those items as the drop down list only lets you make
one choice

now when i go to sort the rows are sorted only by the first choice and
the second choice is ignored....

is there any way to make a two or three or four column list to use as
the drop down choices....would that help? how do i sort with more then
one choice and still make sure the sort recognizes the additional
choices?

thanks!
rachel



All times are GMT +1. The time now is 02:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com