Averaging?

[David]

This must be easy to do but I cannot figure it out...

I have 150 rows of data with information in cell A, B, C and D. Cell A
is simply a description for each row and cells B, C, and D contain
numeric values between 1 and 100. I need to average each row to its
respective cell E and then sort row A from highest to lowest based on
the average value in row E.

Example >>


A B C D E

Song1 52 45 25
Song2 33 55 88
Song3 44 94 22


Anyone!?!?

TIA!! (e-mail address removed)

 

[JE McGimpsey]

One way:

E1: =AVERAGE(B11)

Copy down to E150.

Select E1. Choose Data/Sort and sort on column E

 

[Wild Jim]

=average(B11)

then copy down column E, then copy column E and paste special > values onto
itself before sorting the data on figures in column E.