Placing Conditions on Randbetween to Avoid Clashes With Other Columns

[sincy]

Hi Guys,

Firstly, apologies for the total lack of a snappy title...

I have a job interview next week in which i will have to show how i would handle receiving responses to certain questions on a questionnaire.

My idea is to Randbetween and Choose(Randbetween) to give myself a real working example of what i might do.

So i have various headers and have randomised between set parameters to fill the columns with possible responses.

The problem is that some of the randomised entries in one column would make no sense in real life when you consider them against some of the other data in an another column. (I know.....that's they call it random!)

Is there a way to tell Excel not to enter X in a cell where the corresponding cell one column to the right is Y??

Thank Youuuuuuuuuuuu

 

[oldbrewer]

with a macro, yes

otherwise in A1 =if(B1="Y","",999)

so you get either blank or 999