i have an excel sheet with first names and gender data in different columns. the problem is ----but some gender info is blank. i want to attain values to gender data like 1 or 2. if male=2 if female=1. and i know that mary is female ad mike is male.
so i need to post a value to the gender of a person if name is x. for example if gender column= blank, and the name column = mike then gender column write gender= 2 as gender value.
GENDER LAST_NAME FIRST_NAME
2 Hanson Mike
1 harrold sue
this empty gender must be=2
this empty gender must be=1
in a sheet there is 50000 records, i have 20000 blank GENDER fields. so ineed to fill most of them
i need a formula /macro to run in excel.
i thought of trying this with 20-30 names, one by one.
if name is Sue make gender 1
if name is Mike make gender 2
but these are different columns