![]() ![]() ![]() 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. |