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) |
#2
|
|||
|
|||
Use VLOOKUP()
Your data looks like it is sorted by date and time already. VLOOKUP will find the very first record of any date (in your case, the first day of each month) -- Gary's Student "pex" wrote: 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) |
Reply |
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 |