I have a unique problem I have been trying to tackle with no avail. I have scoured through the internet but only found partial solutions and not a complete solution.
I am looking for a function (or several functions) to solve this issue without adding references.
I have 2 Columns (Column A and Column B).
Each Cell in these Columns can be blank or contain 1 or more numerical values (numerical values are separated by a comma). The User will be manually entering these numerical values.
I need a function that displays all the unique numerical values into a single Cell and are separated by commas (in chronological order if possible).
Now once this has been established, I then need a function to count the number of unique numerical values from this Cell into another Cell.
Any help on this would be greatly appreciated.