Sort by more than 3 columns

C

Chip Pearson

Carley,

You need to sort multiple times. On the first time, sort on the
least significant columns (typically the right-most columns), and
then sort on the more significant columns (typically the
left-most columns). Work your way from least to most
significant.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables. 0
Cell data entering slow! 0
Cannot sort a table containing text 5
How can I give customized drop down in Ms Forms online or refer dropdown from excel list 0
return multiple values when within range (greater than and less than) 11
Sort Question 1
Make elements in a row space between instead of wrapping when choosing multiple columns 0
Autonumber field in Excel that behaves the same as Access 0

Top