Ok so here is what I am trying to do efficiently...
I have a worksheet with 75 rows of data and I want to insert a RANK into a column via VBA.
The issue is I want to rank Rows 1, 7, 14, 21, 28, 35, and 42 as a group. Then I want to rank rows 2-6, 8-13, 15-20, 22-27, 29-34, and 36-41 as a group.
So the first ranking would have ranks 1- 7 and the second group would have ranks 1-35.
Does that make sense?
I can insert the values into a different spreadsheet and rank them there, then VLOOKUP that table to get the values back to the original, but I thought using a JOIN might be more efficient - problem is I don't have much experience joining ranges..
Any help?
I have a worksheet with 75 rows of data and I want to insert a RANK into a column via VBA.
The issue is I want to rank Rows 1, 7, 14, 21, 28, 35, and 42 as a group. Then I want to rank rows 2-6, 8-13, 15-20, 22-27, 29-34, and 36-41 as a group.
So the first ranking would have ranks 1- 7 and the second group would have ranks 1-35.
Does that make sense?
I can insert the values into a different spreadsheet and rank them there, then VLOOKUP that table to get the values back to the original, but I thought using a JOIN might be more efficient - problem is I don't have much experience joining ranges..
Any help?