How to sort repeated numbers in ascending or descending order ignoring their signs?

[Akshay Desai]

I Have one excel file in which thousands of mixed numbers are there in one column. i just want to sort those numbers according to their repeated values, and ignoring their signs.
For Example

 1      1

 3     -1

 7      3

 5      3

 3     -3

 4      4

-3      5

-6     -5

-5      6

 6     -6

-1      7

-7     -7

Like this i need to sort.
Thank you.

[#2]

Hi Akshay,

Could be done with helper column, e.g. https://www.extendoffice.com/documents/excel/1284-excel-sort-by-absolute-value.html