Find 7 newest dates with index match countif and large

[brems]

Hi all,

It may already be treated on the forum but I didn't find it. Nor did I find an applicable solution for this problem on the internet.

I want to find the 7 most recent dates in a table but each date is listed more then once.
I already succeeded in filtering unique dates but these are the oldest dates in the table and I want to find the 7 newest dates.

Can anybody advise me where I can put my LARGE?

I added a sample file.
Many thanks for your assistance.

Regards,
Wim

 

[Sajan]

Hi Wim,
Here is one approach:
=LARGE(IF(FREQUENCY(dateslist,dateslist),dateslist), D7)
where D7 points to a cell with values like 7, 6, etc.

Cheers,
Sajan.

 

[shrivallabha]

In cell F7 not just enter but CTRL + SHIFT + ENTER:

=LARGE($B$4:$B$45*(FREQUENCY(date[Date],date[Date])>0),D7)

and copy down

 

[brems]

Hi Sajan and shrivallabha,

Thanks a lot for sharing this solution. Works perfect!

I learned again...

 

[Sajan]

Hi,
Thanks for the feedback. Glad to help!

-Sajan.