in excel i understand this may not directly imply sorting by absolute value but im am trying to applying this to a method in account thay requires matching values and need said values sorted by absolute value but able to recognize them as negative and positive still.

suppose I have a large data set of values and I want to sort them by their abs value. but I need to identify which are negative, how would wnule tian about doing so