if-statement

[Max_power]

Hello,

I'm trying to do a VLOOKUP that incorporates dates in the lookup. Is
that possibble. I've got dates like
from
1/4/04 to 1/5/04
1/5/04 to 1/6/04
etc......
I want to do an if statement or a lookup that allows to only select
dates that are greater than a certain date. Is this possible?
So if certain products or whatever hasn't been active in say a period
of 3 months to not count them.

Many thanks for any input

Max

 

[Bob Phillips]

You could use a simple countif

=COUNTIF(A1:A101,">="&B1-30)-COUNTIF(A1:A101,">"&B1)

will count all dates in column A that are 30 days or less previous to a date
in B1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

 

[Max_power]

Many many thanks for your reply. It's not quite what I was looking for
I'll try and become more clear in my intentions.
I've got a pivot table with a lot of data and there are certain item
in the pivot table say that have been inactive over a period of time
So say I have months like
jan - a b c d
feb- b c d e
mar - b c d e
Apr - b c d e
May - b c d e
......
Note that "a" hasn't occured in over 4 months so is there a formula o
something I can use to discard that piece of information from m
worksheet. Also note that I will have multiple instances of this kin
of action so a robust formula will be needed.

Thanks for any help or ideas

Ma

 

[robert111]

you could put an extra column in your spreadsheet which tests the dat
and returns "ignore" or "use"

then just put that criteria in the top left box in the pivot tabl
layout and set it to "use"

You will then only analyse the required dat