randomly

Column A has my data Column B had Rand() function Column C has qualifiers (C1=1,C2=1,C3=2,C4=2,C5=3,C6=3,C7=4,C8=4,C9=5,C10=5,ECT..) Column D has qualifier: Yes or NO What I would like to do is sort column A randomly if column D=NO, if column D=YES then I would like to sort randomly but...

Is it possible to return the height of a row as a number inside a cell? So imagine someone randomly changing the heights of 10 rows and then pressing a button. And that button initiates a macro that will impute the rowheight in cells A1:A10. So if each row was randomly a completely different...

In Column A, I have a list of Item Types, e.g. Item 1, Item 2, Item 3 in unsorted order. I need to randomly select 5% from each Item type and output the randomly selected items in column B. Is there a simpler way to do this?

I am trying to randomly select a set of values from another column without duplicates. The formula I am using below works for randomly selecting values from the table in Column A, but it often returns duplicate values. Is there any way to use this without doing the whole extra "helper" =RAND()...

Hello, This is the first time where I got an error that I cannot find anything online about. I don't know when this issue occurs but sometimes randomly I get messages "Error in Activate Procedure" or "Error in Deactivate Procedure". Can anyone help me on this?

Hi All, I wanted to put together a quick spreadsheet for my family to quickly assign pollyanna names (Christmas gift-giving event, for those unfamiliar). Obviously, everyone in the pool should receive a gift and we do not want people in the same nuclear family (i.e. siblings) to be assigned to...

Hello Mr and Mrs Excel, I had a range Range("A1:I18") I wanted to randomly highlight 5 cells from each row within this range. For example Highlight 5 cells from Row A1 to I1 5 Row A2 to I2 5 Row A3...

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

Hi everyone, I am using =CHOOSE(RANDBETWEEN(1,2),"A","B") to randomly assign data into two groups A & B. But when I do for 120 contacts does not group them into two equal groups of 60, which is what I want. Instead, it will have one group with 68 and the other with 52. Does anyone know a...

Dear All, I'm having issues with Excel randomly crashes and stops working. When I click the cells with data validation dropdown list in some Excel files, Excel randomly stops working and crashes. I cannot reproduce the issue. Sometimes restart computer makes it better, but it gets worse again...

Hi, Every week I have a file that ranges from 5,000-10,000 rows and I'd like to randomly select 5% of those rows to be analyzed on a separate sheet for further review. Note that the first row will be a header that should not be included in the 5% but I would want moved over to the other sheet...

Hello, I am having a problem with Excel for 8 months now where a file randomly freezes and the ribbon will be greyed out. Solution is to click on another file and then go back to that file but as soon as I type in a cell and click enter it happens again. It does not matter which file I use or...