+ Reply to Thread
Results 1 to 3 of 3

Make specific data (Date of birth, Amount$) stick to individuals (Names) to sort.

  1. #1
    Registered User
    Join Date
    04-30-2015
    Location
    Sweden
    MS-Off Ver
    2011
    Posts
    2

    Question Make specific data (Date of birth, Amount$) stick to individuals (Names) to sort.

    Sorry for this vague question, I don't know exactly how to formulate it with correct excel jargon.

    I need to be able to sort this data after age and amount so that the names, date of birth, and specific amount follows the three people through different sorting. In other words, I need to make the specific data stick to each name, so that for example Eric will always be born 85/07/12 and have 500$ in the bank.

    Name DOB Amount$

    Eric 85/07/12 500
    Chris 90/05/16 210
    Tom 86/11/09 600


    So that sorting after age from oldest to youngest would be:

    Eric 85/07/12 500
    Tom 86/11/09 600
    Chris 90/05/16 210

    Sorting after amount$ (High to low) would be

    Tom 86/11/09 600
    Eric 85/07/12 500
    Chris 90/05/16 210

    Do I do this through pivot tables or is there a specific command that makes the data stick to each individual?

    Thank you.

  2. #2
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    Office 365 ProPlus - work; 2012 for Mac at home
    Posts
    6,931

    Re: Make specific data (Date of birth, Amount$) stick to individuals (Names) to sort.

    you can place filters at the top of the column and use the sort function for the columns.
    Also in general using the sort function you can sort by multiple columns and it always asks if you (highlighting one column) want to expand the sort.
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci

  3. #3
    Registered User
    Join Date
    04-30-2015
    Location
    Sweden
    MS-Off Ver
    2011
    Posts
    2

    Re: Make specific data (Date of birth, Amount$) stick to individuals (Names) to sort.

    Thanks! ------------

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. From A Table Of Names And Birth Dates Pull A List Of Names As Of A Reference Date And Ther
    By rahuleyes in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 17
    Last Post: 11-27-2014, 03:44 PM
  2. Excel 2007 : Sort Players According to Birth Date
    By ortizj2 in forum Excel General
    Replies: 1
    Last Post: 01-23-2011, 08:31 PM
  3. Ading data and make excel add a number and stick with it
    By Hemmiv in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 05-07-2008, 08:02 AM
  4. Transfer names and date of birth
    By payments in forum Excel General
    Replies: 1
    Last Post: 03-29-2006, 07:20 AM
  5. Cemetery birth and death date sort
    By Lorene Schertzl in forum Excel General
    Replies: 1
    Last Post: 03-17-2006, 11:40 PM

Tags for this Thread

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