Multiple Filter/Sort

RickNightCrawler

New Member
Joined
Apr 8, 2009
Messages
3
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

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
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

New Member
Joined
Apr 8, 2009
Messages
3
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.
 

Forum statistics

Threads
1,085,330
Messages
5,383,001
Members
401,811
Latest member
emelyan1379

Some videos you may like

This Week's Hot Topics

Top