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.