Hi Folks,

I have a Excel 07 sheet I'm working on featuring a column which populates with Customer's names, if various criteria are met.

So what I have is a column with some names in it and a lot of blanks.

I'd like to be able to capture the names and create a list of them on my sheet's 'Summary' tab, preferably using a formula. Obviously counting the number of names that appear is no problem, but it would be pretty cool to have the individual names listed alongside.

Any suggestions greatly appreciated!

Dave