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
chang david
this empty gender must be=2
williams mary
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
—
thank you
shawn
