How to find each cell with non-negative value?
Apply datafilterautofilter, from dropdown select custom and less than 0
select all visible rows after you filtered the list and delete them (make
sure you select entire row), then clear the filter
You might want to do this on a copy to make sure you get it right
--
Regards,
Peo Sjoblom
wrote in message
ups.com...
On May 14, 6:14 am, "
wrote:
Is there any way (other than a macro) that I can find (move the cursor
to) each cell in a selected column with a non-negative value?
If this cannot be done without a macro, can someone offer a macro that
might move down a column starting with the selected column, selecting
(moving the cursor to) the next cell that has a non-negative value?
|