Hi,
I have tired for a few days but unable to work it out -
the amount of times CarandRoad appears between
29/06/2010 - 31/06/2010 = 359
when i use the date
29/06/2010 - 04/06/2010 = 339 it should still be 359
Could anyone explain why this is happening and what i'm doing wrong.
Regards
Nurofen
Looking at the individual results, they seem to be correct.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
The one you mark as incorrect looks fine to me, I pivotted the data and got that answer, but the other seems to be counting 5 too many, the five in July 2010.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
i'm going to re-check the data and i'll post back
Your problem is that June 31st does not exist and is treated as text by XL
Exactly, but the OP thinks that one is correct and the other is not!Originally Posted by arthurbr
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
all,
I can see where i went wrong thanks for your help.
Posting Permissions
Reply With Quote
