Hi
I have a data download which contains text I need to strip out certain information (the date) and then count the entries
e.g. 2017-04-03 10:09:59
Here I would need this identified as 3rd July
Can anyone help please?
In the example the formula would be in the yellow cells
Can a Mod move this post for me please
An array formula, in D6, copied down..
=SUM(IF(INT(D2:D6+0)=G2,1,0))
Do you really have 54 days in April in England??? (D6)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Some months it feels like that! I spotted it after posting and I couldnt correct it without it changing the formating
Thanks Glenn - that worked!
November through February feel like that to me...
You're welcome.
If that takes care of your original question, please select "Thread Tools" from the menu link above and mark this thread as SOLVED.
It'd also be appreciated if you were to click the Add Reputation button at the foot of any of the posts of all members who helped you reach a solution.
To be fair Glenn is in Northern Ireland: they tend to do things differently than here on the mainlandOriginally Posted by Glenn Kennedy
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
You may also need a formula to get unique dates list.
Enter in G2 and copy down
Formula:
Please Login or Register to view this content.
then enter in H2 and copy down
Formula:Please Login or Register to view this content.
v A B C D E F G H 1 order_id site_id order_code order_date 2 3 1 118239 4/3/2017 10:09 3-Apr 2 3 4 1 118243 4/3/2017 12:05 4-Apr 2 4 5 1 118271 4/4/2017 6:38 5-Apr 1 5 6 1 118293 4/4/2017 14:10 6 7 1 118315 4/5/2017 6:38
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
Please don't mention the DUP. Like really... please don't mention them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks