![]() Click Kutools > Select > Select Duplicate & Unique Cells.ģ. Select the range that you want to apply this utility.Ģ. The Select Duplicate & Unique Cells utility of Kutools for Excel can help you quickly select all duplicate cells in a range, after that, you can only press the Delete key in the keybord to remove them.īefore applying Kutools for Excel, please download and install it firstly.ġ. Note: You can change the cell references in above two formulas based on your needs. Tip: If you need to replace all the duplicate values (include the first one) with blank cells and only keep the unique values in the range, the following formula can help you, and you will get the following results: ![]() ![]() Then you can see all duplicates (except the first one) are replaced with blanks. Select the result cell and then drag the fill handle across the range that you want to apply this formula. Please do as follows:ġ.Select a blank cell to output the result such as cell D2, enter the below formula into it and press the Enter key. If there are some duplicate data in a range, the following two formulas will guide you to replace duplicates with blanks in the range. Remove duplicates and replace with blank cells with Kutools for Excel Remove duplicates and replace with blank cells with formulas ![]() This article is going to guide you remove duplicates and replace with blank cells in Excel. But sometimes, you want the blank cells to replace the duplicate values, in this situation, the Remove Duplicate command will not work. ![]() Normally when you apply Remove Duplicates command in Excel, it removes the entire duplicate rows. How to remove duplicates and replace with blank cells in Excel? ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |