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

Hi RebeccaW,

Yes, Excel can recognize gender based on a person's first name. There are a few ways you can approach this, but one option is to use a formula that references an external database of names and their associated genders.

Here are the steps to do this:

1. Download a database of names and genders. There are several free databases available online, such as the one from the Social Security Administration (https://www.ssa.gov/oact/babynames/limits.html).
2. Import the database into Excel. You can do this by saving the database as a CSV file and then using the "Import Data" feature in Excel to bring it into your spreadsheet.
3. Create a new column next to the "First Name" column in your spreadsheet.
4. In the first cell of the new column, enter the following formula:
   Formula:

   =VLOOKUP(A2,Database!A:B,2,FALSE) 

5. Replace "A2" with the cell reference for the first name in your spreadsheet, and "Database!A:B" with the range of cells in your imported database that contains the names and genders.
6. Copy the formula down the entire column to populate the courtesy title for each person.

This formula uses the VLOOKUP function to search the database for each person's first name and return the corresponding gender. You can then use an IF statement to assign the appropriate courtesy title based on the gender.

For example, if the gender column is labeled "Gender" and contains "M" for male and "F" for female, you could use the following formula to assign the courtesy title:

This formula checks the gender column and assigns "Mr." for males and "Ms." for females.

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Rebecca" wrote in message
...
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.
--
RebeccaW

Excel is a beast of logic. What logic would you use to do this? HTH Otto
"Rebecca" wrote in message
...
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.
--
RebeccaW

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.

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()
--
Gary''s Student - gsnu200819


"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.
--
RebeccaW