This way, you get only the first occurrence of a value in Column B. If the value does appear more than once, the IF Function returns a blank and if not, it returns the value from Column B. The COUNTIF Function checks, for each cell in Column B, whether it appears again in the column. To remove duplicate values, and leave those cells blank, follow these steps. Say you have the following list of names with duplicates in Column B. When you have a list containing duplicates in Excel, you can remove duplicates and leave the cells blank using the combination of the IF and COUNTIF Functions. In this tutorial, you will learn how to clear duplicate cells in Excel and Google Sheets.
0 kommentar(er)
