Filtering Sheet based on criteria - removing duplicates

I have a problem with a macro I found in the web. I'm fairly new to macro coding and would really appreciate all the help I can get. I was able to run the macro and I just need one more filtering.

Raw data looks like this:
GroupName GroupID SubGroup
Carol 101 Caroline
Carol 101 Caroline
Carol 101 Carl
Greg 102 Greg1
Greg 102 Greg1
Greg 102 Greg 1
Greg 102 Greg

I was able to filter to this:
GroupName GroupID SubGroup
Carol 101 Caroline / Caroline / Carl
Greg 102 Greg1 / Greg1 / Greg 1 / Greg

I would want to filter the SubGroup further to this:
GroupName GroupID SubGroup
Carol 101 Caroline / Carl
Greg 102 Greg1 / Greg 1 / Greg

-removing the duplicates in SubGroup column.

Please Help! Thanks!

Hi

Put this into a general module.

Please Login or Register  to view this content.

Then change your button code to be

Please Login or Register  to view this content.

rylo

That's almost it! Except it's also removing data that should stay.

We begin with this data:

Carol 101 Caroline
Carol 101 Carol 1
Carol 101 Carl

Greg 102 Greg1
Greg 102 Greg1
Greg 102 Greg 1
Greg 102 Greg

Tim 103 Tommy
Tim 103 Tommy
Tim 103 Timmy
Tim 103 Timmy
Tim 103 Tommy

rylo's code generated this:

Carol 101 Caroline / Carol 1 / Carl
Greg 102 Greg 1 / Greg
Tim 103 Timmy

For Carol, the result is fine.
For Greg, it should have been Greg1 / Greg 1 / Greg
For Tim, it should have been Tommy / Timmy

Thanks for the quick reply! You the man!
Thanks rylo!

Hi

oops....

Try

Please Login or Register  to view this content.

rylo

You did it! Thanks so much! I'd shake your hands if I could but the best thing I can do is to thank you from the bottom of my heart! That's one wicked talent you got! You the man!