Automatically adding Mr or Ms to male/female

**Timja** · 04-29-2008, 05:34 AM

Originally Posted by TTej

I have a list of data some with people titles, others with it missing. what i plan on doing is

D is the collum for title some are entered others are not. collum G has male and female already filled in.

is there a code to say if D is empty then look at G if it is female enter Ms in collum D and if male enter Mr in collum D.

Thanks

Not sure about how you say if a cell is blank to do this, but just sort the data so all the empty titles cells are at the top then put this formula in column D:

=IF(G1="male","Mr","Ms")

THIS IS ASSUMING THAT G ONLY CONTAINS 'male' or 'female' Otherwise this code will put Mr for 'male' and Female for anything else (e.g. if male had been mistyped)

Hope this helps,

Tim.

**TTej** · 04-29-2008, 05:56 AM

thanks for the code part. unfortunatly i cannot arrange the empty (blank) cells at the top as the sheet is being used for calucations.

can i not use a IF statement.

IF an empty/black cell is found then use the formula, if the cell has any information move down tot he next row?

**martindwilson** · 04-29-2008, 06:20 AM

i dont see a problem put the formula in the first cell in col d in the row that data starts
so say first row is 5 change formula to match row
=IF(G5="male","Mr","Ms")
then drag down it will just over write whats there
so if d20 already had Mr in it it would just be replaced by Mr anyway
once done select all data in row d /copy paste back as special/values to remove formulas.