Home |
Search |
Today's Posts |
#1
|
|||
|
|||
problem with #value!/zero
how can I delete cells that have a formula and that formula equals 0 (zero)
in one column and #value! in a other column? eg:- a b 1 0 #value! 2 234.3 3.78 3 0 #value! 4 327 4.712 5 54 23 6 0 #value! 7 0 #value! 8 156 89.7 and so on down to 300 rows . the zero and value cells are not always in the same order they are in random order can some one please help? thanks bill |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Display Problem | Excel Discussion (Misc queries) | |||
Problem with Array Formulas and ISNUMBER | Excel Worksheet Functions | |||
Freeze Pane problem in shared workbooks | Excel Discussion (Misc queries) | |||
Row Autofit problem Excel 2003 | Excel Discussion (Misc queries) | |||
Paper Tray selection Problem, | Excel Discussion (Misc queries) |