Identify occurences that occur after a date but not before

  • Thread starter Thread starter peteali.minto
  • Start date Start date
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
 
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.
Click to expand...

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
 
Back
Top