You could create a pivot table, based on your home table, to summarize
the data. There are instructions and links he

http://www.contextures.com/xlPivot01.html

When you create the pivot table, put team name in the row area, Win/Lose
in the Column area, and another copy of team name in the data area,
where it will show as Count of Team.


kreatiff wrote:
Ok - I'm at that pulling out hair stage and I haven't got that much
left!

I'm using the formula below to determine whether a team has Won Drawn
or Lost a match based upon the result.

=IF($F4="","",(IF($F4<$C4,"W",(IF($F4$C4,"L",(IF( $F4=$C4,"D","")))))))

The result of the formula is either, W, D, or L.

I have created a small table that incorporates a list of the teams on
the left and three additional columns with a heading W, D, L
respectively. Using VLOOKUP add the following formula alongside each
team under the appropriate heading as below:

=VLOOKUP(H4,home,2)

H4 = Team name
Table array = home
Number of columns to move right = 2

This gives a result of #N/A.

What I want it to do is simply add the number of instances the club
name appears in my table array and count or add the number W, D, L it
sees.

Driving me nuts at the moment - so any pointers appreciated.

Many thanks in advance

J




--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html