Sorting problem

Closed
David - Dec 19, 2009 at 03:00 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 19, 2009 at 09:29 PM
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 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Dec 19, 2009 at 09:29 PM
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.
0