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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Dec 19, 2009 at 09:29 PM
Related:
- Sorting problem
- Sorting bookmarks in chrome - Guide
- Sorting spotify playlist - Guide
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
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
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.
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.
