Find Jobs
Hire Freelancers

Filtering a fluctuating measuring value by creating average

$10-30 USD

Cerrado
Publicado hace casi 6 años

$10-30 USD

Pagado a la entrega
Hi I´m just a private person wanting to present temperature measuring values in a diagram. Every value in the diagram are supposed to be created by displaying the actual measuring value or by creating a sum of n measuring values and divide the sum by n. if the A column contains measuring values, I would like that column B shows values created by creating a sum of n elements from A and then divide them by n As an example: A1=9,2 C1=5, then B1=Sum(A1 through A5)/C$1 and then >>>> B2=Sum(A2 through A6)/C$1 and so forth (I haven´t yet managed to get the indirect instruction to solve that for me)
ID del proyecto: 17132065

Información sobre el proyecto

13 propuestas
Proyecto remoto
Activo hace 6 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
13 freelancers están ofertando un promedio de $24 USD por este trabajo
Avatar del usuario
Hi, I'm happy to write that formula for you. You are right. You will need INDRIECT. I will explain how it works. Regards, Balint
$25 USD en 1 día
5,0 (91 comentarios)
7,0
7,0
Avatar del usuario
Hello, I’m an Excel expert and I would like to help you with your project. Please send me a message so that we can discuss more.
$25 USD en 0 día
4,9 (259 comentarios)
7,0
7,0
Avatar del usuario
Hi, I understand the project requirements and willing to start as soon as possible. Kindly share the details and I will deliver with high quality. Looking forward to work with you. Thanks & Regards Khushi India
$30 USD en 1 día
4,8 (244 comentarios)
7,0
7,0
Avatar del usuario
Greetings! Being a full time freelancer working exclusively on Excel based projects, I work on Excel based functions and formulas every single day. The requirement specified is very straightforward. Please share the workbook - I will include formula and share it back immediately. I have 18 years experience in using Excel as part of my daily work life. Over the last 24 MONTHS , I have spent at least 250 HOURS on automation in Excel every month. Have a Great Weekend! Srinivasan Krishnamoorthi
$10 USD en 0 día
5,0 (140 comentarios)
6,5
6,5
Avatar del usuario
Hello, I can either create a formula to solve this problem or if there is a lot of data, then I would suggest a macro that will do the same, as formula solution must use so called volatile formulas (for example INDIRECT is one of them, but also other volatile formula will need to be used on top of that), what means that they are always recalculated on any change in workbook (not a concern for smaller data sets). Best Regards
$30 USD en 1 día
5,0 (50 comentarios)
4,7
4,7
Avatar del usuario
Hello there, I am an excel analyst with more than 6 years of experience working with clients across the globe on data analysis in excel and other similar tools. I can do this easily. Please ping for further details. Best, Yash
$80 USD en 1 día
5,0 (6 comentarios)
4,3
4,3
Avatar del usuario
Hi, I am a chemical engineer and I have over five years experience in using Excel at an advanced level (complex formulas, array formulas, pivot table and charts, macros and VBA scripts, automatic calculation sheets, automatic simulators and charts drawing) as an Industrial Engineer at Michelin Romania. I am always keen to improve my work quality and productivity and, to achieve these goals, I made complex Excel sheets to automate my tasks and eliminate errors. I will be pleased to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$20 USD en 1 día
5,0 (6 comentarios)
3,1
3,1
Avatar del usuario
Hi I am expert and can do Filtering a fluctuating measuring value by creating average Thank you
$10 USD en 1 día
5,0 (5 comentarios)
2,5
2,5
Avatar del usuario
Hello, I can help you with this diagram. It's a simple work so I will ask a little amount so I can promote my work. If you want to know more about me or how I'd the project please contact me. Thank you very much for your time
$15 USD en 1 día
5,0 (8 comentarios)
2,6
2,6
Avatar del usuario
Hello! Try this on cell B1: =SUM(INDIRECT("A"&ROW(A1)&":A"&ROW(A1)+$C$1-1))/$C$1 Then copy it below, which means that B2, B3, b4 will have: =SUM(INDIRECT("A"&ROW(A2)&":A"&ROW(A2)+$C$1-1))/$C$1 =SUM(INDIRECT("A"&ROW(A3)&":A"&ROW(A3)+$C$1-1))/$C$1 =SUM(INDIRECT("A"&ROW(A4)&":A"&ROW(A4)+$C$1-1))/$C$1 And so on
$10 USD en 1 día
5,0 (1 comentario)
1,1
1,1
Avatar del usuario
HI, I'd be more then happy to help you with your formulas, it will be an easy task to do and I'll explain how I did it and how it works. I'm new to freelancer but have more then 10 years experience with excel and macros. If you need to discuss anything please contact me using chat. Thanks Chris
$10 USD en 1 día
5,0 (1 comentario)
0,6
0,6
Avatar del usuario
Hello, Sir Weebside Inc is a professional service who will provide freelancer service to worthy clients like you. I can prove to be best writer and will provide you High-Quality Product with 100% Delivery Rate, 100% Satisfaction. Having Expertise in Academic Writing, Technical Writing, Articles / Blog and Report Writing made me capable to bid here.
$25 USD en 1 día
0,0 (0 comentarios)
0,2
0,2

Sobre este cliente

Bandera de SWEDEN
Sweden
0,0
0
Miembro desde jun 8, 2018

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.