VB Sort Help

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Good morning. I'm trying to sort a range with the primary sort column
containing positive and negative numbers. The sort is Ascending; however, I
want the Negative numbers to show at the end of the sort. I do not want to
add another column as this is a very complex workbook. A workaround has been
implemented by using the ABSOLUTE Function, but I want to be able to dispaly
te negative numbers.

Any advice will be appreciated. Thanks...
 
Sort descending to place the negative numbers at the bottom.
Then sort the positive numbers (only) ascending.
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html



"The Hawk"wrote in message
Good morning. I'm trying to sort a range with the primary sort column
containing positive and negative numbers. The sort is Ascending; however, I
want the Negative numbers to show at the end of the sort. I do not want to
add another column as this is a very complex workbook. A workaround has been
implemented by using the ABSOLUTE Function, but I want to be able to dispaly
te negative numbers.

Any advice will be appreciated. Thanks...
 

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.

Ask a Question

Similar Threads

Sorting numbers 1
code for sort until cell equals... 1
2 level sorting 1
Creating a range name based on cell content not being a negative value. 5
Worksheet sorting code/technique advise 55
Looping and deleting thru cells which values offset 1
Insert Row when zero or Positive value 2
Problem sorting a range of columns using VBA 1

Back
Top