look here
http://www.cpearson.com/excel/ListFunctions.aspx
then here
http://www.cpearson.com/excel/noblanks.htm