Suljettu

Filtering a fluctuating measuring value by creating average

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)

Taidot: Excel

Näytä lisää: smoothing filter matlab, moving average statistics, moving average example, moving average filter matlab, exponential moving average formula, smoothing filter in image processing, moving average formula, weighted average filter, Hi I am a fast and experience data entry operator and I’m very interested in your job post involving data scrapping. I have g, hi we are a business that uses trucks to deliver things like building supplies, measuring value paper, average cost minute private chat, creating private wikipedia, calculate difference value pips moving average metatrader, creating private group ning, creating private tracker, creating private online forum, creating private tracker site, average job webcam shows, creating number columns based variable value html

Tietoa työnantajasta:
( 0 arvostelua ) Sweden

Projektin tunnus: #17132065

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

P0L

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 0 päivässä
(259 arvostelua)
7.0
kolosibalint

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 1 päivässä
(91 arvostelua)
7.0
khushh07

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 1 päivässä
(244 arvostelua)
7.0
ksriniravi

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 Lisää

$10 USD 0 päivässä
(140 arvostelua)
6.5
SShtv

Your task is clear to me and I am ready to solve it. I have a large and successful hands-on experience in processing and analyzing data in Excel, as well as visualizing the data and constructing information panels. As Lisää

$20 USD 0 päivässä
(53 arvostelua)
5.5
Taisho

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 INDI Lisää

$30 USD 1 päivässä
(50 arvostelua)
4.7
cyash61

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 deta Lisää

$80 USD 1 päivässä
(6 arvostelua)
4.3
afenache

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, Lisää

$20 USD 1 päivässä
(6 arvostelua)
3.1
Mfaisalshahzad00

Hi I am expert and can do Filtering a fluctuating measuring value by creating average Thank you

$10 USD 1 päivässä
(5 arvostelua)
2.5
JorgeBece

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 yo Lisää

$15 USD 1 päivässä
(8 arvostelua)
2.6
cranius

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 Lisää

$10 USD 1 päivässä
(1 arvostelu)
1.1
Walshie1987

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 ma Lisää

$10 USD 1 päivässä
(1 arvostelu)
0.6
Weebside

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% Lisää

$25 USD 1 päivässä
(0 arvostelua)
0.2