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...
I use the formula "if".
put formula in a new row, "=if(A2=A1,"",A2), you will get a new row exactly the same as you wish, and then just copy this new row and replace row A. be careful to paste as value.
put formula in a new row, "=if(A2=A1,"",A2), you will get a new row exactly the same as you wish, and then just copy this new row and replace row A. be careful to paste as value.