I used the =A1 & " " &text(B1,"$#,#0.00") formulae in cell D1 to combine cells A1 & B1
Now i'm wondering if its possible to:
1. Make cells D1 all the way through to D17 appear in cell F1 through F17 listing randomly
I have attached an example..
Thanks in advance