I am looking for formulas that will display the actual numbers based from smallest to largest from a column of numbers (for example, if A1=1, B1=4, C1=2, D1=1, and E1=3 (each of these values can actually be anything from empty to 7)
I would like G1=1, G2=2,and G3=4.
G1 is easy. use the formula "=if(sum(a1:e1)=0,"",min(a1,e1))"
G3 is also as easy, using the formula "=if(sum(a1:e1)=0,"",max(a1,e1))"
I can not figure out how to get G2 to show the number in the middle (or in the event of 4 different numbers, how to find and show the middle 2 numbers respectively)
Solved by M. S. in 19 mins