Sorting problem

[Closed]
Report
-
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
-
Hello, can You please help me with my problem?
In column A i have names like Name1, Name2, Name3...in column B i have some numbers...what i want to do is to sort the names in column A in correlation with the numbers from the highes number to the lowest:

NAME1 25
NAME2 152
NAME3 75
NAME4 200
NAME5 15

to become:

1. NAME4
2. NAME2
3. NAME3
4. NAME1
5. NAME5

Thank you in advance, and sorry for my bad english.

1 reply

Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
803
You have to just sort according to column B decending

1.assume there is column headings in row no 1
the data is from row 2 from A2 to B5 like this
name data
NAME1 25
NAME2 152
NAME3 75
NAME4 200
NAME5 15

1.highlight all the cells including headings
2.click data-sort
3.in sort window below "sort by" at the top 
click the arrow on the left window and choose data(that is my column heading)
3.in the right window choose "decending"
4. in the bottom choose "header row"
5.click ok 

you get like this

name data
NAME4 200
NAME2 152
NAME3 75
NAME1 25
NAME5 15


read about sort in excel help. this is an oft repeated need in excel.