|Without more specific re: the layout of your workbook, it's kind of hard to offer a specific solution. It is not clear to me if the list you posted is hard-coded into the cells or if the values are the result of a formula. The solution may depend on how the values ended up in the cells.|
A simple solution might be to sort your list which would eliminate the blanks.
A more elegant solution might be to use this formula in Column B, or any Column you chose as long as you reference it correctly in the formula. You'll note that the last argument references the Column in which the formula resides.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.