ExcelBanter - View Single Post - Vlook up nonblank in B:B and return in A columns

Teethless mama

Take a look this site

http://www.contextures.com/xladvfilter01.html#ApplyAF

"Narnimar" wrote:

I got a list in B:B in which there are values in but some are blank. I need a
if formaula can summerize it in A column with only those which are
nonblanks.
A B
Car 2
Bus 1
Train blank
Flight blank
Cycle 20
Horse Blank

the sumery should apear just like -
A B
Car 2
Bus 1
Cycle 20

Any Help is highly appreciated.