![]() |
To find Average
There is no such thing as row A. There is row 1 and column A. Why not just use the AVERAGE function. What do you want to average and where do you want the number to be placed? -- Don Guillett Microsoft MVP Excel SalesAid Software "Murali G" wrote in message ... Hello- There is a requirement in my project to find the average of values in a sheet. Values starts from A1 and goes till G20 (which keeps changing every month). For each row we have to find the Average. For example; A B C D -- -- -- -- 10 20 10 40 30 40 20 50 50 60 30 60 For Row 'A' we have to find the Average, similarly for 'B','C' and 'D'. Instead of doing manually is there any code to perform this task by writing a macro. Please let me know if you need any further details. Regards, Murali. G |
All times are GMT +1. The time now is 10:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com