Golf Handicap question

[Don]

I posted this under a different heading, but am posting it under the Golf
Handicap in hopes of finding someone who has a spreadsheet that will
calculate Handicaps.

I wrote a spreadsheet in Quattro Pro X3 to calculate Golf Handicaps. I have
imported it to Excel 2007 but I can't get one formula to work. The formulas
for calculating Index, Differential and Handicap work fine but the formula
to find the loewst 10 scores from the last 20 rounds played doesn't work.
In the spreadsheet I have calculated the differentials in column 'H'
starting at row 6 and am trying to put the lowest 10 scores from the last 20
played in
Column 'J6 thru J15'.

The following Quattro Pro formula is what is used in columns J6 thru J15.

@IF(A:F@PURECOUNT(A:H)<@ROWS(H$6..H6),"-",@SMALLEST(@@(@OFFSET(H$6,@MAX(0,@PURECOUNT(A:H)-20),0,20,1)),@ROWS(H$6..H6)))

It works fine in QP but when I imported this to Excel, it came out as:

=IF(COUNT(H$1:H$16960)<ROWS(H$6:H6),"-",SMALL(INDIRECT(OFFSET(H$6,MAX(0,COUNT(H$1:H$16960)-20),0,20,1)),ROWS(H$6:H6)))

When I import the Quattro Pro spreadsheet to Excel I get errors in H6-H15
"#VALUE!" and in the "I" column it says:

"A value used in the formula is of the wrong data type."

I am brand new to Excel and have modified the =IF statement several times
without success. The references to H$1 were changed to H$6 because labels
are above H6, but I am stumped. Have I given enough information for anyone
to help me?

Thanks

 

[Don]

Thank you Biff. That worked perfect after I changed the column from A to H.
I extended it down to about H350. I guess I could extend it to any value,
but realistically I'll keep it arount 350 for now. Thanks for the array.

Don D.

 

[T. Valko]

You're welcome. Thanks for the feedback!

 

[MJ]

Would it be possible for you to send me your handicap formula? i have been
fighting Excel trying to get one to work. Thanks in advance if you are able.

 

[Gord Dibben]

MJ

Browse through this 'net search

http://www.alltheweb.com/search?cat=web&cs=utf8&q=excel+golf+handicaps&rys=0&itag=crv&_sb_lang=pref


Gord Dibben MS Excel MVP

 

[Don]

MJ, I can send you my version of the golf handicap. Where do you want me to
send it to?

Don D.

 

[MJ]

If you can send it to my email address I would appreciate it. (e-mail address removed)

Thanks in advance for sharing...

 

[Gord Dibben]

By entering your real email address in these news groups you have ensured
you will be getting lots of email from now on.

The email-bots have now got it.

Hope you need Viagra<g>


Gord Dibben MS Excel MVP

 

[Charles]

Hello,

I noticed your posting. Does it preform the Callaway Hanicapping System?

If so, is there any chance I could get a copy of it to help out with a annual friends and family golf get together.

Thanks in advance.
Charles