Tamamlanmış

Excel help w/Formula

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.

Beceriler: Excel

Daha fazlasını gör: excel help formula, excel macro paste formula, excel cidr format formula, excel formula download, excel formulas pdf, microsoft excel formulas list with examples, basic excel formulas pdf, excel formulas if, excel formulas cheat sheet, advanced excel formulas, advanced excel formulas pdf, excel vba paste formula macro, convert excel html forms formula, excel payment number formula, excel monthly payment formula, excel vlookup add formula, excel help clas, excel lookup add formula, excel range rank formula, visual basic excel help replacing values

İşveren Hakkında:
( 1 değerlendirme ) Corvallis, United States

Proje NO: #17252881

Seçilen:

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.

%selectedBids___i_period_sub_7% gün içinde 25%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(4 Değerlendirme)
1.7

Bu iş için 19 freelancer ortalamada $24 teklif veriyor

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(313 Değerlendirme)
7.2
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(70 Değerlendirme)
5.9
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(91 Değerlendirme)
5.7
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), pin Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(38 Değerlendirme)
5.1
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(13 Değerlendirme)
3.5
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.

in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(2 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
kashmirmzd60

Hey, I'm interested and ready for work on your project. Please send me a message so that we can discuss more.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
richagupta7274

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 i Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0
in %bids___i_period_sub_35% gün içinde25%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(0 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0