Hi,
i need to calculate rank of employee on the basis of their monthly performance. i have data in columm D. i want a macro to sort this data in accending order, add one column E(Rank) and calculate the rank accordingly.
i have tried to record a macro to do this but unfortunately this is...