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?