ok.. so I made a quick sample file with some data... don't mind all the X's in it, it is data that needed to be hidden..

attached is the file, you will notice that it will only pick up the first instance of any matches, and not add up any duplicates..

sample1.xlsm