Hi All,

I have two Columns of data: Column "E" houses the Numeric Labels and Column
"F" houses the Numeric Values. Column "F" will have genuine duplicate values
that should be included.

The criterion value will vary. I would like to find / match all values
(duplicates included) that are equal to 1 (in Column "F") and then have all
their corresponding adjacent Numeric Labels returned from Column "E" to a
single cell, if possible. If not, then returned to individual cells on the
same Row.

Thanks
Sam

--
Message posted via http://www.officekb.com