Identify occurences that occur after a date but not before

P

peteali.minto

Hi,
I was hopiong somebody could help me with a formula that would identify anyoccurences that happen after a particular date but not before. I.e. I havea column of values (say product orders) that occur accross dates. Bearing in mind that more than one order can occur on a particular date (so a particular date may appear more than once the date column). Also more than one product of the same kind can be ordered on the same date (therefore more than one instance of the same product may appear on the same date and also on different dates.

I want to identify what products were ordered after a particular date but not before.

As an example I will use the table below

Order Product Date

Balloons 01/01/2013
Cards 01/01/2013
Balloons 01/01/2013
Balloons 02/01/2013
Cards 03/01/2013
Balloons 03/01/2013
Streamers 03/01/2013

In this example I want to identify what products were ordered on or after 03/01/2013 but not before. In this example my expected result would return Streamers as a text string.

Would appreciate any help with this.

Regards

Pete
 
C

Claus Busch

Hi Pete,

Am Wed, 10 Apr 2013 23:00:10 -0700 (PDT) schrieb
(e-mail address removed):
Order Product Date

Balloons 01/01/2013
Cards 01/01/2013
Balloons 01/01/2013
Balloons 02/01/2013
Cards 03/01/2013
Balloons 03/01/2013
Streamers 03/01/2013

In this example I want to identify what products were ordered on or after 03/01/2013 but not before. In this example my expected result would return Streamers as a text string.

what about Cards and Balloons? IMO the result has to be:
Cards
Balloons
Streamers
try:
=INDEX($A$2:$A$100,SMALL(IF(B$2:B$100>=DATE(2013,1,3),ROW($1:$99)),ROW(A1)))
enter this array formula with CTRL+Shift+Enter and copy down till you
get an error


Regards
Claus Busch
 

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

Top