LinkBack URL
About LinkBacks
Hello All,
Please help me solve my problem, I have the attached worksheet, I want to copy all the highlighted time ending in (02).
Examples are:
8/21/2018 12:02:00 PM
8/21/2018 1:02:00 PM
Thank you so much
Hello All,
Please help me solve my problem, I have the attached worksheet, I want to copy all the highlighted time ending in (02).
Examples are:
8/21/2018 12:02:00 PM
8/21/2018 1:02:00 PM
Thank you so much
Use this formula in cell G6 and fill down
Formula:
Please Login or Register to view this content.
It will flag all the rows where the Minutes are 02
You can sort by column G to get your selected group.
You can use a macro to extract the data if you want.
Please Login or Register to view this content.
Last edited by mehmetcik; 08-30-2018 at 06:05 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
Hello mehmetcik,
Thank you for the reply, sorry for not making myself clear. what I want is copy the whole row or the readings.
Thank you
Run the macro
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks