I have four values in P Q R and S columns (int numbers).
I need a formula that returns the position (match) of the smallest value, BUT when there's two or more values with this same smallest value??? In this case I want it to return a aleatory position between those smallest equal values.
Without macro will be better.
Examples:
10,20,15,9 returns 4 (position of the smallest).
40,2,30,8 returns 2 (position of the smallest).
3,3,7,5 returns 2 (aleatory between 1 and 2).
10,4,4,4 returns 3 (aleatory between 2,3,4).
Thanks.
I need a formula that returns the position (match) of the smallest value, BUT when there's two or more values with this same smallest value??? In this case I want it to return a aleatory position between those smallest equal values.
Without macro will be better.
Examples:
10,20,15,9 returns 4 (position of the smallest).
40,2,30,8 returns 2 (position of the smallest).
3,3,7,5 returns 2 (aleatory between 1 and 2).
10,4,4,4 returns 3 (aleatory between 2,3,4).
Thanks.