Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I sort a list that contains blanks that I want to keep?
I have copied a list from a pivot table, so there are blanks. Is there a way
for me to sort, and maintain those blanks. For example I have a list that looks kind of like this: John Smith Red Orange Yellow John Doe Green Mary Peters Red Purple It is important to know that John Smith goes along with Red, Orange and Yellow. But I want to be able to sort the page so all of the people that only like one color are grouped together and all of the people with multiple colors are grouped together. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you sort a list of dates into date order | Excel Discussion (Misc queries) | |||
custom list does not sort | Excel Worksheet Functions | |||
I want to sort everything but my validation list | Excel Worksheet Functions | |||
loop trough e-mail address list to send task lists with outlook | Excel Discussion (Misc queries) | |||
How to sort a list correctly? | New Users to Excel |