Find Jobs
Hire Freelancers

Complex excell formula needed

$30-250 USD

Completed
Posted over 10 years ago

$30-250 USD

Paid on delivery
Need someone to take the data marked in yellow on the left Andy produce values marked in green on the right. This could be done with excel formula or macro. I have large formulas of data that I'm looking to apply the formula too. [login to view URL]
Project ID: 5328212

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
Dear sir, Complete at >>>>>>> [login to view URL] It's easy work for counting word on the Green text for how many time it appear on the Yellow. Can be done easily in NORMAL Excel formula. I can complete it right now for you. Kind regards, LY
$30 USD in 0 day
5.0 (4 reviews)
1.9
1.9
20 freelancers are bidding on average $71 USD for this job
User Avatar
Hello - 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 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
$35 USD in 1 day
5.0 (820 reviews)
8.9
8.9
User Avatar
VB, VBA and Databases expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check https://www.freelancer.gr/projects/Data-Processing-Excel/data-translation-excel.html and feedback at https://www.freelancer.gr/u/paris2785.html I can start right away. For any questions, please let me know. Paris
$70 USD in 1 day
4.9 (353 reviews)
8.0
8.0
User Avatar
Hi, I will be happy to help you with this. Can do it quickly with formulas or with a macro. If a formula solution is preferred then I think you should know that the formulas will have to be 'array' formulas. Also a helper column might be needed
$95 USD in 1 day
4.8 (256 reviews)
7.7
7.7
User Avatar
Hi, I can do this for you. Please send a massage in the PMB for details.......Best Regards flashsaiful
$210 USD in 3 days
4.9 (152 reviews)
6.7
6.7
User Avatar
I am an ACCA , APA and Mcom finance having full command over advance excel the formula would be: =sumproduct(isnumber(search(....................................................... i can easily do this job, only create milestone when you will receive your work done 100% ready to do this job at reasonable price thanks
$33 USD in 3 days
4.9 (106 reviews)
6.8
6.8
User Avatar
Hello there. I have high Maths, Excel and Visual Basic skills with great professionalism. I study electronics and computer engineering at Oporto university and I'm looking for work to fill the blanks on my schedule. I have plenty of experience with this type of work and I would develop a macro to go through the "Current Data" and obtain both the unique values and the number of times they appear as a result. Also, if you're interested on my work, could you consider hiring me directly from my profile page for an hourly project instead of this fixed price project for the same bid amount? The difference is on the fees we both will pay to Freelancer.com. In fixed price projects both the employer and the freelancer pay a lot higher fees than in hourly projects. I would gladly appreciate this opportunity to work with you. Best regards, Bruno Martins
$30 USD in 1 day
5.0 (59 reviews)
5.4
5.4
User Avatar
EXPERIENCED DEVELOPER.... PLEASE CHECK MY BADGES, PROJECTS AND REVIEWS and ensure yourself that I can finish this job very well. As you can see I am 1 of 4 freelancers with SQL Level3 (100%) badge, which should tell you something. I am not sure do you want to use some kind of SOUNDEX search on Excel, or it is just a type error...
$45 USD in 3 days
5.0 (4 reviews)
4.5
4.5
User Avatar
Eamon, I designed dashboards, reports and spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites, with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. Would normally provide samples to let you judge my skill for yourself but you made this a "restricted" project. Which means you have to send me a Private Message first before I can send you an attachment. I can work under a Confidentiality and Non-Disclosure Agreement if required, and start as soon as you pay the Milestone into the site. You have not said when the work has to be finished? I have allowed three days to produce the revisions, which will enable you to view the work in progress and make any changes as you want in that period. But if you need it faster that will not be an issue, as I have completed numerous assignments at equally short notice. Hope you find this of interest and look forward to hearing from you Bob Allen-Turl
$117 USD in 3 days
4.5 (11 reviews)
4.5
4.5
User Avatar
I have the result. How can I can it send you. I can do the work fast and for very low cost. I'm new here and want to promote myself as frelancer
$35 USD in 1 day
5.0 (6 reviews)
3.5
3.5
User Avatar
hello sir warm greetings. I have created difficult custom macros for my clients few days ago. Please check my review. Willing to work on this. please give further details regards
$80 USD in 3 days
4.9 (7 reviews)
2.7
2.7
User Avatar
Hi. I have ample experience in handling Excel formula, VBA and macro. Please let me know the calculation that you would like to implement so that i can create the formula accordingly. Hoping to start working soon....
$35 USD in 2 days
4.8 (7 reviews)
2.0
2.0
User Avatar
Hi there I'm ready to start this task right now if u interested pls reply asap Regards Sandeep SIngh
$50 USD in 1 day
4.9 (4 reviews)
2.0
2.0
User Avatar
Hello, I am interested to work on your project. I have skills on MS Word, Outlook, Access, Excel Macros and Photoshop. I have trained nearly 200 head counts on Excel in private sector. And i am ready to do the job at your cost. Please let me know if i am eligible for this job. Thank you, With Regards, V. Sivanath
$88 USD in 1 day
5.0 (1 review)
1.3
1.3
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$155 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, This is a simple task for me. I have done lot of work like this. Your work will get completed within a day. This formula is used to find out the number of times, a particular word has repeated: =SUMIF(A$1:A$9,C1,B$1:B$9) This is just a sample. The main challenge is to find out the distinct words in the list. Please share the full details and assign the project. You task will get completed without any problem. Thank You. Regards, Nayak.
$60 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
La propuesta todavía no ha sido proveída
$35 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hallo, I use Excel very often and everyday. I work at the Department of Statistics of the University of Calabria (Italy) I already have the solution of your problem. ;-) If you want, I can give you other information. Best regards Luciano
$30 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
Waltham, United States
5.0
43
Payment method verified
Member since Jun 18, 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.