random data

Hi Everyone. So I have data (say 500 rows). The data is broken up by persons, and what I want excel to do is ultimately grab a random sample of rows from each person (Let's say 5) and that the samples for each person must be at least two away from the previous one. In the real world there will...

Dear all I'm familiar with basic Excel functions but when it somes to solving this specific need I dont have a clue of how to fix it. I have search the internet and I have found plenty of examples where I can assign people on a list to a number of groups. But I need a twist to that :-) I have...

Hi I need random record to be selected from a group of categories in column. Eg- from the table below- I need two names randomly highlighted, from each city type. i.e two randomly selected names from NYC, seattle, toronto and california each. <tbody> Name Class city ABC 1 NYC DEF 2...

I have two columns. Column A has a static list of names. Column B has the same names but I need to randomize that list so that those names are in a random order next to the names in column A but the names in column A and B can never match one another. This is to create a list of opponents. Is...

So i would like to create a league table that has the ability to generate a random (or certainly something that appears random possibly using RAND or RANDBETWEEN) set of plays/matches of singles, doubles and trebles. So on my darts team there is the POSSIBILITY of 4 to 7 players. (THIS...

Good day everyone. I have a task to randomly pick 3 random values from column A and store them in column B in cells B1,B2,B3. Column A contain string values. Column A has X number of available items. Sample: COLUMN A name_tag1 name_tag2 . . . name_tagX COLUMN B randompick1 randompick2...

How does one count the number of x and y values (occurring in same row) in this array? Time1 x a b c d Time2 b c x y a Time3 x a y d b Time4 a b c d e Time5 y d a x d Time6 c y a d b Note all of the variables above are positive numbers. The answer should be 3. Thank you,

Hi, I want to select random value from selection. I have just: Dim my_range() Range("A2").CurrentRegion.Select my_range = Selection How to use Random function to select random value from my selection?