Hi and thank you for taking the time to help me with this problem. Attached is a spreadsheet with values contained in it.
We have in column B the date time values at 30min intervals ie 11/12/2013 16:30:00, 11/12/2013 16:00:00, 11/12/2013 15:30:00 etc
We have in column C the value for each 30min time is there ie 6507, 6517, 6531 etc
In column E i would like the 16:30 value for each day
Hope you can help
Thank you
One way: E2:and copy down.Formula:
Please Login or Register to view this content.
Filter on non blank column E
Regards, TMSHTML Code:
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
Using your posted workbook...Maybe this approach
F1: TimeTest...(or any text that is not a column heading from your data)
F2: =MOD(B2,1)=--"16:30:00"
H1: Intraday_Date
I1: Bar Time
J1: Value
• Select A1:C4376
• Data.Advanced_Filter
...Check: Copy to another loca5tion
...List range: $A$1:$C$4376
...Criteria range: $F$1:$F2
...Copy to: $H$1:$J$1
...Click: OK
The matching records will list under $H$1:$J$1
Alternatively, you could just use E1 as the Copy to range
E1: Value
and only the values will list
Is that something you can work with?
Thank you very much
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks