Excel 2013 Table.
Is it possible to sort an Excel Table by 2 columns, say date and address?
One column sorting is straightforward from the header but I can't see how to add a second level.
Thanks
Excel 2013 Table.
Is it possible to sort an Excel Table by 2 columns, say date and address?
One column sorting is straightforward from the header but I can't see how to add a second level.
Thanks
Just click and sort the columns in reverse priority order. Or do a Custom Sort.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Sorry didnt describe the question well enough, doh!
The Table layout I would like is in year blocks and then in address order within that.
So April 2011 to March 2012, then in address. There are 4 different address so not a big range.
Then April 2012 to March 2013, then in address.
Then April 2013 to March 2014, then in address.
Then April 2014 to March 2015, then in address, and so on...
Is that possible somehow in Custom Sort?
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks