D
Dastard
Well i m kinda new user of Excel and need a lil info regarding V
programing in Excel
My problem is that ( see the attachment ) . i have name Entries ( i
first column ) , their individual percentages ( in second column ) an
average of those individual percentages which belong to same category
differetiated only by last character of their names )
now just focus on second and third column , in this test scenario ,
have manually calculated averages using formula on individual cells bu
if my list goes on quite long almost 3000-4000 name entries . i
becomes hectic to do so .. can there be any VB program to be given i
background . which starts from top , takes in account the names o
cells ( focuses on last character ) , starts from "1" and stops jus
before it strikes another "1" ,calculate average , displays it in nex
column and start repeating this to next block
waiting for positive responce
Regard
+-------------------------------------------------------------------
|Filename: Test.zip
|Download: http://www.excelforum.com/attachment.php?postid=4755
+-------------------------------------------------------------------
programing in Excel
My problem is that ( see the attachment ) . i have name Entries ( i
first column ) , their individual percentages ( in second column ) an
average of those individual percentages which belong to same category
differetiated only by last character of their names )
now just focus on second and third column , in this test scenario ,
have manually calculated averages using formula on individual cells bu
if my list goes on quite long almost 3000-4000 name entries . i
becomes hectic to do so .. can there be any VB program to be given i
background . which starts from top , takes in account the names o
cells ( focuses on last character ) , starts from "1" and stops jus
before it strikes another "1" ,calculate average , displays it in nex
column and start repeating this to next block
waiting for positive responce
Regard
+-------------------------------------------------------------------
|Filename: Test.zip
|Download: http://www.excelforum.com/attachment.php?postid=4755
+-------------------------------------------------------------------