+ Reply to Thread
Results 1 to 1 of 1

Link rows for sorting

  1. #1
    Registered User
    Join Date
    10-01-2004
    Posts
    1

    Link rows for sorting

    If this is addressed somewhere else I appologize. What I need to do is a simple sort based on the numeric value of a cell. Each item has three rows. a heading row with names, a value row with values under the names and last a blank for seperation.
    USA tim bill sam total
    55 43 50 138
    ---------blank row --------------
    Canada ...

    I would like to sort the sheet on the numeric total cell in the second row and keep the row above and below in the same location relative to the numeric row. There are, of course several other tripled rows for other countries.

    I can make it work by adding the total to a cell of each of the three rows and hiding it and also putting the "USA" in a hidden cell and sorting it as a secondary cell.

    There must be a better way.

    Cheers,
    Stan
    Last edited by StanDouglas; 05-15-2007 at 12:39 PM.

+ 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