I see pieces of formulas that solve what I'm looking for, but can't get it
all to work together. I have a list of scores that I'll continue to add to
that I need to sort with a formula from lowest to highest. I want to keep
duplicate entries but don't want to show blank entries. Here's an example:
Row ColA ColB (sorted)
1 42 36
2 42 38
3 36 40
4 42
5 40 42
6 42 42
7 48
8 48
9 38
10 fill in 10-25 later
.....
25

I'm a beginner with these more complex formulas, so I really appreciate you
saving me the frustration.
Thanks!