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

  • Thread starter Thread starter marilyn
  • Start date Start date
M

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?
 
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
 
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.
 
Back
Top