In Progress

excel- i need formula or macro find/replace in excel-urgennt

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

---

Skills: Data Entry, Excel

See more: excel replace formula, macro find gender excel, want male replace female excel, excel macro replace names formula, i need to write, data entry macro, attain, replace formula excel, excel sheet formula, david data, sue, macro, macro excel, macro + excel, i need an ad, hanson, fill in excel, fill excel sheet, excel formula, fill male female excel, male column, write macro, want find person, blank fields, name empty

About the Employer:
( 17 reviews ) istanbul, Turkey

Project ID: #1275195

Awarded to:

VVladimir

Please see my proposal in PM

$30 USD in 1 day
(4 Reviews)
3.1

11 freelancers are bidding on average $37 for this job

binaryromel

### Already done. Please check PM. ###

$30 USD in 0 days
(105 Reviews)
6.1
panfreelancer

Hello, I have another solution. I hope it will be fine for you. :) Please check PMB. Thanks in advance.

$40 USD in 1 day
(52 Reviews)
5.4
agihcam

It is my pleasure to help. Check your PMB for more details.

$35 USD in 1 day
(42 Reviews)
5.2
pyazlm

I can provide a macro using VBA in Excel do complete the names.

$30 USD in 2 days
(30 Reviews)
4.4
manishadk

please check PMB for details.

$70 USD in 1 day
(18 Reviews)
4.2
shacoim

Hi, Plz Check PM. Important

$30 USD in 0 days
(13 Reviews)
4.0
prithvir53

i will do this work

$30 USD in 1 day
(0 Reviews)
0.0
nomananjum

i will complete, for more check my pm

$50 USD in 12 days
(0 Reviews)
0.0
pemineal

I work with Excel macros since 2000 , but i am new here and is important to me to start projects and get some feedback. Pedro Alves

$30 USD in 1 day
(0 Reviews)
0.0
bnea1407

Hi, If there are lots of names in the database, is it possible that there may be names that are duplicated where one may have a gender and one may not. ie. Mike may appear once in the database with gender = male an More

$30 USD in 1 day
(0 Reviews)
0.0