Your data is naff. You have two PS11341.

Positive enough?

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Dastard" wrote in
message ...

Well i m kinda new user of Excel and need a lil info regarding VB
programing in Excel
My problem is that ( see the attachment ) . i have name Entries ( in
first column ) , their individual percentages ( in second column ) and
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 , i
have manually calculated averages using formula on individual cells but

if my list goes on quite long almost 3000-4000 name entries . it
becomes hectic to do so .. can there be any VB program to be given in
background . which starts from top , takes in account the names of
cells ( focuses on last character ) , starts from "1" and stops just
before it strikes another "1" ,calculate average , displays it in next
column and start repeating this to next block
waiting for positive responce
Regards


+-------------------------------------------------------------------+
|Filename: Test.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4755 |
+-------------------------------------------------------------------+

--
Dastard
------------------------------------------------------------------------
Dastard's Profile:
http://www.excelforum.com/member.php...o&userid=34406
View this thread: http://www.excelforum.com/showthread...hreadid=541843