Find Jobs
Hire Freelancers

Excel macro for averaging data across a single column

$30-250 USD

Completed
Posted about 5 years ago

$30-250 USD

Paid on delivery
I need to normalize treatment data points compared to the average of each individual's normal values. Please see column E in spreadsheet for the example formulas. I would like the results to appear in sheet 2. I could do this for all columns, but there are over 400. Can a macro even be generated to do this?
Project ID: 18551581

About the project

9 proposals
Remote project
Active 5 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
I am a professional Data Analyst and Excel holding years of experience in utilizing advance level tools and functions of Excel including Macro and VBA to perform various automation, analysis and calculations. I will be happy to discuss in detail.
$50 USD in 1 day
4.7 (43 reviews)
5.3
5.3
9 freelancers are bidding on average $88 USD for this job
User Avatar
Hi, yes this can be automated, even 400 columns. If you are interested in working with me, please attach a sample sheet, so i can see how file looks like when there are multiple columns, and not just a single one as in attached example. Basically i need to see how the structure changes between columns. Thanks, Milan
$61 USD in 0 day
5.0 (439 reviews)
6.9
6.9
User Avatar
hey, i can do this using macro, can wen discus more in chat?
$100 USD in 3 days
4.8 (158 reviews)
6.1
6.1
User Avatar
Hi, You may not select the right candidate without knowing what your project on building an Excel macro to normalize treatment data points compared to the average of each individual's normal values will look like. Fortunately, I can complete a part of your job before you award the project. I can tell you about how highly experienced and multi-talented I am. But I’m sure you need more than that. In less than 24 hrs, I can complete a sample part of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required! I’d love to discuss more about what would make this project a success for you. Can we have a quick chat? Thanks for your time.
$150 USD in 3 days
4.8 (40 reviews)
5.9
5.9
User Avatar
Hi, As per requirements I will develop VBA macro for you which will do the calculations as per sheet attached . I have expertise in Excel, formulas, Excel VBA and finished many such projects. I am new here on upwork but have 10+ years of technical experience. Quality work with high accuracy and 100% customer satisfaction is guaranteed. I am ready to work on this project now. Please give me this opportunity to work on your project. Thanks and regards, Mohan
$99 USD in 3 days
5.0 (56 reviews)
5.4
5.4
User Avatar
Hello. I have checked your project description carefully and i 'm clear. I'm sure i can do it in a few hours. I hope to work with you. Thank you.
$70 USD in 0 day
4.6 (17 reviews)
4.9
4.9
User Avatar
I can do it. I can do it. I can do it. I can do it. I can do it. I can do it. I can do it. I can do it.
$110 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear client. I've read your project description carefully and very interested. Let's discuss over chat and get started. Waiting for your reply. Regards.
$50 USD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Dear sir/madam, i am an expert in this type of your project. I want to work with you. I will offer you the best.
$100 USD in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
College Station, United States
0.0
0
Payment method verified
Member since Jan 18, 2019

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.