Re: sorting question

Giganews Newsgroups
Subject: Re: sorting question
Posted by:  mrice (mrice.2773ga_1146598500.6855@excelforum-nospam.com)
Date: Tue, 2 May 2006

You can do this in two steps.

Sort first on columns 4 & 5 in your hierarchy followed by a second sort
for 1,2 & 3. Excel should not mix up the sort that you have already done
(or at least that's what the help pages said)

--
mrice

Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile:http://www.excelforum.com/member.php?action=getinfo&userid=10931
View this thread:http://www.excelforum.com/showthread.php?threadid=538189

Replies

None

In response to

sorting question posted by LewR on Tue, 2 May 2006