Creates list of items found in rows, where these rows match a value in another column.
Think of it as multiple VLOOKUPs, but concatenated and return output as list with custom separator.
Pass workbook, sheet name, and separator as usual with most of my functions.
Edit 2020-05-27: Adding ability to result in unique list, by adding flag (UniqueList = 1), default is not unique.The return is not a Unique list, we can add that (note commented lines) in future versions.
Access is limited.
Login here using your Linkedin account. to see or download code.
No registration, not another password to remember, login using your Linkedin account and have access to all public codes in Mydev.net
Linkedin Login
ColumnNam, MatchingColumn, MatchingValue, Optional UniqueList = 0, Optional Wb = "This", Optional Shee = "Active", Optional Sepa = "||", Optional StartFromRow = 1
Views 1,305
Downloads 451
CodeID
DB ID
