Rajan_Verma
06-28-2014, 03:06 PM
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/)
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/)