1 Reply Latest reply: Dec 11, 2012 8:39 AM by Damian Parodi RSS

    Help with columns with same data

      I have an excel with a huge database of soccer games. The columns are: "date", "stadium", "local_team", "local_score", "away_score", "away_team".

       

       

      The problem is that I can't create a list box or a search engine to work within the columns "local_team" and "away team" as they are two separate columns that contain the same data. Each row is a game and sometimes the team in the column "local_team" apperas too in the column"away_team".

       

       

      The goal will beto choose the "team x" from a list and  show me  the team in both columns "home_team" and "away_team".

       

       

       

      thanks