rand

  1. K

    Sort names or units into 3 unique groups

    It’s my first time posting to MrExcel although I’ve been using your forum to teach myself the program for the past year! I can’t say enough how awesome and helpful this community is! I have a list of 63 names that I need to sort into 9 groups of 7. This step is easy enough – however – I would...
  2. F

    How to automatically randomize data on Copy / Paste?

    Hello everyone, It was necessary to create an automatic sampling program in Excel, which has 5 columns on the first sheet that contain the following: Sheet 1: Column A: follows RAND() under this idea “=IF(B2>1;RAND())”. Columns B to E have the data that are to be filtered randomly. Sheet 2...
  3. O

    Macro not updating using =rand() as the trigger

    I have a column of data that I am sorting via a list of =rand() outputs in order to create a randomized list. I have created a macro of sort>expand, and it works correctly. I also have a script that detects a change in a cell, and if there is a change to run the macro. Yup, that works as...
  4. R

    Random select one line of data for each person in a list

    I would like to know how I can get excel to randomly select one line of data for each of the people listed below (so one for bob, one for jenny, one for Trish etc.). I have been trying a mixture of vlookup and rand but to no avail, below is just a sample list but i would like to try it on a...
  5. H

    NPV of a Project & Trial Simulation!!

    Hey guys. Hope you are doing good and in the mood to help a brother out :) I have been working on a project that I need to solve the NPV for...I made out the income statement and I believe I have the values correct. I also calculated the NPV for the project using the CFFA, but could anyone...
  6. W

    Selecting Questions randomly without repeat

    Hello Gurus, I have prepared a logic in creating a questionaire. But I am looking for anyone to help me prepare a VBA code for it. I have a sheet with 50 questions and 4 options each. The Code should display 1 question with the options. once the person selects an answer it will verify if...
  7. R

    Line up Text in Outlook (VBA E-mail)

    I'm sending an e-mail of formatted text in a column to Outlook. I lined up the text in Outlook using a Rand() function, but it's not aligned in outlook. The field contains Name, ID, and ticket # I would like them to be lined up in outlook to be easily readable. Any Suggestions?

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
Back
Top