+ Reply to Thread
Results 1 to 2 of 2

sorting columns from lowest to highest totals

  1. #1
    Registered User
    Join Date
    06-06-2007
    Posts
    1

    sorting columns from lowest to highest totals

    Very much an amateur excel user. If you respond don't assume I know very much about excel. Here is my problem:
    I have 26 columns on worksheet 1. Each column has a name in the top cell a telephone number in the second cell and then a cell with with a number (this number comes from worksheet 2). What I would like to do is to sort worksheet 1 automatically by the lowest number (associated name, tel. number would have to be displayed as well). Lowest numbered column on the left and each column to the right is the next highest in number.
    example:
    name A name B
    555 1212 555 2121

    3 2

    Sort the 3 and 2 with the names/tel#. If you can help me it certainly will be appreciated.

  2. #2
    Forum Contributor
    Join Date
    03-13-2005
    Posts
    6,195
    Quote Originally Posted by tvi569
    Very much an amateur excel user. If you respond don't assume I know very much about excel. Here is my problem:
    I have 26 columns on worksheet 1. Each column has a name in the top cell a telephone number in the second cell and then a cell with with a number (this number comes from worksheet 2). What I would like to do is to sort worksheet 1 automatically by the lowest number (associated name, tel. number would have to be displayed as well). Lowest numbered column on the left and each column to the right is the next highest in number.
    example:
    name A name B
    555 1212 555 2121

    3 2

    Sort the 3 and 2 with the names/tel#. If you can help me it certainly will be appreciated.
    Hi,

    select AllData (click the cell above the 1 in Row1, and left of the A in column headings, all the sheet should highlight)
    or, select the data you wish to sort.

    Data, Sort, Options, sort-left-to-right

    select Row 3 Ascending

    hth
    ---
    Si fractum non sit, noli id reficere.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1