+ Reply to Thread
Results 1 to 2 of 2

Create Columns Comparing differences in Other Columns

  1. #1
    Registered User
    Join Date
    08-02-2015
    Location
    Pasadena, CA
    MS-Off Ver
    Version 14
    Posts
    1

    Talking Create Columns Comparing differences in Other Columns

    Hi Everyone,

    I'm trying to get ahead in my fantasy football league this year and need your help!

    I'd like to find the difference between players in two fantasy football ranking lists so I can easily see how differently one player is ranked in one list or another. See attached for what i'm looking for - in columns I thru L. I put the info in manually, but hoping someone can help me with a formula that would create that info.

    Thank you in advance for your help!

    Matt
    Attached Files Attached Files
    Last edited by mvannucci; 08-02-2015 at 06:51 PM.

  2. #2
    Forum Expert Greg M's Avatar
    Join Date
    08-16-2007
    Location
    Dublin. Ireland
    MS-Off Ver
    Office 2016
    Posts
    4,467

    Re: Create Columns Comparing differences in Other Columns

    Hi there,

    It's not going to be easy to do this while your data are in their current format!

    The "space" character you're using between the names in Column B is not the same as the "space" character you're using in Column E. They both look the same on the screen but if you insert the following formula (Antonio Brown) in any cell:

    Please Login or Register  to view this content.
    the result will be FALSE. If you delete the Space character in Cell B3 and retype it as a "normal" space (i.e. using the SpaceBar) the formula will evaluate to TRUE.

    I've checked the above situation for a few player names and all of them seem to show the same problem.

    If you can ensure that the space characters used in Columns B and E are consistent, there might be some chance of achieving what you want using LOOKUP and MATCH formulas.

    Hope this helps - please let me know how you get on.

    Regards,

    Greg M

+ 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. Replies: 1
    Last Post: 02-08-2014, 04:34 PM
  2. Replies: 0
    Last Post: 05-10-2013, 03:41 AM
  3. Comparing 2 WB's with identical rows and columns, then Hightlight the differences
    By crispybadger in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-13-2013, 05:17 PM
  4. Comparing differences between two columns
    By MI_Analyst in forum Excel General
    Replies: 1
    Last Post: 11-02-2010, 06:51 AM
  5. Comparing columns and highlighting differences
    By Sejrup in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-01-2010, 09:24 AM
  6. Comparing Two columns to create column with duplicates
    By braves1t in forum Excel General
    Replies: 6
    Last Post: 04-29-2010, 08:31 AM
  7. Quick method of comparing two columns and highlight differences
    By PRodgers4284 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-04-2010, 11:03 AM

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