Show next 10 future events based on todays date | duplicates issue

[Jon1781]

Hi all,

I've been wrangling with a problem all day and am hoping someone can help put me out of my misery. I have a dataset of tasks and their start dates (the actual dataset is much larger than the example) and I want to display the next 10 upcoming tasks in the future based on todays date. I've used a comination of INDEX, MATCH, SMALL and IF to produce an almost working result. The issue is when there are duplicate values (i.e. multiple tasks occuring on the same date) - I've coloured in pink the offending items - where the first example of the instance is duplicated.

Any thoughts or suggestions would be very much appreciated!

The formula I'm using is: =IFERROR(INDEX($B$4:$B$18,MATCH(SMALL(IF($C$4:$C$18>TODAY(),$C$4:$C$18),E4),$C$4:$C$18,0)),"")

Apologies for not using the plug-in to copy the data. The security on my device won't allow it

 

[Fluff]

Hi & welcome to MrExcel.
How about

=TAKE(SORT(FILTER(B4:C100,C4:C100>TODAY()),2,1),10,1)

 

[Jon1781]

Hi & welcome to MrExcel.
How about

=TAKE(SORT(FILTER(B4:C100,C4:C100>TODAY()),2,1),10,1)

Thanks very much for the suggestion and for the welcome. It looks like it should work but I'm getting a #NAME? error.

 

[Fluff]

You may not have the TAKE function yet.
Try

=INDEX(SORT(FILTER(B4:C100,C4:C100>TODAY()),2,1),SEQUENCE(10),1)

 

[Jon1781]

You may not have the TAKE function yet.
Try

=INDEX(SORT(FILTER(B4:C100,C4:C100>TODAY()),2,1),SEQUENCE(10),1)

Yep, works beatifully, thanks ever so much!

 

[Fluff]

You're welcome & thanks for the feedback.