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, data entry macro, attain, replace formula excel, excel sheet formula, david data, sue, macro, macro excel, hanson, fill excel sheet, excel formula, fill male female excel, male column, write macro, want find person, blank fields, name empty, data fill excel, find info, macro formula, need formula, formula sheet, fill data sheet excel

About the Employer:
( 15 reviews ) istanbul, Turkey

Project ID: #1275195

Awarded to:

VVladimir

Please see my proposal in PM

$30 USD in 1 day
(3 Reviews)
2.4

12 freelancers are bidding on average $37 for this job

binaryromel

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

$30 USD in 0 days
(53 Reviews)
5.4
agihcam

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

$35 USD in 1 day
(40 Reviews)
5.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
(29 Reviews)
4.9
pyazlm

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

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

Hi, Plz Check PM. Important

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

please check PMB for details.

$70 USD in 1 day
(13 Reviews)
3.9
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
avebest

Peace of cake for me.I can teach you how to do it yourself next time. PM

$35 USD in 1 day
(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