Excel VBA : Remove Duplicates from a delimited List

Chris H

0 0

Published 2019-03-09

Need help with Excel, Access or Oracle? Find me at www.upwork.com/freelancers/~011b1d6c23ae3d4041

All Comments (4)

@chrish281 5 years ago

VBA - Function UniqueList(ListIn As Variant, strSplitBy As String) As Variant Dim dict As Object Dim strTmp As Variant Set dict = CreateObject("Scripting.Dictionary") For Each strTmp In Split(ListIn, strSplitBy) dict(Trim(strTmp)) = 1 Next UniqueList = Join(dict.keys, strSplitBy) End Function How to use, in Cell E2 - =UniqueList(D2,";")
@slowmopoke 5 years ago

Please download and re-upload this everywhere.
@slowmopoke 5 years ago

Please download and re-upload this everywhere.