Hi gurus,
I am really little confused on this scripting dictionary.
I had a merely 10k rows on my original file but I only attached a sample file.
Can anyone help me on how to get the result like on the attached file using scripting dictionary or it can be done on more easier way?
I want to find the unique name and count of unique date per name.
Thanks in advance,
thisisgerald
Don't forget to mark your thread as [SOLVED].
Pivot Table does faster and easier than dictionary.
@AB33
When I tried to create a pivot table, it count all the dates not only the unique date per name.
Is there a way to make it unique count on pivot table without filtering the unique value first?
Thanks,
thisisgerald
Soory! Not I know
Based on your example file:
Let me know if you have any questions.
Please Login or Register to view this content.
abousetta
Please consider:
Thanking those who helped you. Click the star icon in the lower left part of the contributor's post and add Reputation.
Cleaning up when you're done. Mark your thread [SOLVED] if you received your answer.
Maybe like this?
abousetta! The pipe separator is still on cells
If the pipes are in column F then
should be spreading the date over columns F:G.Please Login or Register to view this content.
abousetta
abousetta,
The number of unique days are also wrong. Your code counts the number of days in collumn "C" for every key, but the OP wishes unique dates only
An updated version that checks unique names, ids and dates from columns A:C and outputs to columns F:I
abousettaPlease Login or Register to view this content.
P.S. @AB33, if you don't know the answer then maybe leave this between the OP and person helping.
No, Why should I? You can simply ignore my question (Post) if you do not want to answer it.
breathe in, hold, breathe out, relax
let's all get along please. all contributions are welcome-including observations of issues with suggested code (as long as they are well presented, as here)
Josie
if at first you don't succeed try doing it the way your wife told you to
Jay,
My post and comment were not intending to question abousetta's ability or skill, it is just purely to learn from his code and had not other motives. I have only highlighed the code is not working as per OP's request.
I know-I did not criticize your posts [other than that last one ;-)]
We all make mistakes, and I will be the first to admit that I make more mistakes than most. That's how we learn. I have no problem having my mistakes pointed out to me. In the end, it's all about presentation. If I feel that I am being attacked then obviously I will fight back, else I will be happy to correct the mistake even if it's really just a misunderstanding rather than a true mistake.
@kyle
Thanks for the suggestion. I'm planning not to add other column to my raw data.
@abousetta
Thanks for the effort. However, it does not fit what I'm looking for.
I'm just gonna loop all the records to find the count of unique dates per name. :D
Sorry about what just happened here.
Warm Regards,
thisisgerald
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks