Forum Discussion
Hiding Data in Excel - Need help!
This is a current spreadsheet I am working on - it is to record book sales. All the repeating data, I want to make blank until the blank areas are filled in. Is this possible? I have tried the condit...
Hey Sioren ,
1) You can create another column to identify whether or not the number in the original column is a duplicate or not by using this formula: =IF(COUNTIF($A$1:$A1,A1)>1,"Duplicate","No")
2) You can then select this column, use the Find option in the Home Tab to delete all the Values that say "Duplicate":
3) This should you a list of cells that contain the value "Duplicate". Select all of them by holding down the shift key and clicking the last row.
4) Then Press Close and all the cells that contain the value "Duplicate" should be highlighted
5) Finally, press Delete and Hide column E.