VBA code to Find Average

[pankaj25]

Hi All,

I have table data as below. There are 3 column.
Vol1
CNT
CNT_WISE_AVERAGE

I want to write a VBA code to display the average value from "Vol1" column, based on "CNT value, and put the average value in "CNT_WISE_AVERAGE" column.

There are nore then 5000 rows, having CNT values upto 80.

Could anyone please help on this.

Please find attached excel for sample data.

 

[pankaj25]

Never mind. Found the solution. Thanks...