When youre finished click the OK button. To dynamically sort a list of numbers in ascending order you can a simple formula based on the SMALL function with an expanding range. In columns containing both text and numbers ascending order sorts numbers before text for example 1a 1b 2a a1 b1.
In plain English this will sort the Excel spreadsheet based on alphabetical order.
Lets look at the Order drop-down. In my case Ill choose Client from the dropdown menu and leave the the Sort On set to Values and Order set to A to Z. To format all the selected data as text Press Ctrl1 to launch the Format Cells dialog click the Number tab and then under Category click General Number or Text. When i get a second request i should sort the file again and should increment sequence number to two.