View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default OK Golf lovers, a little help here

And don't forget the dreaded "other"

Gord

On Tue, 11 May 2004 07:08:23 +0100, "Nigel"
wrote:

What about Eagles and Albatross - you never know!!

"Moveit.com " wrote in message
...
Hi -I maintain stats for a golf league in the midwest. I am looking for
a little help with a formula to automatically calculate how many
birdies/pars/bogeys in a round for people.

I will enter the hole numbers in, say A2-A10, Par for each hole on
B2-B10, then for the 100 members -their scores on each hole (each week)
-in C2:C10, D2:D10 etc...

I have been banging my head for quite a while trying to find a way to
create a Birdy, Par and Bogey column that will automatically calculate
how many of each that player had that round.

Thanks for any help, it is much appreciated!!!!! I'm happy to find
this board!

Chad


---
Message posted from http://www.ExcelForum.com/