View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Davidm Davidm is offline
external usenet poster
 
Posts: 20
Default Only Cells with positive answer to IF formula

I have an IF formula in Column A that puts a number from another cell if
positive or
"" if negative. I want to put in say column B a formula that will bring all
the positive responses in order to the top of Column B, instead of just
spread out in A, is this possible or is their another solution
Regards David