how do I sort dictionaries by value then by key?

Excel Question: How to sort text values by corresponding numerical value?

• I have a list of categories (text) with corresponding numerical values, and I need to sort the categories in order of their numbers. However, the numbers are defined by an array that depends upon many other things in my data set. When I try to sort the categories, I get an error about how I can't alter the array. How can I sort this list? Thanks!!!

• Answer:

  I dont know whether this solution will suit your requirements method 1) In a new sheet from cell A1 onwards give a formula =sheetExisting!A1 and copy to all the cells till you get all the values from sheetExisting. Then sort the values in the new sheet method 2)instead of giving a formula as mentioned in method 1, copy all the values from sheetExisting and pastespecial in the new sheet and sort it