I'm looking for a formula to retrieve the names....
Can anybody help?? e.g. If(Col B="M',Large(Day1,1),"") or similar...
Thanks
Klaus

"Biff" wrote in message
...
Ok.

Now, there are a couple of ways to do this:

1. use conditional formatting to highlight the applicable scores
2. make a list of the best and second best players

#1 is the easiest. #2 will take some time (depending on how many players
typically "tie" and trying to setup a nice method for display)

Biff

"Klaus" wrote in message
...
If possible...yes! Thanks for reply
Klaus


"Biff" wrote in message
...
Hi!

What about the possibility of ties?

Do you want them included?

Biff

"Klaus" wrote in message
...
I do have a Golf Table. Listed in columns are Members (Col A); Sex (Col
B); Results in Day1....Day 5 in Col C...G. I'd like to find the best and
second best man and woman for each day. How can I accomplish this???
Thanks for the reply
Klaus