#1   Report Post  
Old June 16th 06, 02:55 PM posted to microsoft.public.excel.worksheet.functions
digisummo
 
Posts: n/a
Default [sorting rows]


Hello everyone,

I am trying to sort part numbers from column1 but I want the
descriptions which are in other columns 3-10 to follow the numbers. I
want to use the sort command but I think it will only sort column 1 and
not take the descriptions and other information purtaining to that
number in the other columns. How can i tell excel to take the
horizontal data in the other columns with it?
Hopefuly I haven't confused anyone to much here.
Thanks in advance for the help. Here is the file.
-Nate


+-------------------------------------------------------------------+
|Filename: Aeron parts4682945.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4897 |
+-------------------------------------------------------------------+

--
digisummo
------------------------------------------------------------------------
digisummo's Profile: http://www.excelforum.com/member.php...o&userid=35495
View this thread: http://www.excelforum.com/showthread...hreadid=552663


  #2   Report Post  
Old June 16th 06, 03:45 PM posted to microsoft.public.excel.worksheet.functions
Tim M
 
Posts: n/a
Default [sorting rows]

It will sort whatever columns you hilight. so you can left click and hilight
all the cells you want sorted. Then it will ask you what you want to sort
by, you will chose the part number column. It will then sort by part number
and will take the descriptions and such along with it. (Thus it will bring
the proper description along with the proper part number as long as you
hi-lite both of those rows in the original sort.0

"digisummo" wrote:


Hello everyone,

I am trying to sort part numbers from column1 but I want the
descriptions which are in other columns 3-10 to follow the numbers. I
want to use the sort command but I think it will only sort column 1 and
not take the descriptions and other information purtaining to that
number in the other columns. How can i tell excel to take the
horizontal data in the other columns with it?
Hopefuly I haven't confused anyone to much here.
Thanks in advance for the help. Here is the file.
-Nate


+-------------------------------------------------------------------+
|Filename: Aeron parts4682945.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4897 |
+-------------------------------------------------------------------+

--
digisummo
------------------------------------------------------------------------
digisummo's Profile: http://www.excelforum.com/member.php...o&userid=35495
View this thread: http://www.excelforum.com/showthread...hreadid=552663




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:30 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017