Sorting
Sorting
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Sorting

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have 100 trucks ( column A ) numbered 1 - 100 in rows 3 thru 102. Columns B-C-D-E-F-G-H-I-J-K-L-M-N-O-P represent what each truck is carrying. Some trucks have the same items from columns B thru P and some do not. I want to sort the columns B thru P to find which trucks are hauling the same loads. My hangup seems to be that the trucks have a truck # which I must maintain. I currently highlight the entire range ( including truck # in column A and sort by one column at a time. Is there a faster way ? Thanks...........

    _________________


    [ This Message was edited by: ncferro on 2002-03-14 12:56 ]

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Have you tried doing sub sorts on your columns? You may have all ready done this but thought I would mention it.

    Rick

  3. #3
    MrExcel MVP Von Pookie's Avatar
    Join Date
    Feb 2002
    Location
    The act or process of locating.
    Posts
    13,686
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Maybe try using the autofilter? Choose one item from column b, and the rest should automatically filter to the same thing.

    Hope that helps (and makes sense for that matter! )

    _________________
    "What am I, a magnet for these idiots?"
    --Pearl Forrester, MST3K

    [ This Message was edited by: Von Pookie on 2002-03-14 13:24 ]

  4. #4
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    You'd have an easier time if your data was reorganized. Why have you chosen this organization? I understand the columns B:P contain load descriptions, but are these at different times, dates, or possible configurations? Why 15 columns? Are some of these cells in these columns empty? Can you provide some sample data?

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com