Re: Finding two records in a row then return the result.

From: CLR (croberts_at_tampabay.rr.com)
Date: 07/11/04 

Date: Sun, 11 Jul 2004 12:03:02 -0400

Hi Mike.........

Concatenate your team names in a helper column separated by a dot (.), then
use AutoFilter > Custom and filter for equals MyTeam.* OR *.MyTeam..........

Vaya con Dios,
Chuck, CABGx3

<Mike> wrote in message news:9052f0dhg81afjcj99olbgmr3aa4h3b88c@4ax.com...
> I am stuck for a solution to this problem that has been annoying me
> for a while. I have a football spreadsheet in which sheet1 which has
> all fixture list and results. I want the results for a each team to be
> to on their own ***.
> The layout is Column E is the home team, Column F home team score
> column G away team and column H away team score. This layout is for
> both sheets.
> In Sheet1 we have in row2
> E F G H
> R2 Team A - Team A - Score - Team C - Team C score
> R3 Team B - Team B - Score - Team G - Team G score
> etc to Row 382
>
> In *** 2 I want a a formula that will pick out all the rows that
> contain the anything with Team A either in column E or column G.