Automatically adding Mr or Ms to male/female

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.