Filtering a fluctuating measuring value by creating average

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

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.

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

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

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

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

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.

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

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

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

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

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.