I am comparing 3 columns of data with multiple rows. For each row I want to show the highest, lowest and middle number. The middle number is not the mean.
I've considered "1st, 2nd, 3rd" but I don't want to convey a higher/lower number is the best choice. Sometimes having the highest number would actually be bad but other times it would be good. I'm looking for a way to point that out more easily as well.
I've also considered using up and down arrows but I'm not sure what I'd use to represent the middle number.