Been a long time lurker of the forum, but finally forced to ask for help on something
I have a column with values e.g. in B1 I have "red", B2 has "Blue", B3 has "Green" etc.
In another cell I have a randbetween function e.g. C1 = randbetween(1,N)
I want to concatenate from cell...