I was wondering if anyone could help me with this ~~
I am working on a spreadsheet and I need to come up with a macro
that will check all the number in the cells of Column B, so basicall
checking row by row. If the number in the cells match, I need to tak
the data from the W cell of that row, and keep a running total of th
data in the W cell. All at the same time, I need to keep a count o
how many cells in Column B have the same number, so that I can divid
the running total by this number to find the average score of all thes
cells.

For example:

Column B Column W
101 3
101 3
101 6
102 7

In this case, the first 3 rows have the same number for column B. Sinc
they are the same, I need to add the numbers in Column W of those row
together , so 3+3+6. Then, since I have counted 3 rows, to find th
average I need to divide 3+3+6 by 3.

Thanks =

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com