I was after some help with a macro to rank varying groups of rows separated by a blank row:
I want to look at the values in the sub groups in Col L and assign a Rank from 1..... in Col U.
Cheers in advance,
Paul
I was after some help with a macro to rank varying groups of rows separated by a blank row:
I want to look at the values in the sub groups in Col L and assign a Rank from 1..... in Col U.
Cheers in advance,
Paul
Hi and welcome to the forum
Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Point taken, apologies. Here is an excel sample. These files contain tens of thousands of results from horse racing, so a macro would speed this Ranking issue up.
Came up with the solution, and VBA not required....yippee!
Post this formula at row 2 in Rank col and paste down. Remove blank rows as well.
=RANK(L2,INDEX(L:L,MATCH(M2,M:M,0)):INDEX(L:L,MATCH(M2,M:M,0)+COUNTIF(M:M,M2)-1),1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks