Average Duplicates in Excel
 

Hi,
I am trying to write formula that calculates the averages if the identifiers
are duplicated. I mean, in the data I am working with the first column (A) is
IDs and other columns (B-$) contain the actual data. I want to find the
duplicated IDs in column A and then average the corresponding data in column
b, then c, ....etc.
Any help please?

Average Duplicates in Excel
 

It would be very helpful if you posted a shrinky-dink sample
of the data structure with an example of the values you hope to calculate.

Regards,

Ron
Microsoft MVP - Excel

"magra" wrote in message
...
Hi,
I am trying to write formula that calculates the averages if the
identifiers
are duplicated. I mean, in the data I am working with the first column (A)
is
IDs and other columns (B-$) contain the actual data. I want to find the
duplicated IDs in column A and then average the corresponding data in
column
b, then c, ....etc.
Any help please?