Assume the range of numbers is A2:A20. A1 is the column header. Let's assume
the column header is Nums.
In E1:F1 enter the column header Nums
In E2 enter <0
In F2 enter >=0
Select the range A1:A20
Goto the menu Data>Filter>Advanced filter
Select: Copy to a new location
The List range should already be filled in
Click in the Criteria range then select E1:E2
Click in the Copy to range then select E3
Click OK
That will extract all the negative numbers. Repeat the process for the
poistive numbers.
After you're done you can delete the stuff in E1:F2.
Also, Excel automatically creates defined names when you do the filter
operation. These names are no longer needed. You can delete them also.
Goto the menu Insert>Name>Define
Select the name Criteria>Delete
Select the name Extract>Delete
OK
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
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.