Subscribe now and choose from over 30 free gifts worth up to £49 - Plus get £25 to spend in our shop
Ok got a spreadsheet with multiple colums, want to hide teh duplicates in one column without affecting the others e.g
Owner Bike
Geoff Colnago
Geoff Santa Cruz
Bill Orbea
Bill Turner
to be displayed as
Owner Bike
Geoff Colnago
........ Santa Cruz
Bill Orbea
........ Turner
But want to use the same formula in each cell so basically if the cell value is the same as the cell value in the previous row so I can set the condition up for one cell and copy it wholesale to all other. where the .... would just be an empty cell
Cheers
Pivot Table?
You can use conditional formatting.
Set to "cell value is" then set the condition as "equal to" and select the cell directly above.
Then set the format: I would simply set the text colour to white or whatever the background colour is that you are using. The text will then simply disappear. The cell won't be empty but the text will be invisible against the background.
cheers