Ok let me see if I can explain this correctly.

Items in column A are sorted so all items of like name are in order.
want to do a running average on numbers in Column E, but only on item
that match the previous cell. For instance Column A has bp-161A in ro
1, 2, & 3 bp-161b in row 4. In row 1 column E 45,row 2 60, row 3 30
row 4 63. Now I need for each cell in column F to look at column
determine if it is of the same identity and average column E of tha
row with any previous rows above it. In this senerio row 1 column
would have 45 as its answer, row 2 would have the average of row1 and
of column E, row 3 would be average of row 1-3 and row 4 would have 6
because it begins a new identity. Hope I have given enough details her
for you folks to help me out.
Michae

--
Michael Wis
-----------------------------------------------------------------------
Michael Wise's Profile: http://www.excelforum.com/member.php...nfo&userid=699
View this thread: http://www.excelforum.com/showthread.php?threadid=27494