How to delete ALL cells containing the same data

G

gwc

Cell Contains
A1 000000001
A2 000000002
A3 000000003
A4 000000003
A5 000000004
A6 000000005
A7 000000006
A8 000000007
A9 000000007
A10 000000008
A11 000000008
A12 000000009

A3 and A4 contain 000000003.
Data/Remove Duplicates deletes all but one cell containing 000000003.
Is there a way to delete ALL cells containing 000000003?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to delete ALL cells containing the same data --- REVISED 0
How to delete ALL cells containing the same data 1
Delete cells 0
Delete cells 10
look up data from a one w/sheet and take results to another w/shee 0
Extract data on one spreadsheet to another based on criteria 5
How to use cell reference? 9
Remove specific cells in a column. 2

Top