?

Log in

prev | next

grrrr. (advanced excel question)

is there a way to have Excel understand how to make two separate columns part of the same sort?

Let's say that I have information in columns A-D, and in order to conserve on space and paper, i want to have that same information in columns E-H. And i want to sort and block out the data in columns A-D separately from E-H.

Does that make sense, and if so, is it possible?

edit: Let me make a clarification, because i think this is slightly confusing.

I want E-H to be sorted separately from A-D, but i want them to be part of the same sort.

Example:

Row 1 A-D has the numbers 1-1-1-1. E-H has the numbers 3-3-3-3.
Row 2 A-D has the numbers 4-4-4-4. E-H has the numbers 6-6-6-6.
Row 3 A-D has the numbers 2-2-2-2. E-H has the numbers 5-5-5-5.

What i want to be able to do is resort all of those in ascending numerical order so that Row 1A has the number 1, row 2A has the number 2, row 3A has the number 3, row 1E has the number 4, row 2E has the number 5, and row 3E has the number 6.

Comments

( read spoken (9) — speak )
letlygirl
Jul. 23rd, 2004 11:50 am (UTC)
I think I can help...
yes, yes it is -

If i'm understanding you correctly it is possible AND I know how to do it...

highlight the tops of columns a - d

alt + d + f + f
(sorry i'm a keyboard girl - hate them mices)

will sort only those colums that you have higlighted...then you can copy and paste etc etc as needed...

now, you'll have to sort each set of colums independantly...inserting your filters as you need...

does that help?
letlygirl
Jul. 23rd, 2004 12:03 pm (UTC)
woops
I lied...you can't do that unless the information is in two seperate lists - that's annoying...
lifeofmendel
Jul. 23rd, 2004 12:53 pm (UTC)
Re: woops
i think that regardless, that wouldn't have helped me, but i'm not sure. Look at my post again. made a clarification.
(Deleted comment)
lifeofmendel
Jul. 23rd, 2004 08:09 pm (UTC)
yeah, i figured that might be the best way. I just didn't want to have to create a separate sheet because i'm lazy. ;)
(Deleted comment)
lifeofmendel
Jul. 24th, 2004 03:48 am (UTC)
i think so? if what you're talking about is what i'm thinking about, then yes, except it's been a while.
(Deleted comment)
(Deleted comment)
( read spoken (9) — speak )

profile



welcome to the lifeofmendel

you can also find me here:

meSubscribe to me on YouTube

calendar

March 2017
S M T W T F S
   1234
567891011
12131415161718
19202122232425
262728293031