terrydennis
Member
I have produced an Excel Workbook which has various macros within it – developed with the help of people on this superb website. However , I have noticed a quirk which I cannot understand and therefore cannot correct ! HELP PLEASE !
The workbook is a leaderboard system for my golfclub which has impressed everyone !
A filtered list of information is generated in a hidden worksheet and the data list is transferred (still under the control of the same macro) to another specific worksheet called “Div 1” into which peoples scores are added manually during the course of the competition.
There are a maximum of 70 records of name/golf club name/handicap/score. A leaderboard worksheet (used for TV screen display) accesses “Div 1” to display the information contained therein.
One expression which is used within the Leaderboard is a count of the number of Entrants in the competition and used the expression
COUNTIF(‘Div1’!B7:B76,”*”)
Which counts the number of separate sequences of characters. My question is this.
The value returned in my Leaderboard from this expression is 61 whereas the actual number that I see in the worksheet “Div1” is 36. If I manually delete the apparently blank cells from B43 to B61 , I get the correct answer !! WHY ? Can there be something in the apparently blank cells which is being seen as characters by the COUNTIF expression and how did it get there ?
Strangely , I have two more worksheets within the workbook , “Div2” and “Div3” , also containing lists of people , clubs and handicaps , produced by similar worded macros which always give the correct answer !
I am perplexed ! Your help would be appreciated and I can forward the Workbook to you if it would help.
Regards
Terry Dennis
The workbook is a leaderboard system for my golfclub which has impressed everyone !
A filtered list of information is generated in a hidden worksheet and the data list is transferred (still under the control of the same macro) to another specific worksheet called “Div 1” into which peoples scores are added manually during the course of the competition.
There are a maximum of 70 records of name/golf club name/handicap/score. A leaderboard worksheet (used for TV screen display) accesses “Div 1” to display the information contained therein.
One expression which is used within the Leaderboard is a count of the number of Entrants in the competition and used the expression
COUNTIF(‘Div1’!B7:B76,”*”)
Which counts the number of separate sequences of characters. My question is this.
The value returned in my Leaderboard from this expression is 61 whereas the actual number that I see in the worksheet “Div1” is 36. If I manually delete the apparently blank cells from B43 to B61 , I get the correct answer !! WHY ? Can there be something in the apparently blank cells which is being seen as characters by the COUNTIF expression and how did it get there ?
Strangely , I have two more worksheets within the workbook , “Div2” and “Div3” , also containing lists of people , clubs and handicaps , produced by similar worded macros which always give the correct answer !
I am perplexed ! Your help would be appreciated and I can forward the Workbook to you if it would help.
Regards
Terry Dennis