A Anna Feb 16, 2010 #1 How do you use the sort filter smallest to largest? When I try I see that the numbers are changing not just reordering? Any ideas?
How do you use the sort filter smallest to largest? When I try I see that the numbers are changing not just reordering? Any ideas?
L Luke M Feb 16, 2010 #2 Assuming you are using a formula to generate the random numbers... First, make the values static, then sort them. Or, use the LARGE/SMALL functions to reorder the numbers into a sorted list for you, if you want to be able to quickly get new numbers.
Assuming you are using a formula to generate the random numbers... First, make the values static, then sort them. Or, use the LARGE/SMALL functions to reorder the numbers into a sorted list for you, if you want to be able to quickly get new numbers.
