Thread: Small?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Shu of AZ Shu of AZ is offline
external usenet poster
 
Posts: 130
Default Small?

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