Thanks both but it didn't work.
newdoverman: I did select the values in column C and copied in column E, but it didn't work.
pboost1: i didn't understand completely. this is what i did:
- select the data C4:C28
- clicked above in the menu "data" and then "sort"
- a new window pops up saying: "you have selected only some of the available data. Only available data will be sorted. What do you want to do? expand the selection or Continue with current selection" I click Continue sort.
- i select sort from largest to smallest
- nothing happens.
please see file attached.
Bookmarks