I have 2 columns in excel. column A is words, column B is numbers. So for example: apple 6 rain 6 apple 4 laptop 2 coffee 5 coffee 8 I need to sort column A in alphabetical order while also sorting by the numbers in column B. so for the above list, the right order would be apple 6 apple 4 coffee 8 coffee 5 laptop 2 rain 6 This is a huge list and cannot be done by hand. How can I do it automatically? I have SB, if necessary.