´Hello
I am developing UDF funtions to compute the percentiles using the R methods.
For that purpose I need to sort the data within the function, sorting the data for another variable with no interaction with the spreadsheet.
The searching results I have been getting use the sort function of Excel to return the sorted data in a new range of the spreadsheet.
How can I achieve my intention?
Regards
António Teixeira
RTegard
I am developing UDF funtions to compute the percentiles using the R methods.
For that purpose I need to sort the data within the function, sorting the data for another variable with no interaction with the spreadsheet.
The searching results I have been getting use the sort function of Excel to return the sorted data in a new range of the spreadsheet.
How can I achieve my intention?
Regards
António Teixeira
RTegard