sorting the number not whether it's = or -

**Ian99099** · 02-21-2015, 08:05 AM

Can someone remind me of the relevant formula or term to do this please?

I need to change

1
-2
-3
4
-5

to
1
2
3
4
5

Thanks in anticipation!

Ian

**samba_ravi** · 02-21-2015, 08:18 AM

Use ABS function like
=ABS(A1)
Try this and copy towards down

**sourabhg98** · 02-21-2015, 08:19 AM

You can use an abs function to remove the negative values ..
For example if you have a value in A1 say -4 use this
=abs(A1)
...it will give you the result 4 and keep +ve values +ve

**newdoverman** · 02-21-2015, 11:16 AM

This will sort the numbers in order regardless of sign:

Formula:

Please Login or Register  to view this content.

...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER. You will know the array is active when you see curly braces { } appear around your formula. If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer. Press F2 on that cell and try again.

Change the $A$1:$A$5 to suit your data.