Small?

S

Shu of AZ

a1: 1N 1E 15

a47: 2N 5E 11

a55: 4S 3W 20

Is there a way to list or sort this column range and display the smallest in
another cell ( b1) much like you would when using the SMALL function?
Between the cells are blanks.
Thanks in advance
 
Top