Dear team,
I am having marks on column E:P. In column Q I am calculating average values from column E to P.
In column R i want to display the no.of position on the average values which is in column Q.
For example in column Q the values are in the format of 100%, 80%, 92.5%, 42% & 76%. In column R it has to update the numbers of the position of that marks like 100% -1, 80%-3, 92.5% -2, 42%-5 & 76%-4.
I am attaching my sample file here.
Can any one help me how to do this with VBA Code
Bookmarks