View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Toppers
 
Posts: n/a
Default sorting question

Try:

If you're sorting five columns A,B,C,D,E

sort the last three first, C,D,E and then sort A,B.

HTH

"LewR" wrote:


Looks like my post from early didn't post correctly, so I'll try again.

I have a spreadsheet that has 25 rows with 33 columns of data in each
row. I want to be able to sort the rows by using data in 5 columns
(not just 3 that the sort drop down box offers). Any ideas on how I
can do this?


--
LewR
------------------------------------------------------------------------
LewR's Profile: http://www.excelforum.com/member.php...o&userid=32420
View this thread: http://www.excelforum.com/showthread...hreadid=538189