Forum Discussion
How to remove just the value in a cell in a row
I want to remove duplicate values in a column, but just the value in the cell. I don't want to remove the entire row and move all the rows up. Attached is a screenshot of what I'm looking to do. On t...
To do that, follow these steps...
- In cell D2, place the formula =COUNTIF(A$2:A2,A2)=1 and double click the fill handle to copy it down.
- Type Flag in cell D1.
- Select cell D1 and press Ctrl+Shift+L to apply Filter.
- Expand the filter dropdown in D1 and uncheck (Select All) and check False and click on OK.
- Now select the first cell in column A below the column header 'Color', in this case, it would be cell A3 as per your sample data and press Ctrl+Shift+Down Arrow Key to select all the visible values in column A.
- Press Delete from the keyboard to delete all the selected values in column A.
- Press Ctrl+Shift+L again to remove the Filter and you will have the desired data in the end.