Hi there,

First, i would like to say thanks to all off you that contribute to this Fórum.

I hope you can help me with this problem in Excel.

So i've got a 20 row's table with Identification, Gender, etc etc.

I would like that Excel in the Gender column, randomly filled with the word Female or Male. The problem is that it must be with 50% frequency.

Something like: 10 Females and 10 Males

I'm using this fórmula: =choose(RANDBETWEEN(1;2);"Female";"Male") but this only fills the columns, doesn't give me the 10 Female and 10 Male.

Hope you guys get it... sorry for the English...
Thank you