randomization

  1. L

    Pick random city names from each risk category in excel

    Hi, I am trying to pick random city names from a list of very large data in excel, each city has different categories. I want to pick 23 city names randomly (3 from extremely low risk, 4 from very low risk, 4 from low risk, 5 from moderate risk, 2 from highly moderate risk, 2 from high risk and...
  2. P

    Need to randomly combine numbers

    Hello guys, I have 18 numbers (not from 1 to 18) which I need to randomly combine with each other in groups of 6. Will appreciate any help on that. Have a good one!
  3. M

    [VBA] Continuously Randomized Data set gives Performance Output, How can I make VBA Find a better Solution?

    Hello, I have a basic VBA program which randomly selects data from a larger set into multiple smaller sets, then based on these smaller sets takes an average of the values and gives a performance rating. As of now I can make a simple Do While loop that will continuously run the randomization...
  4. C

    Controlling randomization without VBA?

    Greetings, Currently, I have a spreadsheet of text data that I need random blocks of. I have managed to take the data from the source column and arrange it "randomly" over five columns, but it isn't quite random. For example, the first row only contains values from the first row of the source...
  5. L

    IF Function with some randomization!!!

    This is my function =if(A1=1,"+",if(A1=2,"-")), this function would be in cell B2. Now the problem is if A1 is neither 1 or 2 then FALSE appears in cell B2. so how do i fix it so that FALSE won't appear in cell B2 if neither 1 or 2 is in cell A1. Also in that same function I would like to add...
  6. G

    Generate random numbers with multiple conditional statements?

    Help (Please!), I'm trying to randomly generate thirteen "Distractors" (single-digit numerals ranging from 2 to 8). However, the randomization must be subject to the condition that each new Distractor ("i") has not appeared as one of the previous three distractors (that is "i - 1", "i -...
  7. L

    Random ThemeColor in sub

    In Excel 2007 VBA: Is it possible to randomize ThemeColor in a sub? I have a sub that formats cells that correspond to a certain named range. (here "SV") What I want is to randomize the ThemeColorAccent number in the code below. I have 3 more equivalent subs for other named ranges, and I...
  8. O

    Biblical verses with each letter of your name

    :confused:This is a church project I have 26 alphabetic tables each containing a different number of records but all of the 26 alphabetic tables consist of the same columns: Column 1 the alphabet letter of that table (A, B, ......Z), Column 2 a verse from the Bible starting with that letter...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    • Replies: 31
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    • Replies: 26
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    • Replies: 24
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    • Replies: 23
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    • Replies: 23
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    • Replies: 23
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top