+ Reply to Thread
Results 1 to 7 of 7

Text & numerical linking?

  1. #1
    Registered User
    Join Date
    07-15-2016
    Location
    Montreal, Canada
    MS-Off Ver
    2010
    Posts
    5

    Text & numerical linking?

    Hello folks! I have just come back to Excel after years of not using it! I have made some great progress but am a little stumped with my latest project and wouldn't mind some pointers.

    I will simplify this as much as possible: I have 2 sheets in particular in the same workbook. On one is a list of competitors, their teams, and the points they have earned.

    On the second I would like to tally up the team points form that first sheet.

    How do I go about identifying the team/competitors and link the individual points onto the tally sheet (sheet #2)?

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166
    Hello Faedynn,

    Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Registered User
    Join Date
    07-15-2016
    Location
    Montreal, Canada
    MS-Off Ver
    2010
    Posts
    5

    Re: Text & numerical linking?

    Thank you!

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,607

    Re: Text & numerical linking?

    As you may noticed - this is just "say hallo" forum. Real discussion goes on standard forums, so if your question is still open - post it in one or regular forums.
    May be: http://www.excelforum.com/excel-formulas-and-functions/

    Friendly advice:
    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
    Remember to desensitize the data.
    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
    Best Regards,

    Kaper

  5. #5
    Registered User
    Join Date
    07-15-2016
    Location
    Montreal, Canada
    MS-Off Ver
    2010
    Posts
    5

    Re: Text & numerical linking?

    Lol! Thank you! My bad.

    I will make a little mock up and post it in a bit.

  6. #6
    Registered User
    Join Date
    07-15-2016
    Location
    Montreal, Canada
    MS-Off Ver
    2010
    Posts
    5

    Re: Text & numerical linking?

    Sorry, when you say click on Go Advanced, where exactly is this? I was trying to post but couldn't attach my document or find the Go Advanced.

  7. #7
    Registered User
    Join Date
    07-15-2016
    Location
    Montreal, Canada
    MS-Off Ver
    2010
    Posts
    5

    Re: Text & numerical linking?

    Lol, I found the go advanced button. Please ignore and thank you once again!

+ 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. Linking two seperate date columns to a numerical value
    By mhm1996 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-09-2016, 10:47 PM
  2. Numerical value into text
    By aqlaql in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-06-2015, 08:09 PM
  3. [SOLVED] Linking two formulas for text conversions to numerical expressions
    By wraithu in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-26-2014, 03:56 PM
  4. [SOLVED] Linking numerical value occurrence to a date
    By b_rianv in forum Excel General
    Replies: 47
    Last Post: 07-23-2014, 09:38 PM
  5. Linking numerical values to text?
    By Johnrciveng in forum Excel General
    Replies: 2
    Last Post: 06-12-2012, 12:20 PM
  6. Text to Numerical Value
    By peteuga in forum Excel General
    Replies: 2
    Last Post: 01-26-2011, 04:22 PM
  7. Numerical Value to text
    By no0dles in forum Excel - New Users/Basics
    Replies: 7
    Last Post: 04-25-2006, 10:30 AM

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