Excel FILTER Function - Return Duplicates / Identify Duplicates Across Two Columns Using Formula

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

Тэги:

#how_to_find_duplicate_values_in_excel_using_formula #excel_find_duplicates_in_two_columns #find_duplicates_in_two_columns_in_excel #how_to_identify_duplicates_in_excel_without_deleting #how_to_find_duplicate_names_in_excel #formula_to_find_duplicate_values_in_excel #duplicate_rows_in_excel_based_on_cell_value #how_do_i_find_duplicate_rows_in_excel #excel_filter_function_return_duplicates_multiple_values #how_to_find_duplicate_values_in_excel_using_formula_multiple

Скачать видео