Rebecca wrote:
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.