Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-14-2015, 09:32 AM
texascpa texascpa is offline Sorting Windows XP Sorting Office 2010 64bit
Novice
Sorting
 
Join Date: Sep 2012
Posts: 19
texascpa is on a distinguished road
Default Sorting

I want to sort the following:
1
3
2


-1

When I sort I want the following:

1
-1
2
3

I want the numbers in order regardless if negative or positive.

Can this be done? If so, how?
Thanks for your help

texascpa
Reply With Quote
  #2  
Old 07-15-2015, 12:22 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Sorting Windows 7 64bit Sorting Office 2010 64bit
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Hi
perhaps use a helper column containing =ABS(A1) pulled down, then sort based on this helper column
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sorting Sorting Issus MdCadle Excel 1 07-09-2013 11:44 AM
Sorting Sorting Challenge gbaker Excel Programming 11 06-22-2012 09:39 AM
Sorting by certain criteria randenius Excel 2 06-11-2012 02:18 AM
sorting problem gsrikanth Excel 4 02-16-2012 12:30 AM
Sorting Sorting question markg2 Excel 4 01-25-2010 03:13 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:04 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft