I have two columns of data. The first is a count of respondents. The second is the average score for those respondents.
I need to sort the second column into numerical value, highest to lowest. So far, so simple.
The area I am having an issue with is that if the number of respondents is less than 21, the score is replaced with an asterisk. When I sort the columns now, the asterisk is placed at the top, but I want it to be shown at the bottom. Is there any way to do this?
I will eventually be performing this sort in VBA, if that makes it any easier?
I need to sort the second column into numerical value, highest to lowest. So far, so simple.
The area I am having an issue with is that if the number of respondents is less than 21, the score is replaced with an asterisk. When I sort the columns now, the asterisk is placed at the top, but I want it to be shown at the bottom. Is there any way to do this?
I will eventually be performing this sort in VBA, if that makes it any easier?