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…