Excel help w/Formula

$10-30 USD

Completed

Posted

almost 6 years ago

$10-30 USD

Paid on delivery

I have a spreadsheet, 1st column is dates & time, 2nd and 3rd column are numbers. I want to a) average the data in columns 2 & 3 when the date in column 1 matches a date in a column I've made somewhere else; I also want to find the min and max for the column 2 & 3 data. The data have been gathered every few minutes. I want to graph as avg, min or max per every 24 hour period. I've been trying averageif and averageifs and can't get it to work. Seems like dmin and dmax might work if I put the data in a table, but that is beyond what I've learned. I have a spreadsheet of what I want to end up where I went through and manually averaged each 24 period for 2 weeks of data... but I have 2.5 years of data that I really want to look at, and I need a way to use a function for that many 24 hr periods.

Excel

Project ID: 17252881

About the project

17 proposals

Remote project

Active 6 yrs ago

Looking to make some money?

Email address

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:

@sevillajk01

hi! let me help you with your project. Can you give me your sample data so that I can work it on for you. thanks.

$25 USD in 0 day

4.9

(38 reviews)

4.9

17 freelancers are bidding on average $26 USD for this job

@shafaqat11

Hello Sir, Thank you for posting the project. My key skills are relevant to this project. I have huge experience in this area. I can do this project very efficiently. Thanks so much! Shafaqat Ali

$25 USD in 1 day

4.9

(94 reviews)

6.1

@archanaoswal

I have excellent command on MS Excel formulas. I have completed complex projects in Excel before . For instance - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile

$40 USD in 1 day

4.8

(81 reviews)

5.8

@haleem0786

i can do this. i have good command over Ms excel especially pivot table, chars, advance formulas, formatting etc. Please review my profile and inbox me. Thanks

$35 USD in 1 day

4.9

(28 reviews)

4.2

@krishu7

Hello, I am Pooja Rohra, Computer Instructor and Manager in reputed firm. I have plenty of experience doing MS office work. I have read you job post and feel fit for such job. Please consider me, I can help. Thank you

$25 USD in 1 day

5.0

(1 review)

2.4

@REDFEATHERART

Hello, I have vast experience working on excel spreadsheets. Certainly, I am the best person to help you in creating excel formula for all your needs.

$25 USD in 0 day

5.0

(2 reviews)

1.6

@mickokharisma

I use excell in my daily work at office, doing some counting on Customer Service activity. Hope my experience can be match with your need. Thank you.

$25 USD in 1 day

0.0

(0 reviews)

0.0

@Adney11

I have Excel Experience of over 8 years now, and use it daily for making reports and statistical graphing. A well organized color coded sheet will be delivered to you within a day, if you choose to employ me.

$20 USD in 1 day

0.0

(0 reviews)

0.0

@richagupta7274

I assure you the quality of work will be great. Relevant Skills and Experience M a fresher. I have no experience.

$20 USD in 1 day

0.0

(0 reviews)

0.0

@Brashbala

creating formulas in excel is bit easy, we need to understand functionality of each formula and then have to make loop of them, I can do it for you in a day. If the size of data is huge then we need to split the data in to different file. If you want to done this immediately with 100% accuracy , kindly contact me. I am having 10 + years of experience in excel.

$25 USD in 1 day

0.0

(0 reviews)

0.0

@vvh007

I can provide 2-3 options to meet your requirement. We can go ahead with the one you choose. I have done similar sheets earlier with complex formulas and confident of meeting the requirement

$15 USD in 1 day