Multiple Filter/Sort

[RickNightCrawler]

My plan is to develop a list and sort it using filter. So when sorted there would be a number of rows with columns of the same information (i.e. half a column of "Walmart"s). But the idea would be to sort the data with the "Walmart"s only after that, so another column would be organized without conflicting with the previous sorted data.

How would I do this?

 

[Andrew Poulsom]

If you select only the rows containing Walmart and sort by some other column, you will get what you want. When sorting Excel preserves the existing order if a move isn't necessary.

 

[RickNightCrawler]

Thanks.

 

[RickNightCrawler]

The issue now is that I want one column such as dates to be sorted and then I want to sort the time for each date along with it. It is an extensive list, but here's an example:

3/1/09 5:00 PM
3/1/09 6:56 AM
3/1/09 8:00 PM
3/8/09 3:24 PM
2/17/09 4:08 AM
1/9/09 8:09 AM

So I would want to sort the first column and then have the second columns sorted depending on how they correspond to their adjoining date.

 

[ddadmin2009]

Check the below article

http://funwithexcel.blogspot.com/2009/04/compare-two-lists-of-data-using-excel.html

At the end of the article it is shown how to get data in different columns. Hope this helps. Let me know if you have questions.

 

[Andrew Poulsom]

Just select both columns and sort by the first (and by the second if you want).