Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2024/06/Top-N-Values.xlsx
------------------------------------------------------------
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 https://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