I was wondering if I could get some help sorting this data
Currently, there are many cells with a name followed by (#) # for any number
I have used the two columns to the right to only leave behind the # in order to sort them.
Is there any way to sort these numbers from highest to lowest or lowest to highest and still keep the row in tact. I would like the name to also follow the sorting of the number so that they will match up in the end.
I have attached a test copy that can be used as a reference.