M
MACRE0
That is basically what I did do without the sort - perhaps that wil
save time when running the macro as opposed to an additional fe
columns, but the 6 selections would not be independent cause say a 1 i
10,000 shot couldn't then be selected again with a sort. I can and hav
done this but it often overloads the ram use and crashes the computer.
I am trying to avoid doing any rand() step because it would requir
creating new lists. I will also be performing the a random selectio
based on the individual clients historic product useage, which woul
require me to restack a new 10,000 item list based upon it's specifi
percenatages and not just the whole.
I want something, perhaps some user defined function that someone coul
help me build that would take multiple %'s associated with products an
create it's own list where the number of product A's would b
=round(%*10,000) assigning unique Rand() for each of these in the lis
and then determining the max which would pull the specific product.
Does anyone know if this would be faster than the macro I already have
*New idea - can anyone help me build a macro that creates a list 10,00
long by =round(%*10,000) and then moving on to the next product so
don't have to do this?
save time when running the macro as opposed to an additional fe
columns, but the 6 selections would not be independent cause say a 1 i
10,000 shot couldn't then be selected again with a sort. I can and hav
done this but it often overloads the ram use and crashes the computer.
I am trying to avoid doing any rand() step because it would requir
creating new lists. I will also be performing the a random selectio
based on the individual clients historic product useage, which woul
require me to restack a new 10,000 item list based upon it's specifi
percenatages and not just the whole.
I want something, perhaps some user defined function that someone coul
help me build that would take multiple %'s associated with products an
create it's own list where the number of product A's would b
=round(%*10,000) assigning unique Rand() for each of these in the lis
and then determining the max which would pull the specific product.
Does anyone know if this would be faster than the macro I already have
*New idea - can anyone help me build a macro that creates a list 10,00
long by =round(%*10,000) and then moving on to the next product so
don't have to do this?