Average Duplicates in Excel

[magra]

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?

 

[Ron Coderre]

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