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.