Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do i find the first value every month
I have a table with a new value every hour:
Date Time Value 2005-01-01 00:00:00 1 2005-01-01 01:00:01 4 .. . . .. . . .. . . 2005-01-02 00:00:00 34 .. . . .. . . 2005-02-01 00:00:00 145 etc.. The only rows i need from this table is the first value every month (date, time and value), but I how do I do? (timestamp can differ a couple of seconds every our) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
function to fill all days of month to end of month | Excel Worksheet Functions | |||
Generating a blank worksheet at the start of the month | New Users to Excel | |||
UserForm to select current month or earlier | Excel Discussion (Misc queries) | |||
How to extract month number from month name | Excel Discussion (Misc queries) | |||
PivotTable - Count by Month | Excel Worksheet Functions |