Find Jobs
Hire Freelancers

Excel Work - Data - Format Cells issues

$10-30 USD

Complété
Publié il y a presque 10 ans

$10-30 USD

Payé lors de la livraison
I have an excel file (attached) with market data (numbers only) without cell formatting. That's why i can not make an automated calculation for 2 columns. All the numbers are in different (text) format such as 312K, 25.5B, 15%, 68.2, $18, £26 . etc. , I have tried to use Substitute function in 4-5 steps to clear the extra characters from them but wasn't successful with "%". 1, I need you to format my cells or create a new usable database from source with function. 2, I need 2 automated calculating columns : Actual - Consensus and Actual - Previous , If source data cell is empty... results must be a text: "DATA" 3, Autocomplete function need to be compatible for the growing database. Thank you
N° de projet : 6250558

Concernant le projet

20 propositions
Projet à distance
Actif à il y a 10 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
Hi, I already formularized for column I and column J. Now got 312K, 25.5B, 15%, 68.2, $18, £26 also can calculated the amount. I have skill in Microsoft Excel, formula for Vlookup, If, And, Or, Sumif(s), Countif(s), and how to combine multiple formulas and use Sort, Filters, Data Validation, Conditional Formatting, Pivot tables and also Excel [login to view URL] hired by you I will deliver my best work at high standard. I look forward to being hired by you for your jobs
$20 USD en 1 jour
4,7 (43 commentaires)
4,6
4,6
20 freelances proposent en moyenne $20 USD pour ce travail
Avatar de l'utilisateur
Hello Sir - Your file is ready here for review. About me - I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and very high completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you award me the project. Thanks, Jay
$30 USD en 1 jour
5,0 (816 commentaires)
8,8
8,8
Avatar de l'utilisateur
Hello. Your problem have solved. I've converted K = multiple 10^3, M = multiple 10^6, B = multiple 10^9, convert txt to number 15%, 68.2, $18, £26. I can share file if you're interested. Best regards
$15 USD en 0 jour
5,0 (167 commentaires)
7,0
7,0
Avatar de l'utilisateur
Greetings! I can do the job but it will take a couple of steps. Let's discuss Thanks
$19 USD en 1 jour
4,8 (62 commentaires)
6,3
6,3
Avatar de l'utilisateur
Hi sir, I can start now and I'll recreate this file for you in max 20 minutes, but when you'll insert the data into, you will have to insert without all those simbols, if you want it to work fine.... Thank you Denisa Elena
$30 USD en 0 jour
5,0 (24 commentaires)
5,2
5,2
Avatar de l'utilisateur
Hello, I am m.s of systems engineering and b.s of industrial engineering and I have passed many related courses such as mathematics, probability, data analysis and statistics that statistics is the base of my major, confidence interval (that I made a spreadsheet for it too), analysis of variance, regression (that I passed also econometric that is advanced regression), I can do MANOVA analysis, Hypothesis tests (compare means, variances, correlations..), descriptive analysis, cross-tabulation and… that are ordinary task in statistical analysis, I analyzed many types of questionnaires here including nominal, ordinal, scale and also open-end questions, I have good command of English too). I have lots of experience with softwares such as Minitab SPSS, SAS, excel,
$25 USD en 1 jour
4,8 (75 commentaires)
5,5
5,5
Avatar de l'utilisateur
I can accomplish the task and deliver result as you want. I have some questions though to formulate my algorithm. Please contact me to help you better. I have over 6+ years of experience in using excel. Very cool and interesting problem. It will be fun to work and solve this.
$15 USD en 1 jour
4,9 (12 commentaires)
3,4
3,4
Avatar de l'utilisateur
Hi. I fully understood your job description. I'm really interested and ready to work as soon as possible. I hope you consider me as part of your staff. I'm a fast-learner, speed typist, flexible and dedicated. I am looking forward to your good response. Thank you and God bless
$25 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hello, I would really like you to consider me for this job. I studied four years computer science, I have an Oracle Diploma and an ECDL one. I am good at working in Microsoft Excel and I think I can help you with formatting your cells. My level in English is very good, I am available online anytime you wish to contact me. Also I am trained to deliver the best results and to work professional. I am looking forward to hearing from you. Thank you for your consideration, Andreea Maria Cotoros
$20 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hello, I found the way to get what you are looking for, if you want, contact me and I will show you a print screen.
$15 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
As Far as understand the requirements. You want to convert M , K % into their respective calculations for formulas to work. and secondly you want your "Actual - Consensus" and "Actual - Previous" columns to work, in case of empty column there shows "DATA". I am working in Excel for many months and years. it is an easy work, I suppose that this can be completed within few hours, if you want any other thing just contact me and we'll discuss it further before we start. Thanks Regards Muhammad Adnan
$20 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
hello , i can make your work by perfect quallity , and i can make any edit in it if you want , and the Communications with me is very easy
$10 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
A proposal has not yet been provided
$25 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hi. I am newbie. I am expert in typing, data entry / data researcher, excel, web scrabing and writing. For your info I have experienced as a PA for above 15 years. Award me your project than I will show you my excellent services with the excellent project result. Regards!
$20 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
A proposal has not yet been provided
$25 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I am doing things like this on daily basis - I anyway completed it just now - so you can have it quickly
$15 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
Hi, I propose to write a VBA that you can call any time you want. 1. Please provide the format transition example. 2. Understood. Should the result has the original format like 312K, 15%. 3. The VBA can be called any time. Thanks.
$10 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0
Avatar de l'utilisateur
I can do that for you, the results will be automated when you fill the source column. I often operate formulas like that when tabulating a research data. Well, I am a college anyway. So, I have a couple of months free now, so I can do it fast and good for you. If you want to ask me more about how I will do my job, just feel free to contact me. facebook: "Firmananda Rahmandika Lazuardi". I am an Indonesian, so I am sorry for my bad English. Sincerely, Firmananda R L
$15 USD en 1 jour
0,0 (0 commentaires)
0,0
0,0

À propos du client

Drapeau de UNITED KINGDOM
London, United Kingdom
5,0
107
Méthode de paiement vérifiée
Membre depuis juil. 19, 2012

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.