P
posborne
I need to rank a column to a fairly complicated pattern, based on th
number of records. I can do this with the =large function with a se
number of records, but it's variable so i think a macro is the only wa
forward??
For example, if the number of records in column E is between 120 an
130, i need the lowest number to fill position 120 (the highest 1
integer), the second lowest 110 etc - down to 10. Then the next lowes
would need to fill the position of the highest 5 integer (either 125 o
115 depending on the number of records), then the 2nd highest 5 intege
etc down to 5.
When the 5's are completed i need to continue the same logic with th
cells filled in the following order;
*1, *6, *2, *7, *3, *8, *4, *9 so that the lowest value is in cell E9.
I can do a sort within a dynamic range but i'm stuck with somethin
this complicated.
Can something working with relative cell values be done
number of records. I can do this with the =large function with a se
number of records, but it's variable so i think a macro is the only wa
forward??
For example, if the number of records in column E is between 120 an
130, i need the lowest number to fill position 120 (the highest 1
integer), the second lowest 110 etc - down to 10. Then the next lowes
would need to fill the position of the highest 5 integer (either 125 o
115 depending on the number of records), then the 2nd highest 5 intege
etc down to 5.
When the 5's are completed i need to continue the same logic with th
cells filled in the following order;
*1, *6, *2, *7, *3, *8, *4, *9 so that the lowest value is in cell E9.
I can do a sort within a dynamic range but i'm stuck with somethin
this complicated.
Can something working with relative cell values be done