Excel Countifs Function to Count Duplicates Across 2 Columns


=COUNTIFS(range,criteria,range,criteria) // for 2 conditions


Type the below formula in to an Excel sheet in cell C2 and drag down. You can then use Data > Remove Duplicates for the Name and Club columns to get concise duplicate counts. You will have to copy and paste values for the duplicates column before removing duplicates otherwise they will be recalculated.


Leave a Reply

Your email address will not be published. Required fields are marked *