Find Jobs
Hire Freelancers

Excel Work - Data - Format Cells issues

$10-30 USD

Completed
Posted over 9 years ago

$10-30 USD

Paid on delivery
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
Project ID: 6250558

About the project

20 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 1 day
4.7 (43 reviews)
4.6
4.6
20 freelancers are bidding on average $20 USD for this job
User Avatar
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 in 1 day
5.0 (816 reviews)
8.8
8.8
User Avatar
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 in 0 day
5.0 (167 reviews)
7.0
7.0
User Avatar
Greetings! I can do the job but it will take a couple of steps. Let's discuss Thanks
$19 USD in 1 day
4.8 (62 reviews)
6.3
6.3
User Avatar
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 in 0 day
5.0 (24 reviews)
5.2
5.2
User Avatar
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 in 1 day
4.8 (75 reviews)
5.5
5.5
User Avatar
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 in 1 day
4.9 (12 reviews)
3.4
3.4
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I am doing things like this on daily basis - I anyway completed it just now - so you can have it quickly
$15 USD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
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 in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
London, United Kingdom
5.0
107
Payment method verified
Member since Jul 19, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.