Hi, I have got this spreadsheet and to the right I have used the "CountIF" function. The very first function on "Monday Week 1" fails to count the correct number. It returns 26, while it should be 27. Any idea why?Assets New.xlsx
Hi, I have got this spreadsheet and to the right I have used the "CountIF" function. The very first function on "Monday Week 1" fails to count the correct number. It returns 26, while it should be 27. Any idea why?Assets New.xlsx
Monday Week 1 in row 294 has extra space. Remove it and it will work.
Hi,
The last one on row 294 has a trailing space.
I can't help thinking that if you're working with dates you'd be better off listing actual dates. They can always be formulated to present as you wish but they would be more useful for all sorts of analysis.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
The entry in cell C294 has a trailing space.
Either fix it, and any others, or useFormula:Please Login or Register to view this content.
Regards, TMS
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Hi again,
Thanks very much for pointing me the problem. I spent about 3 hours trying to find the culprit to the problem.
How did you find the so called trailing space in row 294? Is there a command that makes spaces visible?
Does anybody know a variation of "CountIF" with a value that can single out "Monday Week 1" even if there is an additional text or spaces?
Regards
Last edited by kashbg; 06-01-2015 at 05:14 PM.
I've given you oneDoes anybody know a variation of "CountIF" with a value that can single out "Monday Week 1" even if there is an additional text or spaces?
I put =LEN(C2) in a spare column and copied it down. I then switched on AutoFilter and filtered on Monday Week 1. Most were length 13, one was 14. Bingo! Then you select the cell and press F2 to go into Edit mode to see what's in the cell.
Regards, TMS
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save
You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
Last edited by TMS; 06-01-2015 at 05:30 PM.
Thanks a lot for the help.
I am overwhelmed by the level of attention and professionalism.
Thanks guys.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks