Excel FILTER Function Top or Bottom n Values With Criteria

Download the featured file here: www.bluepecant...
------------------------------------------------------------
Blue Pecan Computer Training Ltd offers on-site or online Excel training for businesses. Training can be delivered at your business premises in the south-east of England or via Teams wherever you are in the world. Visit our training page at www.bluepecan....
In this Microsoft Excel video tutorial I explain how to return the top or bottom n values (10, 5, 3 etc) based on criteria. This can be achieved using 3 functions: FILTER, SORT and TAKE.
#exceltricks #exceltips #exceltutorial

[@IvanCortinas_ES]

Excellent solution Chester. Thank you!!!!

[@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

[@stevereed5776]

Thanks Chester, what if you had ties?