extracting data

  • Thread starter Thread starter Darius
  • Start date Start date
D

Darius

hi there;
my first question here, I have set of data with columns like:

Date myValue requestValue
1-jan-1800 100
..
..
..
31-Dec-2000 17

what I need is coping the data in B column if the date in A column is
from 1st of Apr untill 31 of Oct. In fact I want to extract all data
in column b across all years (each year from 1st of Apr to 31st of
Oct).
I tried some If stuff but failed after a lot of time, can anybody
please help.
Best
Darius
 
Darius said:
hi there;
my first question here, I have set of data with columns like:

Date myValue requestValue
1-jan-1800 100
.
.
.
31-Dec-2000 17

what I need is coping the data in B column if the date in A column is
from 1st of Apr untill 31 of Oct. In fact I want to extract all data
in column b across all years (each year from 1st of Apr to 31st of
Oct).
I tried some If stuff but failed after a lot of time, can anybody
please help.
Best
Darius
Click to expand...

Do you have real dates in column A, or just text that looks like dates? I
ask because your example starts in 1800, whereas Excel dates start in 1900.

Assuming you do have real dates, do I understand correctly that you want to
copy data from column B to column C in months from April to October? If so,
use this formula in C1 and copy down as far as required:
=IF(AND(MONTH(A1)>3,MONTH(A1)<11),B1,"")
 
Back
Top