No video
Excel FILTER Function Top or Bottom n Values With Criteria
Рет қаралды 786
2 ай бұрын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 2 ай бұрын
Excellent solution Chester. Thank you!!!!
@excellover7172 2 ай бұрын
Thank you chester! It was helpful.
@loveislife4769 2 ай бұрын
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 2 ай бұрын
Thanks Chester, what if you had ties?
Chester Tugwell
Рет қаралды 805