Top 5 customer from the database file based on the selected criteria

[Skeed]

Hi

I have uploaded a sheet. I want to enter the month in the DB sheet. I want it to fetch the top 5 customer name and amount from sheet 1.

I am using DMAX function and it is only fetching the largest amount.

Kindly let me know the solution.
Thanks

 

[NARAYANK991]

Hi ,

See the file.

Narayan

 

[Skeed]

Thanks Narayan