Putting a List in Ascending Order and Skipping Duplicates

Try this:

=IF(ISERROR(SMALL(IF(COUNTIF($B$1:B1,$A$2:$A$7)=0,$A$2:$A$7),1+COUNTBLANK($A$2:$A$7))),"",SMALL(IF(COUNTIF($B$1:B1,$A$2:$A$7)=0,$A$2:$A$7),1+COUNTBLANK($A$2:$A$7)))

entered with Ctrl+Shift+Enter

pb71,

That worked perfectly!! Thank you so much!