random

  1. 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.
  2. 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...
  3. 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...
  4. 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...
  5. 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?
  6. 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...
  7. 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...
  8. 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
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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%...
  14. muhammad susanto

    Convert Number to Text Using Formula

    hi all.. how to convert number to text e.g -10% ---- to be text "negative" 50%----- to be text "positive" 0% ------ to be text "zero" i hope don't use macro is possible all number are given & random.. thanks in advance .sst
  15. A

    VBA to take a Random 10% sample of rows with data in column A.

    Hello, I'm trying to get a piece of code to sample 10% of rows in a sheet by copying them into another sheet. I've managed to do this but the caveat is that I only want rows which have data in Column A. The way I've tried to do this so far is by hiding anything without data in column A but...
  16. R

    How to generate random numbers by a given mean and standard deviaton

    Hello, Im looking for a way to generate random numbers when my standard deviation and mean are fix. So i used google and YouTube and there are many tutorials. (Like this: https://www.extendoffice.com/documents/excel/2472-excel-random-number-mean-standard-deviation.html ) The problem is: every...
  17. M

    Display random numbers whose sum equal to specified number

    Hi, i was having an issue related to my job so i just explain that straight, I have written a number in cell a1 lets say its 200000, now i want excel to display random numbers in cell b1,b5,b10 and the sum of them must be equal to the number specified in a1 which is 200000.. Is there any way...
  18. C

    Schulte table

    Good morning, I'm trying to do a schulte table 3x3 with random 5 alphanumeric. Can you help me pls ? I need to see this table for just 1 second and then after 7 seconds another one with random positions, the numers are from 1 to 9 and the letters from A to Z.
  19. F

    Random Number Copy to Cell

    Good Day I have the following code that picks a random number and copies to a textbox. This all works fine. Private Sub Image22_Click() Dim v As Variant Dim MsgBox As String 'Dim strPassword As String With Worksheets("Sheet1") 'change this to the actual sheet name v =...
  20. P

    Creating a randomly populated roster from a list

    Hi all, I am a new user to Excel and would like to create a roster for work. I am a teacher and I need to allocate staff to Areas around the school for supervision. I have attached the roster outline with some random names and criteria for the roster. I feel that with some guidance in the right...

Some videos you may like

This Week's Hot Topics

Top