Got a doozy!

  • Thread starter Thread starter Michael Wise
  • Start date Start date
M

Michael Wise

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
 
Yup. All us'uns got doozies. A different subject line might help you get
more answers and it would certainly help the archives.
 
in F1 put in the formula

=Sumif($A$1:A1,A1,$E$1:E1)/countif($A$1:A1,A1)

then drag fill down the column.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple SUM's in a column 15
Excel 2013 Merge Data 2
Transfer array element offset value to a matched value 3
Modify Claus code "Sub Array_Var_Column_Sort()" 27
convert columns to rows 6
Taking the 51st Line and Multiplying by 2 8
Totalling then Averaging subject to Product Code change 3
Transpose?? 6

Back
Top