Find Jobs
Hire Freelancers

Google Sheets Query Function Filtering Between Two Dates

$10-30 USD

Terminado
Publicado hace más de 5 años

$10-30 USD

Pagado a la entrega
Goal: #1: Using "Report" Sheet when a user types in the Start Date and End Date of data they need, the query will search the "Returns" sheet and display all the rows that fall between those two dates. #2: On "Report" Sheet in Cell B5, total Column G (Price) *Returns sheet will have an infinite amount of rows
ID del proyecto: 18646506

Información sobre el proyecto

14 propuestas
Proyecto remoto
Activo hace 5 años

¿Buscas ganar dinero?

Beneficios de presentar ofertas en Freelancer

Fija tu plazo y presupuesto
Cobra por tu trabajo
Describe tu propuesta
Es gratis registrarse y presentar ofertas en los trabajos
Adjudicado a:
Avatar del usuario
Hi there, I have 5+ years of experience in spreadsheet applications and programming. I have prepared a demo video of what your filter would look like ( [login to view URL] ), I could deliver the task in 10 minutes. Would love to help with your project. Please feel free to contact me to discuss further details. Cheers, Samer
$15 USD en 0 día
5,0 (9 comentarios)
3,8
3,8
14 freelancers están ofertando un promedio de $28 USD por este trabajo
Avatar del usuario
Hello, 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
$70 USD en 2 días
4,9 (366 comentarios)
8,0
8,0
Avatar del usuario
I have excellent command on Google Sheets and know how to write the formulas to filter data and find totals. I have completed complex projects before. For instance - Get live cyptocurrency data and create dashboard using coinmarket API - Upload and Manage Videos in Vimeo using JSON API in google sheets - Extract mails and attachments from gmail to google sheet and drive respectively - Twitter functionality like retweet, auto-tweet, and so on - Integrated Google Sheets, Forms and docs to create a dashboard and tracking system to track health data of individuals for a health care organization You can see the reviews of the same in my profile
$30 USD en 1 día
4,9 (104 comentarios)
6,0
6,0
Avatar del usuario
Hello I would be happy to help with your filtering issue. This would need a script inserted to the sheet so it listens out for the date range. Unfortunately this cant be done just by using conditional formatting, a script will be needed to do this automatically. I will be happy to implement this for you. I have over 10 years experience with excel/vba which Google sheets is based from. I look forward to working with you soon. Kind regards Steve
$30 USD en 1 día
5,0 (8 comentarios)
4,0
4,0
Avatar del usuario
Hello, I’m very interested in your job post involving these skills. I have good experience in data entry, web research, Google documents and MS Office. My typing speed is more than 50 words per minute. I believe my skills would be ideal for your project.I can dedicate 30 hours/week for your job, and my daily hours are negotiable. I’m very excited to offer my services for your job. Please feel free to contact me directly to discuss this position further. Thanks, Kadirul
$10 USD en 1 día
4,9 (6 comentarios)
1,2
1,2
Avatar del usuario
Hello I am a senior developer who can finish your project pefectly. I am ready to work for you. Best regards
$25 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I may not be understanding from your description but it sounds like something I could do for you in under 30 minutes. Maybe under 5. Can we talk specifics? If this is as quick as I think, I'll do it for $15 so you keep me in mind for future Excel needs.
$20 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
$25 USD en 3 días
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
This is what I do. I have created hundreds of google spreadsheets with complex formulas of exactly the type described. If you want any other functionality we can look into that as well. I'm just getting started on freelancer.com and I will work with you as much as needed to get this done right and to start off on the right foot. Thank you!
$23 USD en 1 día
0,0 (0 comentarios)
0,0
0,0
Avatar del usuario
I am an very expert on Google sheet, I could do your jobs in minutes, help me to build my portfolio and I could help you with your sheets problem with lower fee.
$15 USD en 1 día
0,0 (0 comentarios)
0,0
0,0

Sobre este cliente

Bandera de UNITED STATES
Kalamazoo, United States
5,0
19
Forma de pago verificada
Miembro desde ago 5, 2013

Verificación del cliente

¡Gracias! Te hemos enviado un enlace para reclamar tu crédito gratuito.
Algo salió mal al enviar tu correo electrónico. Por favor, intenta de nuevo.
Usuarios registrados Total de empleos publicados
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Cargando visualización previa
Permiso concedido para Geolocalización.
Tu sesión de acceso ha expirado y has sido desconectado. Por favor, inica sesión nuevamente.