Help with Formula Please

  • Thread starter Thread starter Corca
  • Start date Start date
C

Corca

Need a Formula for the following:

Data Table
A B C D E F G H I
1 Tom A W 2 H 30 84 30
2 Peter A W 3 H
3 Nick B L 1 A 70

Columns F1:I3 from Data Table has break scores for each player.

Below is the Result Table where I need to show a summary report for high
breaks. I have no problem with Break as I use the Large function. I need a
formula to insert in A1 and A2 to place the name for the corresponding breaks
below.

Result Table
High Breaks
A B
Name Break
1 84
2 70

Appreciate the help.
 
Corca,

You need to post this as a new message. When you add it to a thread that's a
month old, you won't get many viewers.

Regards,
Fred
 
Don't now how to search for the previous post as it dont have search critira
for name or date etc... only subject.

Can you help please.
 
Thanks for pointing that out, David. I'm using Windows Mail, rather than OE,
but it's not surprising the problems are the same. I'll know from now on
that it's WM screwing up the threads, not the OP.

Fred
 
Back
Top