Finding two records in a row then return the result.

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mike (no email)
Date: 07/11/04 

Date: Sun, 11 Jul 2004 13:48:08 +0100

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.

Quantcast