I think the output would containd three values Cards, Ballons, Streamers and for this output below is the formula. Confirm it with CSE
* =IFERROR(INDEX($A$1:$A$8,SMALL(IF(((VALUE($B$2:$B$8)>=VALUE($D$1))*ROW($A$2:$A$8))=0,"",((VALUE($B$2:$B$8)>=VALUE($D$1))*ROW($A$2:$A$8))),ROW($A$1:$A$8))),"") * On Friday, 12 April 2013 05:25:14 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.
