+ Reply to Thread
Results 1 to 3 of 3

For me this is a conundrum, same formula two data sources, and one not working

  1. #1
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    169

    For me this is a conundrum, same formula two data sources, and one not working

    Hi ...

    I hope somebody would help me out here.

    I ran the same formula getting data from two different tables which I downloaded from the net, and only one of them worked.
    In the sheet “In a Row” I have tried to find the soccer team with two straight victories in the two last matches.
    Why does it work with the data query from www.football-data.co.uk and not with the one from fbref.com?
    I must admit that the table from FBref did not contain a column called FTR, so I made one in Power Query. Is that the culprit?

    in advance thanks a lot.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,094

    Re: For me this is a conundrum, same formula two data sources, and one not working

    It is because the 2nd sheet contains matches yet to be played.

    Amend column J to:

    =IF(SUMPRODUCT((Tabell_1[Column4]=A5)*(ROW(Tabell_1[Column4])*(Tabell_1[FTR]="H")=LARGE((Tabell_1[Column4]=A5)*(Tabell_1[FTR]<>"")*ROW(Tabell_1[Column4]),{1,2})))>1,"OBS!","")

    This throws up (at least) one other issue.

    Manchester City (results sheet) does not match "Man City" in sheet E0. If they don't match, they won't be found. Find/Replace... perhaps? Other tems my be affected, too.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: Lá fhéile Pádraig sona dhaoibh

  3. #3
    Forum Contributor
    Join Date
    08-30-2015
    Location
    Tresfjord, Norway
    MS-Off Ver
    365
    Posts
    169

    Re: For me this is a conundrum, same formula two data sources, and one not working

    Thank you, for having a keener eye than mine.
    Your suggestion worked perfectly.

+ 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. Help me solve this formula conundrum
    By cjr88 in forum Excel General
    Replies: 1
    Last Post: 06-07-2023, 10:14 AM
  2. [SOLVED] Conditional Formatting Conundrum using a formula
    By green_aardvard in forum Excel General
    Replies: 5
    Last Post: 11-25-2020, 02:48 PM
  3. countif formula with two data sources
    By beckyboo1986 in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 11-05-2019, 12:33 PM
  4. [SOLVED] Working with big data sources in Excel - approaches
    By jaryszek in forum Excel General
    Replies: 10
    Last Post: 10-08-2019, 04:44 AM
  5. [SOLVED] SUM Formula Conundrum
    By FreeBSD in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-28-2015, 05:09 PM
  6. [SOLVED] Formula required to link a tickbox to 2 data sources
    By G920 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-01-2014, 06:16 AM
  7. excel formula conundrum
    By ianfew in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2008, 05:08 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