I have a list of names (Col A) each associated with a data value (Col B). The data values are numbers and include both zeros and blanks. My ultimate goal is to use a formula to create a third column (Col D in my example file) that includes only those names with data that is NOT zero or blank.

My example file offers one such solution, with the the bulk of the work being done by Col C which identifies the rows that contain data values that are non-zero.

I would like to simplify my array formula, as well as eliminate the helper column (Col C with the identified row numbers).

Anyone want to take a swing at it? Thanks!

Note: the part of the array formula ROW(OFFSET($B$6:$B$16,-ROW($B$6)+1,0) is used to refer to the size of the array of Name(s)

I leveraged my solution from: http://www.excelbanter.com/showthread.php?t=15239

CopyList.xlsx