random

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

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

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

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

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.

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

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

Hello Every One, I am looking forward for a solution of below cited problem.... 1) I want to have total of four random values between 2.5 and 7. 2) System must pick random values by its own and values must be in between 0 and 5. 3) Total must be in multiple of 0.5 e.g 2.5, 3, 4.5, 6.5, 7...

Hi I wrote the code below to fill cells with random char. It does not work. I also have another question. Why Char() is not part of Application.Worksheetfunction? I thought all excel functions that you can find in Fx, you can find then under Worksheetfunction. But that is not the case. I found...

I am trying to generate a random Date and Time in excel but I need to remove the volatility out of the Randbetween function. The formula I an currently using is as follows: =RANDBETWEEN(--"2019-03-17",--"2019-04-29")+RAND()*("0:59"-"17:00")+"1:00" But by using this function the generated Date...

Hi Folks. I'm looking to randomize some of the inputs to a goal seek calculation that I can run multiple times for different random values. This creates the problem of goal seeking on continually generating random values which doesn't work. is there a way to freeze the random values functions...

I have a sample size of 30. I need an excel function in which I can assign " Random Values " (say a question has 4 options and need to assign 1 to 4 randomly) based on the weight to each individual from the sample. Means Option 1: 45% Option 2: 12% Option 3: 30%...

I have 4 different check # sequences. I do a % of the total number of Checks based on the total. I then used the # of items to select, of each of the sequences to = my total sample size of 25. My question is, how can I get the random # to select and then put them all together to give me my 25...

You are given a random number. For this example lets use 1793 You are then given some additional numbers. For this example lets use 16, 17, & 18. What I want to do is list out the different sets of these numbers that would equal the random number. Some examples (Not showing them all because I...

Hi, In a table, with 500 rows and 20 columns, of documents that cost 200,000 dollars. How do I extract 25% of these costs to physically check the documents (sort of sampling but random). Thank you.

Hi all: I have workbook with sheet(data).range(A1:A1000) as text Now I want macro apper random cell in texbox when Userform.show Please help me to do that, many thanks./.

Hello all, I have read these two posts about Hover over and wanted to ask if there have been any updates in excel over the years that might allow this to happen now. https://www.mrexcel.com/forum/excel-questions/515724-show-contents-cell-when-hovering.html...

Hi Everyone, A bit of a different one, I just want to know how remove duplicates decides which duplicates to remove? Lets say I have 5 duplicates so rows 1 to 5. if I remove duplicates does it remove 1 to 4 and leave 5? 2 to 5 and leave 1? or is it random of some other rule? thanks Tony

Hi all, I'm looking for a formula for two things. The first is that I want to return a random yes or no for any record, based on a certain percentage of yes's. So for a 100 records, with that yes variable at 10%, I'd like to get exactly 10 times yes and 90 times no. Then, for the 10% yes's...

In Gerard Verschuuren's book on excel monte carlo simulations, he uses the above formula to generate brownian motion. Can someone explain what this does and its signficance? Thanks.