Averaging data on inserted rows in Excel
Closed
kurugfrancis
-
Updated on Oct 24, 2019 at 07:23 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 17, 2019 at 11:33 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Dec 17, 2019 at 11:33 AM
Related:
- Averaging data on inserted rows in Excel
- Transfer data from one excel worksheet to another automatically - Guide
- Number to words in excel - Guide
- Tmobile data check - Guide
- Marksheet in excel - Guide
- Insert gif in excel - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 24, 2019 at 11:53 AM
Oct 24, 2019 at 11:53 AM
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
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 29, 2019 at 01:01 PM
Oct 29, 2019 at 01:01 PM
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
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Oct 31, 2019 at 12:53 PM
Oct 31, 2019 at 12:53 PM
Hi Kurug,
Uhm, no not quite. So let me rephrase:
4. Can you post your code?
5. Just checking here: Columns used are from A to AO and the averages are in every 5th column so E, J, O ... etc..
6. What you presented here is a single cell (AL1540), but we will have 8 averages. Going from your given cell, do you want to go down (cells AL1540 to AL1547) or to the right (cells AL1540 to AS1540)?
Best regards,
Trowa
Uhm, no not quite. So let me rephrase:
4. Can you post your code?
5. Just checking here: Columns used are from A to AO and the averages are in every 5th column so E, J, O ... etc..
6. What you presented here is a single cell (AL1540), but we will have 8 averages. Going from your given cell, do you want to go down (cells AL1540 to AL1547) or to the right (cells AL1540 to AS1540)?
Best regards,
Trowa
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
552
Nov 4, 2019 at 11:34 AM
Nov 4, 2019 at 11:34 AM
Hi Kurug,
You can use any free file sharing site like http://ge.tt, to upload your file there and then post back the download link. Always be careful with sensitive data.
Best regards,
Trowa
You can use any free file sharing site like http://ge.tt, to upload your file there and then post back the download link. Always be careful with sensitive data.
Best regards,
Trowa
Oct 24, 2019 at 03:38 PM
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.
Oct 24, 2019 at 04:20 PM
Oct 28, 2019 at 12:29 PM
Oct 28, 2019 at 03:43 PM
Now 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.
Oct 28, 2019 at 04:33 PM