missing 2 things on 'payroll generator' sheet

$10-60 CAD

종료됨

게시됨

약 4년 전

$10-60 CAD

제출할때 지불됩니다

I supervise a treeplanting business. This spreadsheet deals with people's individual tallies for each block on multiple days with multiple different prices per tree. The blocks are individual sheets (1-40). On the 'payroll generator' sheet, I have a dropdown menu to select the employee. This sums all there tallies from each sheet by day using this vlookup formula and an 'all days' sheet and a helper isle. =(IFERROR(VLOOKUP(A14&ROWS($C$14:C14),'All Days'!$A$1:$O8000,14,FALSE),0)) brings up the date =IFERROR(VLOOKUP(A14&ROWS($B$14:B14),'All Days'!$A$1:$O$8000,11,FALSE),0) brings up #trees planted =IFERROR(VLOOKUP(A14&ROWS($D$14:D14),'All Days'!$A$1:$O$8000,12,FALSE),0) brings up the price per tree All of that works great. 1. I want to ad something to the equation so that is only looks up entries between 2 dates which can be selected in the above dropdown menu ('payroll generator g1 and g2) 2. (less important) I want the results to be displayed in order of date instead of the current order by sheet Can somebody please help?

프로젝트 ID: 24660890

프로젝트 정보

10 제안서

원격근무 프로젝트

활동 중 4년 전

돈을 좀 벌 생각이십니까?

이메일 주소

프리랜서 입찰의 이점

예산 및 기간 설정

작업 결과에 대한 급여 수급

제안의 개요를 자세히 쓰세요

무료로 프로젝트에 신청하고 입찰할 수 있습니다

10 이 프로젝트에 프리랜서들의 평균 입찰은 $44 CAD입니다.

@schoudhary1553

Hello, I can help you with your project - I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Please visit : https://www.freelancer.com/u/schoudhary1553 I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. Kinds Regards, Sandeep

$80 CAD 3일에

4.9

(386 건의 리뷰)

8.1

@paris2785

Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel developer. According to your brief, you want to have an Excel application remastered so that the results between two dates are displayed and they are ordered by date. I will charge you $50* and can deliver within a day (we can discuss the milestones, I don't require any payment in front). I'm among the most experienced and skilled Excel and VBA developers on this platform. In particular, I am in the top 2% of the freelancers having completed over 360 projects successfully in less than 7 years, and I feel confident in achieving your task as well. I'm online from 7 am to 9 pm, Athens time (including weekends). I'm looking forward to working with you. Sincerely, Paris Pallas *My quote is indicative and may change after we discuss the tasks needed in detail.

$50 CAD 1일에

4.9

(264 건의 리뷰)

7.6

@rashedkhanrubel

Hi, I will make formula as per your requirement with good and professional quality without any error. Need to discuss more before start. I have completed more then 100 project within 8 months with 5 star review. You are gentle requested to see excel project sample in my portfolio here: https://www.freelancer.com/u/rashedkhanrubel. I will deliver the project within timeline with better quality. If you want to award me the project I'd be very happy to discuss deeply about your requirement and get started for you as soon as possible. Thanks! Rashed

$50 CAD 1일에

5.0

(194 건의 리뷰)

6.3

@dhanrajkarthick

Hi there, Gone through your requirement and yes b it can be done. I am a Microsoft Certified Professional in Excel and VBA as an Expert. Awaiting your message to discuss more. Regards, Karthick G

$40 CAD 1일에

5.0

(21 건의 리뷰)

4.5

@nblsoft

Hi there, I've already done that using your supplied workbook. Criteria from G1 and G2 is working and showing data from A1 to P1 between two dates. Sorting can be done if you initiate a chat for further details. Looking forward.

$20 CAD 1일에