Can Excel recognize gender?

[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.

 

[Don Guillett]

Madison? etc
Excel can't look up dresses. At least not until the next version.

 

[Otto Moehrbach]

Excel is a beast of logic. What logic would you use to do this? HTH Otto

 

[Glenn]

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.

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.

 

[Gary''s Student]

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()