Forum Discussion
Akshay Desai
Jan 12, 2018Copper Contributor
How to sort repeated numbers in ascending or descending order ignoring their signs?
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 ...
SergeiBaklan
Jan 12, 2018MVP
Hi Akshay,
Could be done with helper column, e.g. https://www.extendoffice.com/documents/excel/1284-excel-sort-by-absolute-value.html