Advanced Formatting Help

**Andy5** · 07-01-2013, 01:44 PM

I have a spreadsheet with names and dates. Many of the names are exact duplicates but with different dates in the adjacent cell. Is there any ways to organize the spreadsheet so that dates are listed in order from oldest to newest, BUT any duplicate names are kept next to one another?

Thanks

**Special-K** · 07-01-2013, 02:06 PM

Sort by name then date

**Andy5** · 07-01-2013, 02:32 PM

Doing this just sorts names alphabetically if they share the same date, it doesn't keep duplicate names next to one another. Or is there a way to sort using using both at the same time?

**tmanya** · 07-01-2013, 04:15 PM

Perhaps you could use a PivotTable with the Date then the Name in the Row Labels area.

**Rambo4711** · 07-02-2013, 03:22 AM

Originally Posted by Andy5

Doing this just sorts names alphabetically if they share the same date, it doesn't keep duplicate names next to one another. Or is there a way to sort using using both at the same time?

If you have Names in column A and Dates in column B, then mark column A and B. Then sort first on column B Ascending and second by column A Ascending.

Then you will have Dates in column B from the oldest to the newest and duplicate names next to one another in column A on the same dates.