Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2024/05/Return-Duplicates.xlsx

In this Microsoft Excel video tutorial I explain how to return or identify duplicates using the FILTER function. In the example used in the video I identify duplicate rows where the combination of values in two columns is duplicated. The same method can be used where are 3, 4, 5 (or more) columns.

I also show how to sort the array returned by the FILTER function.

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

#exceltricks #exceltips #exceltutorial