Selecting Multiple Random Variables From A Row

I doubt this is possible without VBA. If you want to simplify the formula, you could put the second Randbewteen in a third column

Yes, he put that in the question, but thinks the formula is unwieldy.

You could do it like this in VBA:

Please Login or Register  to view this content.

Actually I want to automatically generate messanges like the following:

You can choose between VAR1 and VAR1. We also have VAR2

Row A contains
VAR1a
VAR1b
VAR1c

Row B contains
VAR2a
VAR2b
VAR2c

Will it be difficult if I do it with VBA?


=INDEX($A$1:$A$5,RANDBETWEEN(1,5))&INDEX($A$1:$A$5,RANDBETWEEN(1,5))
Does work, but I loose the overview of what I am doing in big messanges...

Sorry, I've no idea what your last message means - I don't understand what you are trying to do

Thank you for posting the VBA Code. I have never worked with VBA before so I dont really know what to do with it? Can you explain or tell me what I have to look for if i want to set it up!

And thank you so much for your quick help!

I doubt it will do what you want based on your actual requirement. Please upload a workbook with representative data

I know, there are some real monsters, makes me wish for a better way of laying them out. They're always easier to write than read

https://www.excelforum.com/attachmen...1&d=1505819703

As I am from germany the Formulas are in german, bit i hope you can see what i want to achieve.

The output of the second row is:
We over a big variety of sunglasses and sunglasses in many different colors like yellow.

I want it to be something like this:
We over a big variety of shades and sunglasses in many different colors like yellow.

I dont want it to use exactly the same word twice. But instead recalculate and choose a different (or only by chance the same) random item.

Maybe a solution would be if I could reference to the cell b4 but it would calculate the formula INDEX(B5:B100,ZUFALLSBEREICH(1,ZÄHLENWENN(B5:B100,"*"))) inside of the cell instead of just using the value "Sunglasses"