Hello Friends I am using the below excel formula to generate a list of suppliers which works fine
Then using below formula to give it a rank
Then Finally below formula to generate the list in alphabetical order
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
Excel Formula:
=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
Excel Formula:
=IF(N116="","",COUNTIF($N$116:$N$125,"<="&N116))Then Finally below formula to generate the list in alphabetical order
Excel Formula:
=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
