ambily chacko
New Member
I have a panel data of 80 companies and i need to compute the peer average of each company for 2011 to 2020. can any one help me
MY DATA IS MONTHLY DATA FOR 63 FIRMS FOR 10 YEARS..I NEED TO COMPUTE THE AVERAGE OF EACH FIRM IN A YEAR .i. e CONVERTING MONTLY TO YEARLY FOR THE WHOLE PANEL...IN THE FILE RESIDUAL VALUE FOR D2 TO D12 , THEN D13 TO D24 ETC ... PLZ HELP
[/QUOTe
Thankyou so much sir...that was of much help
i apologize for breaking the rules even though i had no intention to do the same..
Thankyou so much sir for the timely help..Similar to vletm's but since you seem to be wanting averages of financial years which begin Apr 1st, I've added a column (fYr) to your data which takes 3 months off each date, and created a pivot table using those dates. I've highlighted the 2 sample averages you wanted.
Thankyou so much sir for the timely help..
Thank you so much for your timely helpIn the attached, two offerings, both based on the green shaded cells' formulae in columns N:W:
1. A pivot table at cell Z7
2. A single cell formula in cell Z27
Both agree with the manually calculated values highlighted in orange.
Thank you sirambily chacko
Something like this?
You can do Your selections with Slicer.
> You've still skipped my #4 reply question <