I gang

Excel Spreadsheet Research Project_2

Step by Step:

1. V_FREELANCER & C_FREELANCER will be the two main files you will be inserting data onto.

2. On excel sheets V_FREELANCER & C_FREELANCER Identify CITY & STATE by viewing column A & B.

3. On excel sheet File_2, you will filter the sheet, using column B (RC/CITY)

4. Type in the city name in filter search bar drop down, in this example we will use the city of Abilene, TX.

5. File_2 sheet will then filter all the results for Abilene.

6. You will then identify the correct selection by cross referencing city (Abilene and the state TX, off for both files V_FREELANCER & C_FREELANCER to File_2.

- Make sure you are double checking your selection and that both City and State match off of both files (V_FREELANCER & C_FREELANCER to File_2)

7. Once you make the selection and you are sure that you have identified the correct selection, you will highlight Columns C (Rate Center Abbrev) through Column M (New Local Inbound coverage) off of File_2, copy the selection and paste it onto Files V_FREELANCER or C_FREELANCER onto columns C (Rate Center Abbrev) through Column M (New Local Inbound coverage)

See example already completed for you on Files V_FREELANCER & C_FREELANCER.

- Note: you will be copying entire column in yellow from File_2 and pasting it onto files V_FREELANCER & C_FREELANCER.

8. For the cities where you do not find matching results for insert N/A for all columns.

Færdigheder: Dataindførsel, Excel

Se mere: double data entry excel, abilene, excel 2013, excel $2-30, city state excel sheet, spreadsheet columns, spreadsheet insert, matching files excel, excel matching files, matching excel files, excel column copy, data matching project, state city name excel, matching excel, type excel sheet, excel drop, cross checking excel, research data entry excel sheet, data spreadsheet research project, project excel spreadsheet, cross checking data excel, excel search match, excel data matching, city name excel sheet, excel spreadsheet research project

Om arbejdsgiveren:
( 112 bedømmelser ) Orange, United States

Projekt-ID: #4108356

Tildelt til:

pierreho

I give it in a few minutes.

$50 USD på 1 dag
(27 bedømmelser)
4.9

15 freelancere byder i gennemsnit $74 for dette job

Innovative116

Hi. I am interested in the project. Please check private message for more details. Thank you

$110 USD in 2 dage
(105 bedømmelser)
6.9
sonarkaushik

Sir, I can do the project. Refer PMB. Looking for further discussions in this matter. with thanks and regards

$145 USD in 7 dage
(58 bedømmelser)
5.7
HardWorker1989

Hello Sir. I am a highly qualified, certified, talented and skilled data entry operator with exceptional data handling skills. I can perform the data entry of your project as per your requirements but I have a qu Mere

$150 USD in 5 dage
(33 bedømmelser)
5.4
sammahmud

Hi, I am interested in this project and assure you that if given me this opportunity, I will prove my efficiency, reliability, and 100% accuracy. Thanks

$30 USD på 1 dag
(59 bedømmelser)
4.7
naveenvarthaan

Hi attheriver3 , Simple task, I am writing a macro to complete the task. Perfection assured. Pay back after you get the FULL file Best Regards, Naveen

$30 USD på 1 dag
(13 bedømmelser)
4.2
pakee

Hello, Consider it done with 100% accuracy. Please check the attached sample. I have filled 1 entry in C_FREELANCER file for you. CHeck pm for details. Thanx

$40 USD på 1 dag
(22 bedømmelser)
4.0
freelancer0080

Details at private message

$100 USD in 7 dage
(9 bedømmelser)
3.8
afua23

I read carefully the entire post and took a lot at the spreadsheet and i am convinced i can do this job for you.

$100 USD in 5 dage
(13 bedømmelser)
3.5
eugene2006

Hi. I would like to update this excel files for you.

$40 USD på 1 dag
(8 bedømmelser)
3.4
arunnama001

hello sir check pm and reply

$50 USD in 3 dage
(4 bedømmelser)
2.4
Hemantb11

I can do this task, Please check you pm.

$40 USD in 2 dage
(1 bedømmelse)
1.0
aijordanov

Professional consultant and experienced Excel user here. Ready to go.

$30 USD på 1 dag
(0 bedømmelser)
0.0
vipinpal2005

Hi, I can do this project easily with 100% accuracy. Please check your PM.

$30 USD in 7 dage
(0 bedømmelser)
0.0
prasri2007

We will do your work.

$168 USD in 7 dage
(0 bedømmelser)
0.0