View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Barry Walker Barry Walker is offline
external usenet poster
 
Posts: 31
Default Delete all negative numbers leaving only positive numbers

I have a column containing positive and negative numbers. I need a formula
that will delete all the negative numbers from the list leaving only the
positive ones.

the list is extremely long so it would help me enormously. I hope someone
can help

Regards

Basil