Can Excel recognize gender?

  • Thread starter Thread starter Rebecca
  • Start date Start date
R

Rebecca

I am putting together a spreadsheet that already has a persons first and last
name and I have to go through and write everyones courtesy title and there
are over 500 names. My question is, Is there some kind of function or
formula that can auto populate each one of their courtesy title by telling if
its man or woman? That would really save me some time. Thanks.
 
Rebecca said:
I am putting together a spreadsheet that already has a persons first and last
name and I have to go through and write everyones courtesy title and there
are over 500 names. My question is, Is there some kind of function or
formula that can auto populate each one of their courtesy title by telling if
its man or woman? That would really save me some time. Thanks.
Click to expand...


Go to

http://www.census.gov/genealogy/names/dist.female.first

and copy the top 500 female names into a new sheet in column A. Put "F" in
column B.

Then go to

http://www.census.gov/genealogy/names/dist.male.first

and copy the top 500 male names below the females, putting "M" in column B.

Sort by column A and then find and remove both listings of the following duplicates:

Angel, Casey, Courtney, Dana, Francis, Guadalupe, Jackie, Jaime, Jamie, Jan,
Jean, Jessie, Jody, Johnnie, Kelly, Kerry, Kim, Lee, Leslie, Lynn, Marion, Pat,
Robin, Shannon, Terry, Tracy, Willie

That should leave you with a lookup table that is pretty close.
 
Very simple:

1. download lists of men' and women's names from the WEB
2. combine both lists into a single column
3. in an adjacent column, list MR or MS for each
4. use =VLOOKUP()
 
Back
Top