View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Number_Cruncher Number_Cruncher is offline
external usenet poster
 
Posts: 1
Default Extracting first value of each month

Hello,

How do you extract the first value (plus the date) of each month out of
a series?

Example
2/4/05 data
2/12/05 data
2/13/05 data
3/1/05 data
3/2/05 data
etc


In this sample I only want to pull:
2/4/05 data
3/1/05 data

In reality I have a large dataset I am working with (15 years with
weekly entries). I just want to pull the first value (and date) of each
month.


Thanks in advance for any help.

Al