random list

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...

Hi, I have a list of 20 values in excel. I want to pick four by a certain rule, which I have figured out. Now I want to pick 6 randomly from the remaining 16. I used 'randbetween' for the whole range of values (since I won't know ahead of time which 4 will be picked by the rules) along with a...

Greetings, I am very green at VBA, so I don't even have a sample code to give. I want to have two columns of words say [A1:A10] and [B1:B10], randomly select a word in the first column (the A column) and print it in D1, then randomly select a word from the second column the B column) and print...

Copying data from a variable workbook Hi all! I want to achieve the below, i.e. copy only GDP data into a new sheet. I have written a code for it but it isn’t working. I wrote it reading some sources on net but wasn't successful. Can anyone please help? Further, please note that the keyword...

I'm curious to know if there is a function within excel or combination of functions that can allow me to handle a task. I would like to populate a list, by taking information from a range of data randomly, however I want to ensure that no duplicate values would be taken from this list. The...

I need to come up with all the combinations for the below data. I have numbers, colors and names. I need to put one number, two colors and three names in a row without repeating a name or color in each row. I would also like to not replicate the rows with the colors or names in a different...

Hi all, I hope that someone can help me with this.. 1. I have long list of URL addresses that I want to have displayed on a random basis. I only have space for 5 at a time 2. In column A of sheet 1, I manually input the URL addresses on a regular basis (these are news items so needs to be kept...