Excel FILTER Function Top or Bottom n Values With Criteria
Рет қаралды 672
Ай бұрынDownload the featured file here: www.bluepecantraining.com/wp-...
------------------------------------------------------------
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.co.uk
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.
@stevereed5776 26 күн бұрын
Thanks Chester, what if you had ties?
@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
Chester Tugwell
Рет қаралды 681
Excel PivotTable Calculated Fields | How to Multiply or Divide Columns | Data Model -SUMX & AVERAGEX
Chester Tugwell
Рет қаралды 620
Computer Gyan
Рет қаралды 414 М.
Lady Milana&PAP
Рет қаралды 3,9 МЛН