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