Hi Pete,
Just follow the following steps hope this will work for you.
i pasted the data in A1 to B7 as
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
then in G2 i paste any date on which you want your data.
then in F6, I wrote this formula.
enter this formula with *ctrl+shift+enter*
=TRANSPOSE(INDEX($A$1:$B$7,SMALL(IF($B$1:$B$7>=$G$2,(ROW($B$1:$B$7)-MIN(ROW($B$1:$B$7))+1),""),ROW(A1)),1))
regards
Prince
On Friday, April 12, 2013 5:25:14 AM UTC+5:30, Minties wrote:
>
> 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
>
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups "MS
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
