How to reorder a spreadsheet based on mean of column groups

[Poida68]

Hello,

I have a challenge. And I only have Excel 2002.

I am trying to reorder columns based on the average value associated with a column ID.

I have a spreadsheet with a column of IDs and 3 columns of data.

I want to reorder these values so that the column ID ("group") is in order based on the descending means of the associated values in the "value" column:

Seeking a method or VBA code. Thanks

 

[offthelip]

the way I would do that is to use a "helper" column such as column H. put this equation into cell H5 and copy down, then sort on column H
I assume your data ended at row 30 adjust a necessary

=AVERAGEIF(D$5:D$30,D5,B$5:B$30)

 

[offthelip]

I just checked excel 2002 doesn't have averageif, so you will need to use Sumif divided by countif in column H

 

[Poida68]

Thanks very much offthelip, it works well.