excel formula to remove duplicates for column

Now the criteria_range1 seems to be $A$2:A2. Simply select the starting cell reference of the criteria_range1 and press the F4 Key once which will convert the cell reference from the relative cell reference to the absolute cell reference. Place a comma (,) to move to the next argument.Īgain select cell A2 as criteria1, the second argument of COUNTIFS function. ) from the keyboard, so Excel converts the cell reference into a range and the range starts from the same cell (or the same point) and it seems to be A2:A2. Select the cell A2 as criteria_range1, the first argument of the COUNTIFS function. ■ Note: the upper or lower case does not matter in syntax, Excel by default considers it in upper case.Īs a result, the COUNTIFS syntax appears with an open parenthesis. Place an equality sign (=) in cell F2 and type ‘ count…’, select COUNTIFS from the below suggestion list by the Down Arrow key ( ⬇) and then press the ‘ Tab’ key.

■ Note: Instead of the COUNTIFS function, we can also apply the COUNTIF function. ⇒ We can easily remove duplicates in Excel dataset without disturbing unique data. ⇒ We have got a chance to recheck the duplicate data. ⇒ we can easily find and highlight duplicates in Excel dataset. The COUNTIFS function is the best solution because it fills up the below requirement: While working with a huge dataset, it is impossible to find out duplicates and removes them one by one. (01) HOW TO FIND AND REMOVE DUPLICATES IN EXCEL ➢ USING COUNTIFS FUNCTION (04) HOW TO FIND AND HIGHLIGHT DUPLICATES IN EXCEL ➢ USING CONDITIONAL FORMATTING.(03) HOW TO FIND AND REMOVE DUPLICATES IN EXCEL ➢ USING ADVANCED CONDITIONAL FORMATTING.(02) HOW TO FIND AND REMOVE DUPLICATES IN EXCEL ➢ USING ‘REMOVE DUPLICATES' COMMAND.STEP 2: HOW TO REMOVE DUPLICATES IN EXCEL.

STEP 1: HOW TO FIND DUPLICATES IN EXCEL.(01) HOW TO FIND AND REMOVE DUPLICATES IN EXCEL ➢ USING COUNTIFS FUNCTION.

Excel formula to remove duplicates for column