Download the featured file here: www.bluepecantraining.com/wp-...
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 www.bluepecan.co.uk
#exceltricks #exceltips #exceltutorial