How to go to specified values of a cell in a highlighted area?

[marilyn]

Can sombody please help me?
I want to know how to have excel go to cells in a column (or
highlighted area) that contain ONLY the value that I specify. Say, If I
have a column full of random numbers, and I want to delete all cells
that contain the value 0, how can I do that without having to delete it
one by one?

 

[Anders S]

Marilyn,

How to do it depends on how often you have to do it.

If it is a once only job,
- sort the data on the column you are looking in and delete the cells/rows
manually.
If you have to keep the original sort order of the remaining cells/rows, insert
a sequentially numbered column before you do the first sort and sort back on
that column.

If you have do this on a regular basis I believe you need a macro.

HTH
Anders Silvén

 

[Dale Hymel]

Assume your column of numbers is Column A.

Identify a cell with the Criteria (Say cell C1 = 0)
Insert in B1 =if(A1=$C$1,0/0,"")

then auto fill to end of your data.

The formula will return #Div/0! if it matches cell C1.

Highlight the column, then Ctrl G (Go To...), select Special, select
Formulas, then uncheck numbers, text, and logicals. Leaving errors check
only. Then OK.

Right click on any of the highlighted cells, select Delete, the Entire Row.