+ Reply to Thread
Results 1 to 7 of 7

How can I match Names to Numbers?

  1. #1
    Registered User
    Join Date
    02-18-2016
    Location
    usa
    MS-Off Ver
    2013
    Posts
    24

    How can I match Names to Numbers?

    If I were to copy/paste a list of names and a list of scores and put the names from A1-A7 and numbers in B1-B7:

    Alan 98
    Bob 93
    Chris 88
    Dave 75
    Eric 73
    Fred 71
    Greg 66

    And then in C1-C7 list names and D1-D7 list new numbers:

    Eric 100
    Alan 99
    Dave 95
    Bob 88
    Greg 77
    Chris 74
    Fred 63

    Is there a way to 'match' the names and list them in order? so I can then just total their grades (adding B1 and D1 in this example). I realize in my example I can just list in alphabetical order, but is there a way to organize the names using another function?

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    13,922

    Re: How can I match Names to Numbers?

    If the order that the names occur in column C is sufficient then you could put the following formula in E1 and copy down:
    Please Login or Register  to view this content.
    Let me know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    02-18-2016
    Location
    usa
    MS-Off Ver
    2013
    Posts
    24

    Re: How can I match Names to Numbers?

    That is great JeteMc, thank you. So in this formula, you arent actually moving anything from C to match the order of A.....am I correct that you are simply matching C1 to A1 in a way to organize it so it's added to D? Do I have this correct?

    this formula is locking in "C" do I have that right? so the order is now based on C, not A, right?

    thank you again

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    13,922

    Re: How can I match Names to Numbers?

    Yes, the total scores are reported in the order that the names appear in column C. You are welcome and thank you for the feedback. If your question has been answered satisfactorily please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    13,922

    Re: How can I match Names to Numbers?

    Deleted by JeteMc
    Last edited by JeteMc; 02-19-2016 at 12:51 AM. Reason: Duplicate

  6. #6
    Registered User
    Join Date
    02-18-2016
    Location
    usa
    MS-Off Ver
    2013
    Posts
    24

    Re: How can I match Names to Numbers?

    Quote Originally Posted by JeteMc View Post
    Yes, the total scores are reported in the order that the names appear in column C. You are welcome and thank you for the feedback. If your question has been answered satisfactorily please take a moment to mark the thread 'Solved' using the thread tools link above your first post. I hope that you have a good day.

    you were very helpful and did answer my question. but if I may, before I mark Solved, ask one followup please. what would the code be for a 3rd group of names and numbers? Names in A, C, E. Numbers in B, D, F.

    Would you mind please explaining how that would work? And again, thank you for everything.

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    13,922

    Re: How can I match Names to Numbers?

    Here are a couple of ways to do that, and someone may very well have a better one. One way would be to simply add another layer of index/match like so:
    Please Login or Register  to view this content.
    A second way is to use the Sumproduct function like so:
    Please Login or Register  to view this content.
    You could paste either in G1 and down.
    Let me know if you have any questions.

  8. #8
    Registered User
    Join Date
    02-18-2016
    Location
    usa
    MS-Off Ver
    2013
    Posts
    24

    Re: How can I match Names to Numbers?

    very wonderful. thank you

+ 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. Match Names of Reservations Secured with Names of General Inquiries
    By hardwareblues in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-18-2014, 11:39 PM
  2. [SOLVED] Match names on one spreadsheet to the names on another then copy contents of another cell
    By TYOsborn in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-14-2013, 05:06 PM
  3. [SOLVED] Match names and sum the 2 values from matched names
    By score in forum Excel General
    Replies: 3
    Last Post: 09-11-2012, 01:12 AM
  4. Replies: 6
    Last Post: 04-21-2011, 03:49 PM
  5. Match numbers to names and extract totals
    By c7borg in forum Excel General
    Replies: 4
    Last Post: 01-19-2010, 12:15 PM
  6. [SOLVED] sorting names alphabetically when names may start with numbers
    By John Smith in forum Excel General
    Replies: 3
    Last Post: 05-11-2005, 04:06 PM
  7. [SOLVED] Changing VB Component Names to match Worksheet names using VBE
    By Philip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-12-2005, 01:06 PM

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