I have read several posts (here and other sites), and knowing VERY little about VBA, I thought I'd reach out. I found the perfect solution from Excelisfun's youtube videos (magic trick 1282), which references Mr.Excel Member DRSteele's post:
Can someone help me with how to create a UDF using VBA?
I need to join the items in column B that equal a referenced cell in column A. There will be multiple returns of the same item in column B, but I only need on of each.
{=TEXTJOIN("; ",1,REPT($B$1:$B$8,1*($A$1:$A$8=A$11)))} |
Can someone help me with how to create a UDF using VBA?
I need to join the items in column B that equal a referenced cell in column A. There will be multiple returns of the same item in column B, but I only need on of each.
Column A | Column B |
Active | Full |
Active | Full |
Removed | none |
Active | partial |
Active | partial |
Active | inventory |
Result for Active | |
Full, partial, inventory |