I have been racking my head around this and several suggestions were very
close, but I could not get them to work...

I have a user interactive excel session and want to dynamicly collect parts
list, create an order sheet and invoice.

I have a parts list?
Col_A Col_B
widgit A Y
widgit B
widgit C Y
widgit D

I know I need to build an array and index thru and remove the blanks and
nulls...

Desire result, somewhere on the same worksheet:
Order
widget A
widget D

That is it, pretty simple, but I have yet to figur this out.