Related Posts
Come get your shoe😂😂

Hi all
Require 3 consultants URGENTLY
please send profile to abhishek@rskitsolutions.com
1) Client - Kuiqly
2) Whose payroll wil the consultant be on - resources are required on contract -
RSK IT SOLUTIONS
3) Experience - 3+ years
4) Need immediate joinees
5) remote work
6) any part of India.
Regular shifts with support for EST time zone
Senior Full-Stack developer with
Java and Angular experience -1
angular developer - 1
need 2 candidate for angular and 1 sr. full stack developer
Abhishek@infigroup.com
Additional Posts in Excel Genius
I truly appreciate this group.

New to Fishbowl?
unlock all discussions on Fishbowl.
This is probably not the most effective way to do this but I would do an index match and for the match value I would do a randbetween that generates a random number in a range you specify. So if there are 20 possible rows your randbetween would be 1 & 20.
So: INDEX(‘Identical Name Range’,RANDBETWEEN(first number,final number))
Thank you!
Subject Expert
There's a conceptual discussion on this - it's IMPOSSIBLE to generate true random numbers on any computer that is not linked to a physical thing.
To give the appearance of a random number, you can either create your own random formula (based on the day of =TODAY for example), or you can use =RAND and =RANDBETWEEN(). The issue of those two is that they are dynamic aka any change in the sheet will make a new number to be calculated.
After you created whatever formula you wanna, just do =INDEX(range of names,#number); where #number is your formula*
* keep in mind you should make the #number a whole number and make sure the number isn't greater than the number of names you have - there are tons of ways to do that, I'd just use =ROUND() and divide it by the amount of names
Thank you!
If you can add a column on the left that numbers the rows 1 through N names, then you could do =RANDBETWEEN(MIN(<col>),MAX(<col>))
Thank you!