Results 1 to 6 of 6
  1. #1
    Senior Member
    Join Date
    Jan 2005
    Location
    Nelson
    Posts
    219

    Question Exel Spreadsheet

    Office 98. Exel
    Data Sort. Reasonably large sheet.
    I wish to sort on 4 columns - Area, Street, Street Number and one other.
    I go to "Data Sort" and I only get three options for column selection.
    Any clues how I can extend this to four so I can sort the whole sheet using a four column sort?
    Thanks for any suggestions.
    The floggings will continue until morale improves.
    No keyboard detected. Press F1 to continue.

  2. #2
    Pedantic Bloke Sweep's Avatar
    Join Date
    Jan 2006
    Location
    Tokoroa
    Posts
    7,671

    Default Re: Exel Spreadsheet

    I don't think you can sort on four columns.

    But you can select all four colums and sort on one of them then select all four columns and sort on the other three.

    Two step operation but will give the correct result.

  3. #3
    Senior Member
    Join Date
    Dec 2004
    Location
    Wellington, NZ
    Posts
    353

    Default Re: Exel Spreadsheet

    Hi Woody, you need to basically fudge it by using a dummy column that concatenates the columns you want. For example, say I have data in A1:H20 and I want to sort by col H then A then B then C.

    In column I, enter the following formula in cell I2 and copy the foemula downwards...
    =H2&A2&B2&C2

    You can now sort by column I. After sorting you can hide column I.

    cheers,
    Graham

  4. #4
    Pedantic Bloke Sweep's Avatar
    Join Date
    Jan 2006
    Location
    Tokoroa
    Posts
    7,671

    Default Re: Exel Spreadsheet

    Quote Originally Posted by Parry View Post
    Hi Woody, you need to basically fudge it by using a dummy column that concatenates the columns you want. For example, say I have data in A1:H20 and I want to sort by col H then A then B then C.

    In column I, enter the following formula in cell I2 and copy the foemula downwards...
    =H2&A2&B2&C2

    You can now sort by column I. After sorting you can hide column I.

    cheers,
    Graham
    A more elegant solution I think.
    Thanks for that.

  5. #5
    pcsourcepoint
    Join Date
    May 2006
    Location
    Otara, Auckland
    Posts
    3,055

    Default Re: Exel Spreadsheet

    Advanced filter may help, if you intend to sort/filter any numerical data using a range of data...
    Computer Tech Links (My Tutorials & Reviews)| Free MP3 Software Reviews (My Reviews)|I Student NZ (My Student Resoucre Tips)

  6. #6
    Senior Member
    Join Date
    Jan 2005
    Location
    Nelson
    Posts
    219

    Smile Re: Exel Spreadsheet

    Thanks guys,
    Used your method Barry with a few mod's to suit my particular situation.
    All fine now.
    Cheers
    The floggings will continue until morale improves.
    No keyboard detected. Press F1 to continue.

Similar Threads

  1. Exel Problem
    By heaton in forum PressF1
    Replies: 5
    Last Post: 02-09-2005, 05:20 PM
  2. MSWorks spreadsheet
    By aandhwhite in forum PressF1
    Replies: 3
    Last Post: 17-03-2005, 10:56 AM
  3. XL Spreadsheet
    By B.M. in forum PressF1
    Replies: 5
    Last Post: 08-12-2003, 01:38 PM
  4. exel XP comments
    By in forum PressF1
    Replies: 0
    Last Post: 19-11-2001, 01:10 PM
  5. Exel
    By in forum PressF1
    Replies: 0
    Last Post: 14-09-2000, 07:36 AM

Posting Permissions

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