Sorting for column based on another column

  • Thread starter Thread starter xxnonexnonexx
  • Start date Start date
X

xxnonexnonexx

I want to sort say column a1 to a30 which has names in it based on column b1 to
b30 which has say widget sales to put column a1 to a30 in numeric order from
high to low

So that say:

Mo 10
Larry 20
Curly 5
Billy 12
Bobbi 8

Would end up as

Larry 20
Billy 12
Mo 10
Bobi 8
Curly 5


Thanks in advance.
 
Hi

click in any cell between a1 and b30 and choose Data / Sort from the menu
choose whether or not you have a header row
then in the first drop down box, choose column B (or its header)
choose descending
click OK

Cheers
JulieD
 
Back
Top