Every so often I have to randomly pick a few names from a list of individuals who have completed a survey. To do so, I have been pasting all of their names into excel, then, after checking how many names there are, setting a RANDBETWEEN function that selects between 1 and the number of individuals in the file. From there, I get a number and then plug that number into a cell, but add an A in front of it. It's not difficult, but I keep thinking that I should be able to automate that last step. So today I tried replacing that last bit, where I plug the number into a cell, by typing in the cell =A(Value(C3)) with C3, of course, being where I have my RANDBETWEEN function. I figured this would result in a cell that mimics my last step. Instead I get a #NAME error, which I imagine is because excel doesn't like multiplying non-numbers. Anyone have a solution that would make this work and help me automate this last step?