Just an FYI at this point - you also could have used the autofilter and
filtered on column B (custom) for values = 2. Then select the values in
column A and copy, select your destination, then click Edit/Paste Special -
Transpose

"Sam via OfficeKB.com" wrote:

Hi All,

I have two columns of data. Column "A" houses Numeric Labels and Column "B"
houses Numeric Values.

Data:
Numeric Labels A20:A105
Numeric Values B20:B105

I would like to return across a Single Row all Numeric Lables that have a
corresponding Numeric Value in Column "B" that is =2 (greater than or equal
to 2).

Thanks,
Sam

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200609/1