Related:
- Averaging data on inserted rows in Excel
- Insert row in excel when data changes ✓ - Forum - Excel
- Macro to insert row in excel based on criteria ✓ - Forum - Excel
- How to paste different data in alternate rows in excel - Forum - Excel
- Macro to insert rows in excel - How-To - Excel
- Merge rows if it meets criteria in Excel ✓ - Forum - Excel
2 replies
TrowaD
- Posts
- 2676
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- December 3, 2020
Hi Kurug,
With the given info it is impossible to help you. Could you provide more details?
1. Do you manually insert those rows?
2. Which column(s) of the inserted rows would you like to get the average of?
3. When we have the average, what do you want to do with it? Place it in a cell or show it as a message or ...?
These are just some questions that pops up in my head. If there is more relevant info, do inform us.
Best regards,
Trowa
With the given info it is impossible to help you. Could you provide more details?
1. Do you manually insert those rows?
2. Which column(s) of the inserted rows would you like to get the average of?
3. When we have the average, what do you want to do with it? Place it in a cell or show it as a message or ...?
These are just some questions that pops up in my head. If there is more relevant info, do inform us.
Best regards,
Trowa
TrowaD
- Posts
- 2676
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- December 3, 2020
Hi Kurug,
No worries.
Some more questions though:
4. Since you use a code to insert rows, I either have to know that the insertion part of the code is at the bottom (meaning, the inserted part is still selected) or I have to know the code (assuming you don't know how to alter your code).
5. There are 16384 columns and I'm pretty sure you don't use all of them. So how many columns do you use or how many averages do you want? No need to make the code do more than is needed.
6. Which range did you have in mind to place the averages?
That should do it.
Best regards,
Trowa
No worries.
Some more questions though:
4. Since you use a code to insert rows, I either have to know that the insertion part of the code is at the bottom (meaning, the inserted part is still selected) or I have to know the code (assuming you don't know how to alter your code).
5. There are 16384 columns and I'm pretty sure you don't use all of them. So how many columns do you use or how many averages do you want? No need to make the code do more than is needed.
6. Which range did you have in mind to place the averages?
That should do it.
Best regards,
Trowa
TrowaD
- Posts
- 2676
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- December 3, 2020
Hi Kurug,
Not sure if I fully understand what you mean, but you might be looking for the following function:
=STDEV.P(YourRangeHere)
If not, could you then post some sample data with the result you are after?
Best regards,
Trowa
Not sure if I fully understand what you mean, but you might be looking for the following function:
=STDEV.P(YourRangeHere)
If not, could you then post some sample data with the result you are after?
Best regards,
Trowa
TrowaD
- Posts
- 2676
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- December 3, 2020
Pretty cool. I followed your steps and got the same result as the STDEV.P function.
So I got confirmation that the mentioned function is the right one and you got confirmation that your post is followable :).
So I got confirmation that the mentioned function is the right one and you got confirmation that your post is followable :).
Subscribe To Our Newsletter!
What I actually want to do is that, I have a data which covers a number of countries and variables for the time period 1996 to 2016.
So I want to find the averages for each variable for every three (3) years. This will help me to use the average values for some analysis.
Thank you.
Hope to get your reply soon.
- Posts
-
2676
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- December 3, 2020
448Now in response to your questions,
1) I did not manually inserted the rows. I used a code.
2) I want to get the average for every fifth column of the inserted rows
3) I want to place the averages on a cell
I hope this answers your questions?
Thank you.