Average Duplicates in Excel

  • Thread starter Thread starter magra
  • Start date Start date
M

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?
 
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
 
Back
Top