Thanks for the tips Bill... I've solved it now. The formula looks like
this:

=IF(COUNT(C6:H6)<2,"",LEFT(INDEX($C$1:$H$1,MATCH(0 ,C6:H6,0)))&LEFT(INDEX($C$1:$H$1,MATCH(0,C6:H6,1)) ))

The key for me was useing & in functions. I had never done that before.

Lorne

Lorne Oliver wrote:
Thanks Biff

I adjusted the ranges to fit the actual ones used but I end up with
#N/A error in the MIN() if I am reading the step-by-step calculation
correctly. I think I see what you are doing here though and that has
given me some ideas to work with. I could simplify things by just using
the initials in the header row anyway.

The actual table looks like this:
Games Rodney Welles Scott Mina Barry Lorne
Singles 3 1 2 0
Wk 1 Dbl -01 0 0
Dbl Cr 0 0
Singles
Wk 2 Dbl -01
Dbl Cr
Despite obvious references to how badly I play darts, does this help
with clearing up the errors?

Data ranges from C2:H4 for one week with the names in C1:H1. The first
row of data for each week is not relevant to this problem, only the
second and third rows for each week.

Biff wrote:
Hi!

ex: Rodney Welles Scott Mina Barry Lorne
DBL -01 1 1
DBL -Cr 3 3

Assume that table is in the range A1:G3. Names are in B1:G1

Enter this formula in H2 and copy down as needed:

=IF(COUNT(B2:G2)<2,"",LEFT(INDEX(B$1:G$1,MATCH(MIN (B2:G2),B2:G2,0)))&LEFT(LOOKUP(4,B2:G2,B$1:G$1)))

Biff

"Lorne Oliver" wrote in message
ps.com...
I am trying to collect data from a darts team and these values reflect
the number of points won in a team game (ranging from 0 - 3). This will
probably be simple for the experts here, so I'll let fly:

I have a table with six names across the top. In the rows below there
will always be two cells that have number values ranging from 0 - 3
while the rest will be blank. Those two numbers however, will always be
the same. I am trying to write a formula that will determine which
columns have values and return a single letter value (first initial)
for each name. Since all the names are different that is not an issue.

ex: Rodney Welles Scott Mina Barry Lorne
DBL -01 1 1
DBL -Cr 3 3

The intended results for the first row would be "WS" and "RM" for the
second row. I have been trying IF() constructions but am now stymied.