How to Create a Random Generator

Hello,

Can anyone help me? I would like to create a random calculation through vba that will pick a persons name. I would like it to first choose a state, then choose a gender(male of female), then based on the state and gender it will select a name from a group specific to the state and gender. i have try this using the rand and rank functions but i'm certain that there is an easier way.

I attached a file with what i have attempted so far but failed. Attachment 209596ed

If any of what i explained does not make any sense i apologize and would be more than happy to clarify.

Thank you,

Hi,

Does the attached help.

It requires your data to be listed as in sheet 2, i.e. a straight forward list rather than in blocks) The helper column in column D is an array formula entered with Ctrl Shift Enter. Press F9 and each time a calc takes place you'll see the names randomly distributed in column G