If you want to apply a minor tweak to the document, it should not take long to Distribute numbers resolution. This sort of basic activity does not have to require additional training or running through handbooks to understand it. Using the right document modifying resource, you will not take more time than is necessary for such a swift edit. Use DocHub to streamline your modifying process regardless if you are an experienced user or if it is your first time making use of a web-based editor service. This tool will require minutes or so to learn how to Distribute numbers resolution. The sole thing needed to get more productive with editing is a DocHub profile.
A simple document editor like DocHub can help you optimize the amount of time you need to spend on document modifying regardless of your previous knowledge about this kind of tools. Create an account now and boost your productivity immediately with DocHub!
Hey, welcome back to the MrExcel netcast. I am Bill Jelen. Today, we have a question sent in by Jerry from Georgia. Sure hes trying to randomly assign some numbers to basically four sales reps or something like that, and he said you know the problem is is if I use RAND or RANDBETWEEN, Im going to get duplicates. Now theres duplicates in the list, but he said, you know if theres three sixteens, I dont want to distribute four sixteens. I want to make sure that everything in my original list gets assigned to a person and nothing gets assigned twice. So, my solution to this is a bit convoluted. I insert a couple of columns. And In the first column, Im going to just put the RAND function =RAND And then Im gonna put the RANK Function. So, well ask for the equal rank of this value within the entire list of values. I want to make that second parameter absolute . So, put the dollar signs in. Copy that down to all of our cells. And now whats interesting here is Ive now assigned a ra