PDA

View Full Version : v-lookup to order a column in alphabetical order



wedd
11-15-2010, 11:32 AM
Hi, I'm wondering if its possible to use a v-lookup to order a list in alphabetical order? If so, how can this be done?


Thanks:friends:

Jan Karel Pieterse
11-16-2010, 01:54 AM
See:
http://www.cpearson.com/Excel/SortingArrays.aspx

###Edit###
Sorry, wrong link....

Jan Karel Pieterse
11-16-2010, 03:56 AM
This one seems relevant:
http://chandoo.org/wp/2008/10/22/sorting-text-in-excel-using-formulas/