Distinct dates

Input: Sample file with base data.

Download sample input files here

Goal: Setup a workbook formula that pulls the data from the sample file and apply a filter to get latest 3 distinct date for which data is available in sample file.


1.Use distinct option for date column in filter operation

2.Apply filter again, select top 3 rows and sort date in descending order.