Excel VBA for data manipulation

$30-250 USD

已取消

已发布

将近 8 年前

$30-250 USD

货到付款

I need VBA for excel. I have 6 columns; Date, Time, Open, High, Low, Close, Vol All I need to do is find the; 1. MAX value from column D (High) 2. MIN value from column E (Low) FOR every hour and day from column A (Date) So I also need Open value from column C from the first minute of each hour Open Price, Max Price, Min Price for every hour of every day and move this result into another sheet in sequential order by date/time. Here is a screenshot for an easier understanding. [login to view URL] And here is the link to the file: [login to view URL] BTW, column A which has all the dates is not in 'date' format for some reason. It is shown in [login to view URL] but in plain general form.

Excel

项目 ID: 10801794

关于此项目

4提案

远程项目

活跃8 年前

想赚点钱吗？

电子邮箱地址

在Freelancer上竞价的好处

设定您的预算和时间范围

为您的工作获得报酬

简要概述您的提案

免费注册和竞标工作

4威客以平均价$79 USD来参与此工作竞价

@cgullapalli

Hi, I am good at Excel and vba. Looking forward to work on this project and discuss further. I have seen the attachment of snapshot.

$150 USD 在1天之内

5.0

(169条评论)

6.3

@tawakalgeek

lets get the data cleanup done in few mins. do check my work experience and how I've been rated by employers :) Thanks

$40 USD 在0天之内

5.0

(26条评论)

6.0

@Tanmoy236

I am extremely good with excel as it is part of my daily professional work. I am fast accurate and at the same time understand the value of quality and deadlines. I have already done 81 works on Freelancer where majority of the works I got all 5 star rating and the employer was extremely happy with my work. I believe I can do a fantastic work for you if you provide me the opportunity. About me: I am a Business (BBA) Graduate with major in FINANCE and MARKETING along with 4 years of experience in Sales, Marketing and Copy writing. Currently I am working for a Multinational Telecommunication Company in the Marketing and Analysis Department as an Assistant Manager. My profound academic knowledge along with my professional experience will significantly help to deliver the best work and therefore see a completely satisfied 'YOU' Thanks

$70 USD 在2天之内