Thread: Search Column Data and Return Multiple Values across Row
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sam via OfficeKB.com Sam via OfficeKB.com is offline
external usenet poster
  
Posts: 247
Default Search Column Data and Return Multiple Values across Row
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

Reply With QuoteReply With Quote