Can I sort cells of postive and negative numbers in absolute order

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

Guest

Is it possible to sort cells of postive and negative numbers in absolute
order without changing the formatting?
 
Put =ABS(A1) in a helper column. Select the whole data range (including the
helper column) and sort by the helper column.
[Changing the formatting doesn't change the value in the cell, so won't
change the sort order.]
 

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

making # + or - based on another cells contents 2
Automate bar chart color based on value postive or negative 1
How do I make them all negative?? 2
Change series of numbers from positive to negative 3
change a currency number display 4
How can I convert positive numbers to negative in Excel?? 2
calculating results in formulas 9
Showing Negative as Postive 3

Back
Top