missing 2 things on 'payroll generator' sheet

$10-60 CAD

Closed

Posted

about 4 years ago

$10-60 CAD

Paid on delivery

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?

Project ID: 24660890

About the project

10 proposals

Remote project

Active 4 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

10 freelancers are bidding on average $44 CAD for this job

@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 in 3 days

4.9

(386 reviews)

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 in 1 day

4.9

(264 reviews)

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 in 1 day

5.0

(194 reviews)

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 in 1 day

5.0

(21 reviews)

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 in 1 day