Thread: Provide list from all columns marked with and "x"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Herbert Seidenberg Herbert Seidenberg is offline
external usenet poster
  
Posts: 1,180
Default Provide list from all columns marked with and "x"
Select the 1x5 array of column labels and name it items
Select the 3x5 array of x's and name it arrayX
Insert Name Define arrayB
Refers to: =IF(arrayX="x",items,"")
Select the three cells in column B and enter this array formula
with Ctrl+Shift+Enter
=CONCATENATE(INDEX(arrayB,,1),INDEX(arrayB,,2),IND EX(arrayB,,3),
INDEX(arrayB,,4),INDEX(arrayB,,5))

Reply With QuoteReply With Quote