1. C

    Equally Random Distribution

    Using the image below, is it possible to assign a Program Randomly to each employee, but where the Count and units are balanced to the best ability? Thank You!
  2. W

    Random clipart into cells via userform

    Good morning, all. I'm attempting to make a placard. The clipart is going to serve as a visual identifier (a 3 pallet shipment will have placard 1 of 3, 2 of 3 and 3 of 3 hopefully, that might be a separate post), all three placards need the same picture to tie them together visually. Cells...
  3. E

    Create Random Unique Groups of 5, Keep Duplicates in Column

    I have a spreadsheet of thousands of books that need to be broken down into groups of 5 titles. I want to know how many unique groups can be created from this list. The catch is, some titles have 600 copies, while some have only 1. How can Excel create my groups of books? Also, do I have any...
  4. I

    Entering data into a cell has duplicated it in random cells in the same column

    Hi, I'm working on a large spreadsheet for work (not built by me) and I've encountered an issue that I can't quite get my head around. One of the columns in the sheet is Occupation and another Address, some of which had previously been filled out and some of which were still blank. After...
  5. F

    VBA comparing Cells

    Need help with this. Looked through some similar posts but couldnt figure out how to adapt them. I got a value in cell B2 and a value in Cell B1 (a value between 0-10). They are values that are not allowed to be the same. If the value in B2 ends up to be the same as in cell B1 i need to call...
  6. T

    Is possible to shuffle answers in multiple choice test in EXCEL?

    I have a lot of questions and I need to quickly shuffle answers in Multiple Choice Test. (1 question has 4 answers, A,B,C, or D). For example: Is possible to do that by using VBA or with some formula? Thanks for the help.
  7. The_Rock

    Random Replace Characters in a Word

    Hi Folks I've been scouring the net but without success. I'm hoping the genius's here will be able to help me :-) I'm trying to mock up some work for my daughter to help her with Synonyms and Antonyms. What I would like to do, if possible is: Column D looks at Column F (which will be hidden)...
  8. W

    VBA Random selection from list of names

    Hi All, I'm working on a spreadsheet that I would like to pick a random name from a list of 10 names using a vba button. the list of names are in cells C3:C12 and I would like the selected name to appear in cell D3 Thanks in advance.
  9. B

    generate a random number to enter in a cell

    I am am looping through a range on my computer (Excel 2013) and where I find a number 1 I want to replace it with a random number between the bottom number in Cell I9 and the top number in cell I11 So what I need my code to do is Activecell.value= "Randbetween Range ("I9").value and Range...
  10. K

    Random Highlight only 1 in the each row

    Using Excel 2000</SPAN></SPAN> Hi,</SPAN></SPAN> I need a VBA, which can highlight 1 character out of 1X2 in the each row so far each time 14 total are selected within the 14</SPAN></SPAN> Example.. <b></b><table cellpadding="2.5px" rules="all" style=";background-color: #FFFFFF;border: 1px...
  11. M

    Getting specific text or tumber from cell

    Hi Guys, I've got a lot of cells with useless text and a combination of text + numbers in it that I need and by now I am out of ideas... Sometimes it looks like this: Useless-Text_CD_local random, name (randomname) 2019-10-17T08:20:15 XYZ-COUNTRY-000737 Or like this: Useless-Text_CD_local...
  12. T

    Random numbers between two values with condition

    Hi all I'm stuck with a mental block here: I want to generate 20 individual random numbers between two values (-3.28 and 14.50) but with a condition that the average of the 20 numbers should equal a set value, in this case 5.61 Can someone help please?
  13. M

    Combining Logical Statements Into One Formulax

    Is there a way of combining all of the statements below into one formula? IF A2 EQUALS "RANDOM" AND F2 IS LESS THAN 126, THEN "NORMAL" IF A2 EQUALS "RANDOM" AND F2 IS GREATER THAN 125 AND LESS THAN 200, THEN "PREDIABETES" IF A2 EQUALS "RANDOM" AND F2 IS GREATER THAN 199, THEN "DIABETES" IF A2...
  14. N

    unique Code

    I need help to design a formula in excel to develop a unique random code, for example I have "Received" word in A1 cell then I want to get a unique Code in B1 cell, code should capture “R” from A1 cell then contain today’s current date like 011019 (01 day, 10 month, 19 year) then capture any...
  15. S

    Sort DAX measures random sort

    Hi, I just opened my Excel workbook and noticed all my DAX measures that were sorted into columns are now in a random order. I've seen this before and moved them only to find them just thrown back into a random order. Any thought how to sort them again and avoid this. Thanks
  16. J

    Copy specific cells at random rows

    Is there anyone who can help with a code? I want to select a random cell in column Aand in that row copy the values ​​in columns A: C and E: G and I: J In this example it is row 4 but it might aswell be row 10 so the code should take into account random rows depending onthe active cell in...
  17. Y

    Randomly assign x number of students to x number of workshops where students do not meet the same co-student

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

    Random selection from range where the selection is constrained of whether or not another cell on the same row ISTEXT

    Dear folks, hope that all is well. I have a frustrating problem with a random selection from a range given that another cell on the same row is text/not blank. Below table might help to explain the circumstances. What I would like to do is to select a row completely random, constrained on the...
  19. W

    Random Number from select range

    Hi All, I am looking at creating a random number draw with no repeats in cell A1 i have =RANDBETWEEN(MIN($B$1,$B$2),MAX($B$1,$B$2)) in cell B1 and B2 I have my range. (which for this exercise is between 1-4) I have a button in C1 which has VBA Application.calculate which basically picks a...
  20. H

    Random Percentages That Can't Exceed 100%

    Good Afternoon, I have been struggling with this problem for a few months and several people have kindly attempted to help through the forums, but I am hoping I can finally solve my problem definitively. Is it possible to create a formula that will generate a random number between 0.00%...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back