Find Jobs
Hire Freelancers

URGENT. Excel. Google Scripts. Microsoft Access.

$30-250 CAD

Suoritettu
Julkaistu yli 2 vuotta sitten

$30-250 CAD

Maksettu toimituksen yhteydessä
We have data lists with phone numbers, we need to match to a database confirming if a phone number is mobile or landline, then write the result into the data list. Please watch this and submit your quote: [login to view URL]
Projektin tunnus (ID): 31922902

Tietoa projektista

17 ehdotukset
Etäprojekti
Aktiivinen 2 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
Myönnetty käyttäjälle:
Käyttäjän avatar
Hi There, I have reviewed your requirement and I can definitely start immediately. Also I am 100% available during EST (New York Time) hours. I worked on numerous similar projects in the past and always impressed the clients with my excellent solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/kevivu.html Expert in MS Office/Google GSuite / VBA(Macros)/ GScript /PYTHON/VBA/VB/.NET/WEB/ Access/Excel/Word/Outlook/SOAP/REST/API/SQL Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Charts, formatting, templates, dashboard, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Looking forward to work with you.. Have a nice day Thank you
$30 CAD 1 päivässä
4,9 (77 arvostelua)
6,1
6,1
17 freelancerit tarjoavat keskimäärin $70 CAD tätä projektia
Käyttäjän avatar
Hello there yes i can make small VBA and formula to show mobile and landline regards ILYAS
$30 CAD 1 päivässä
4,7 (61 arvostelua)
5,0
5,0
Käyttäjän avatar
Hey! I am really interested in this job. I’m data scientist working remotely with various analytical companies. I’m offering best quality and highest performance at a price we are both comfortable with. I can complete your project on time and your will experience great satisfaction with me. I’m well versed in R, python, SPSS, Stata, Excel etc I have rich experienced in Excel, Google Sheets and Microsoft Access. For more information about me, please refer to my portfolios. I’m ready to discuss your project and start immediately. Looking forward to hearing you back and discussing all details.. Thank you!
$100 CAD 2 päivässä
5,0 (2 arvostelua)
3,5
3,5
Käyttäjän avatar
Hi There, Hope you are doing well, Interested in your posting as I’m used to perform such project (See Profile). I’m ready to have a look and start right away if you give me a chance. Please share more details (File or sample )in order to run a test. It should be easy depending on the database you have. I would like to assist you at a reasonable price along with high-quality work delivered on time. Looking to hear from you soon, Thanks & Regards, Leo,
$30 CAD 7 päivässä
4,9 (19 arvostelua)
3,6
3,6
Käyttäjän avatar
I have created a complete formula/code in google sheet for the conditions stated. Please contact me ASAP. Thank you :)
$140 CAD 2 päivässä
5,0 (1 arvostelu)
2,8
2,8
Käyttäjän avatar
Hello My name is Abbas Hamdani.I'm a Microsoft Certified Excel Expert having 6+ Years’ experience, I can help you with any kind of task as follows: Cell function (Custom or Excel's) VBA/MACRO User forms Charts Pivot Table Excel Dashboard Apply formulas/Advance Filter  Vlookup / Hlookup Countif / Countifs Sumif / Sumifs Data Validation Conditioning Formatting Dropdowns Google Sheets That's just a limited summary, anything can be done using Excel.
$80 CAD 2 päivässä
5,0 (1 arvostelu)
2,3
2,3
Käyttäjän avatar
Hi, My name is Soufiane. I'm an engineer from CentraleSupelec, a top french engineering school. I have two and half years experience in consulting, and worked on developping cost models for regulated services, especially in the telecom sector. I could help with the problem you are facing. It would take me about 1hour to complete the task. I look forward to hearing from you. Kind regards, Soufiane
$50 CAD 1 päivässä
5,0 (2 arvostelua)
0,5
0,5
Käyttäjän avatar
Hello dear client, I can complete the task as requested using the video for guidance and filling your Google sheets. kindly send me a message for further discussions. Regards, Purity
$30 CAD 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
What you looking is a combination of lookup functions with IF function. Basically what would be needed is to have both databases (the one already organized and the one you need fixing) into excel. You can have both a query's or as tables depending on the size. You'll need to mix the look up functions that will match the 2 different 3 digits to the 0 and 1 that determines moblie or landline. I geninuly don't know how to explain it textually but good options would to try with the =Xlookup() , =MATCH() , =IF() and XMATCH()= That is one way to look at the problem. The other approach would be to use clean up functions to separate the NPA and NXX (according to the abrivation on your video) and then use xlookup and match, but this could get messy depending on your database file type. I've got good knowledge on using these functions. Don't have any prior job experience to vouch for me though. I'm open to any doubts you might have if you consider me.
$45 CAD 4 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
I can do that for you. I am a experiencied Excel professor. You can inspect if everithing is ok with a random check over the data before closing the project.
$50 CAD 1 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
- will you be providing the list of mobile number and landline prefixes to generate the label ? - row count ? - deadline ?
$30 CAD 7 päivässä
0,0 (0 arvostelua)
0,0
0,0
Käyttäjän avatar
Hi, I have carefully read your discription and watched your video about your project. It is a very easy task! I am ready to start your work right now. I can do this number source confirmation task fastly with 100% perfection without making any small mistake. I have 4 years of experience in this field. Also I have all your required skills and strong command of excel. I always give my 100% efforts in my work to produce a speedy and high quality work output to make my clients happy and come back to me repeatedly for their future projects. Thanks in advance! I hope we will discuss further on this project soon and feel free to ask me if you have any questions through the chat box!
$75 CAD 3 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan CANADA lippu
Mactier, Canada
0,0
0
Maksutapa vahvistettu
Liittynyt kesäk. 30, 2021

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.