Sort Data In Excel Using Formula

[Rajan_Verma]

Rajan Verma has posted the following on 06-28-2014 02:31 PM:

Excel provides SMALL and LARGE formula to get sorted numeric values , but sometime we need our string/text data to be sorted by formula only. Though, there is an inbuilt sorting feature available in excel, but here I am going to demonstrate a formula. So, Lets say you have your data list in Range “A1:A10″, […]http://stats.wordpress.com/b.gif?host=excelpoweruser.wordpress.com&blog=38153 515&post=620&subd=excelpoweruser&ref=&feed=1

Sort data by excel formula (http://excelpoweruser.wordpress.com/2014/06/28/sort-data-by-excel-formula/)

[FlameRetired]

Good one.

Also try this one that I got from Bob Umlas:


=INDEX(mylist,MATCH(SMALL(COUNTIF(mylist,"<="&mylist),ROWS($1:1)),COUNTIF(mylist,"<="&mylist),0))

It must also be committed with Control+Shift+Enter and dragged down.

Hope this helps.