How do i find the first value every month

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Finding the Max, Min values based on certain criteria for an array 13
Lookup between dates 1
Data translation 4
Date / Time Filter 2
How to convert half hourly data into hourly 5
Run a Macro at a certain time 2
Excel 2002 : Anway to paste without time values ? 3
Deleting Rows of Data 3

Back
Top