Thread: HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom[_3_] Peo Sjoblom[_3_] is offline
external usenet poster
  
Posts: 136
Default HOW DO I SEPERATE POSITIVE AND NEGATIVE VALUES FROM A COLUMN
Use autofilter, first filter custom and select greater than or equal 0,
select and copy and paste into positive column, change to less than 0 and
repeat for the negative values

--


Regards,


Peo Sjoblom


"FRANK" wrote in message
...
I HAVE A COLUMN OF FIGURES I WISH TO MAKE TWO MORE COLUMNS ONE SHOWING
POSITIVE VALUES ONE SHOWING NEGATIVE VALUES


Reply With QuoteReply With Quote