Finding two records in a row then return the result.

M

Mike

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 sheet.
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 sheet 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.
 
C

CLR

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Lookup multiple cell values and place contents in a single cell 3
Calculate points for and points against 3
Need help with a function for a golf match spreadsheet 1
sorting scores 2
Matching data in two columns 18
Countif until a number occurs four times in a row then return that number 3
sum a set of cells based on comparing a different set of cells 3
collating game scores 4

Top