Make list of cells in array and checking for duplicates
I have an array B2:F11, that has text in each cell. I need to make a
concantenated list in H2 where cell values are separated by commas. I also
need to make sure that the values in the compiled list are all unique,
because there is a chance that the same value will exist in more than one
cell.
The last thing I need to do is make sure the compiled list is in descending
order.
Can anyone help?
Thanks!
|