Suoritettu

Excel macro for averaging data across a single column

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?

Taidot: tietojenkäsittely, Excel, Excel Macros, Visual Basic

Näytä lisää: excel macro move data existing cell, excel macro copy data column, excel macro enter data database, excel vba average function, excel macros app, macros applications in excel, excel average macro, worksheetfunction average range, vba average of range, vba average of variable range, excel macro average dynamic range, excel macro copy data windows application, excel macro paste data, excel macro web data read, excel macro cut data, excel macro returning data try, excel macro refresh data, excel macro oracle data entry, excel macro moving data cell cell, excel macro insert data textbox cells

Tietoa työnantajasta:
( 0 arvostelua ) College Station, United States

Projektin tunnus: #18551581

Myönnetty käyttäjälle:

daniyal3214

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 Lisää

$50 USD 1 päivässä
(43 Arvostelua)
5.3

9 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

MimiFL

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 Lisää

$61 USD 0 päivässä
(439 arvostelua)
6.9
bilalmaher053

hey, i can do this using macro, can wen discus more in chat?

$100 USD 3 päivässä
(158 arvostelua)
6.1
dvcontact

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. For Lisää

$150 USD 3 päivässä
(40 arvostelua)
5.9
TechnoGuruu

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 Lisää

$99 USD 3 päivässä
(56 arvostelua)
5.4
lightingdavid

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 0 päivässä
(17 arvostelua)
4.9
HSanatomba

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 3 päivässä
(0 arvostelua)
0.0
MichealSMoreno

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 3 päivässä
(0 arvostelua)
0.0
freshprinceuc

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 3 päivässä
(0 arvostelua)
0.0