Excel Formula

[hrayani]

Hello Friends I am using the below excel formula to generate a list of suppliers which works fine

=IFERROR(INDEX(orders_supplier,AGGREGATE(15,6,(ROW(orders_supplier)-ROW(DATABASE!$E$4)+1)/(orders_sampling<>"")/(ISNA(MATCH(orders_supplier,N$115:N115,0))),1)),"")

Then using below formula to give it a rank

=IF(N116="","",COUNTIF($N$116:$N$125,"<="&N116))

Then Finally below formula to generate the list in alphabetical order

=IFERROR(INDEX($N$116:$N$125,MATCH(SMALL($O$116:$O$125,ROW(1:1)),$O$116:$O$125,0)),"")

Is is possible to use a single formula instead of 3. The problem is I am using excel 2016 which does not support the sort function

Regards,

Humayun