Hi everybody
I need help to generate a list of random names, they must have at least one surname. Ex: Homer Simpson
The full name must be in just one cell. Is there any formula to do that?
Thanks,
Falconair
Hi everybody
I need help to generate a list of random names, they must have at least one surname. Ex: Homer Simpson
The full name must be in just one cell. Is there any formula to do that?
Thanks,
Falconair
Well, if you had a list of names to begin with you could pull a random sample from it using Excel, but you don't honestly expect a computer program to create the names, do you?
well there's several ways see this one press f9 to re calculate
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
martindwilson that's exactly what i needed thank you very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks