+ Reply to Thread
Results 1 to 3 of 3

Keeping two columns together when sorting with a function?

  1. #1
    Registered User
    Join Date
    11-18-2009
    Location
    Illinois, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Keeping two columns together when sorting with a function?

    I have an inventory spreadsheet with data like this:

    Description Count
    Hammer 1
    Anvil 5
    Pliers 2


    I want to create two new sheets.
    One with the data in order by the Count
    and one with the data in order by the Description.
    Like this:

    Anvil 5
    Pliers 2
    Hammer 1

    and the other:

    Anvil 5
    Hammer 1
    Pliers 2

    I think I know how I can get the Count values into the
    correct order by using functions Large and Row/Rows.
    And I can do the same thing with the description.
    But how do I keep the two columns together?
    I think I need to have the Description cell and the
    Count cell managed as a pair. But I only want to
    evaluate one of the columns at a time.

    Well, thanks for any advice!
    Last edited by randyw57; 11-18-2009 at 08:04 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Keeping two columns together when sorting with a function?

    Hi,

    Just copy the original sheet twice (right click, Move or Copy and choose create a copy) then sort each new sheet using column A as the key sort field in one sheet and column B in the other.

    Rgds
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    11-18-2009
    Location
    Illinois, USA
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Keeping two columns together when sorting with a function?

    Thanks, Richard!
    I think that would mean using the Sort functions under the 'Sort & Filter' in Editing. When I tried using that it seemed that each sheet was 'static'.
    The information was correct initially. But when a change is made to
    the first sheet it didn't get reflected to the other sheets.
    That's why I thought I was going to have to use a function like
    Large along with Row or Rows to dynamically keep the other two sheets
    in sync.

    I'm going to attach a little spreadsheet that may possibly show
    what I'm trying to do a bit better. Here goes:
    Attached Files Attached Files

+ 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