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.
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.
Bu iş için 19 freelancer ortalamada $24 teklif veriyor
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
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), pin Daha Fazla
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
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.
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.
Hey, I'm interested and ready for work on your project. Please send me a message so that we can discuss more.
I assure you the quality of work will be great. Relevant Skills and Experience M a fresher. I have no experience.
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 Daha Fazla
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 i Daha Fazla
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
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.