Hello,
I want to repeat the average(=AVERAGE(A2:N4)) 3 times or n number of times as shown in the sheet. How many times, i.e. n is decided by the number of rows in a particular group(Eg: rows 2,3,4 is in one group, rows 5,6 is another group).
Kindly help me.
How to install your new code
- Copy the Excel VBA code
- Select the workbook in which you want to store the Excel VBA code
- Press Alt+F11 to open the Visual Basic Editor
- Choose Insert > Module
- Edit > Paste the macro into the module that appeared
- Close the VBEditor
- Save your workbook (Excel 2007+ select a macro-enabled file format, like *.xlsm)
Please Login or Register to view this content.
In O2 Cell
=AVERAGE(A2:N4)*MergedRows(A2)
Drag it down...
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
A shorter version of code
Please Login or Register to view this content.
H
THANK You.
I tried.
I am sorry, it didn't work. Isn't that possible to solve it only with formula?
One supporting column was created
if it is not you are looking for attach sample file with desired result
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Can I ask why you're wanting to use merged cells at all? You don't seem to be doing anything special inside those cells. Why not kill them and make the rows wider if you just want some extra space?
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Oopss... Mis Interpreted your question
Here is the revised solution
Please Login or Register to view this content.
In O2 Cell
=IFERROR(AVERAGE(Merged(A2,N2)),O1)
Drag it down...
Refer the attached file
Hi everyone,
I got solved it. All suggested methods worked. Great many thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks