Again, Thanks for your help in writing the below code. It is very short and sweet and nicely working. In this regard, I have a couple of queries:
The code is:
When I run the above code, I am unable to do the following:
1) When I added a new group (say 5 or 6 or 7... and so on..) it is not added in the sheet2. Is it necessary to change any code when some new groups are added in "Data to be Ranked" sheet?
2) When it is not showing ranking in the way which I required, alternatively what code should be included with the above to sort groupwise and then Indexwise in sheet3? So that, I can manually select the data as I required.
Please help.
Thanks in advance.
acsishere.
Bookmarks