Concatenate visible cells, remove duplicates

  • TL;DR: I need a formula to concatenate visible cells, remove duplicates, and add a ", " in between values.

    I have a spreadsheet that I have macros filtering all the time and running data pulls.
    Row 3 holds formulas that pull specific metrics out of my data set in A6:S16627.
    Cell R3 calls a VBA script to run that concatenates visible cells, and returns a value with duplicates removed.
    For example, if the data was 100, 100, 101, 102, 101, it would return "100, 101, 102."

    Is this possible with formulas? I have a script that accomplishes this already, but the script can't update effectively within the sheet when filters change.

    Thanks in advance.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!