Excel FILTER Function Top or Bottom n Values With Criteria

[@IvanCortinas_ES]

Excellent solution Chester. Thank you!!!!

[@stevereed5776]

Thanks Chester, what if you had ties?

[@Murad_R]

Thanks a lot

[@excellover7172]

Thank you chester! It was helpful.

[@loveislife4769]

Your video on creating invoice in excel was credible. But if someone wants the invoice number to be Alfa numeric like krish/01 where krish will be constant and only 1 would be incremented for each invoice