random

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

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

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

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

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.

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

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.

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

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

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

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?

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

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

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

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

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

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

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

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

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