533020 urgennt- i need formula or macro for find/replace in excel
N/A
Igangværende
Slået op over 12 år siden
N/A
Betales ved levering
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