I'm wanting to create a button that generates a string of 10 random numbers into cells, and pulls the range for these random numbers from, for instance, in B1 and B2. Basically, I'm looking to use the INDIRECT() function in VBA. Is there a way to do this?
121044
I searched for a similar question but couldn't find one..  I want to generate 10 groups out of numbers ranging from 1-60 (including both), with each and every group containing random and non-repeating numbers. How can I do this in excel?
13424
I want to make a mini game in Minecraft were I need a random command generator for 9 commands. I need a random command to give the player a random item. I can't do the command block in the dispenser any more because it will just drop out instead of being placed. What different ways are there for generating randomness in commands, and which one would be best for my use? This question is similar to the one about , but I am specifically attempting to get randomness when using commands - the redstone solutions do not apply here.
52026
There is this question regarding adding checkbox functionality to Google Drive: . And a great  is:     In the Google Sheets spreadsheet go to Tools -> Script Editor.   Enter the following code:   function onEdit() {   if(SpreadsheetApp.getActiveRange().getValue() == 1) {     SpreadsheetApp.getActiveRange().setValue('=CHAR(10004)');     SpreadsheetApp.getActiveRange().setBackgroundRGB(0,255, 0);   }   if(SpreadsheetApp.getActiveRange().getValue() == 0) {     SpreadsheetApp.getActiveRange().setValue('=CHAR(10060)');     SpreadsheetApp.getActiveRange().setBackgroundRGB(255, 0, 0);   } }      Enter into any cell a 1 for a tick, and a zero for a cross.    This code is great and it works beautifully, but I would like to know how to ONLY apply that to a range of cells and not to the whole spreadsheet.  By example, cells: G25 x I47
20200
I need a formula to use cell address and return the cell defined name, i.e.  =INDIRECT(ADDRESS(ROW(),COLUMN(),1,,"SHEET 001"))   I need this ADDRESS(ROW(),COLUMN() to refer to the current cell defined name i.e. "sales" and not $A$1
114524
How do I generate a range of consecutive numbers (one per line) from a MySQL query so that I can insert them into a table?  For example:  nr 1 2 3 4 5   I would like to use only MySQL for this (not PHP or other languages).
3152
I have over 6000 records and half of them are formulas that are missing a variable so they result in #N/A on the spreadsheet, what i want to do is if the cell is #N/A then leave the cell blank, otherwise print a string like so  =IF(AR6347="#N/A","","string in here")   But this does not work with ="#N/A", is there a way to do this?
25738
I had an application for returning closest matches to certain values in a large  cluster of values( as in my earlier )   and I chose a VBA solution. While in the course of using the said application, I observed that the results for the value of 0.5 were not correct. I had been using the VBA Round function which I found to be returning 0 for 0.5 rounded to integer whereas the worksheet round function returns 1. Strangely, the VBA round function returns 2 for 1.5. I had to substitute the worksheet function in place of the VBA one.  Am I missing something?
98135
I have a sheet from which I want to get values from column A of every 30th row.   I tried =A(2+30) but it just gives me an error.
6582
I'm starting a 2D game where I want all the letters A-Z displayed in a random position and, then, the player collects them all in the correct order. I need to randomly instantiate the letters without overlapping. I use C#.
66459
I'm doing a spreadsheet for an event and I need to split a row into multiple rows. It's getting data from a form.  I need a script that can arrange the data like in the blue rectangle.
24487
How do I create a reference to a defined interval in several sheets?   Something like this: =SUM(Sheet1:Sheet2!A1)
113404
Very new to any form of code. Attempting to run a script in VBA that will pull data from an access database using SQL and put it into an excel spreadsheet. Code is similar to below. Runs clean but I don't know how to use the data it is pulling. Thanks in advance.   Sub Get_Data() Dim cn As Object Dim rs As Object Dim strFile As String Dim strCon As String Dim strSQL, strInput As String  strFile = "S:\Location.Database.accdb"  strCon = "Provider=Microsoft.ACE.OLEDB.12.0; Data Source=" &amp; strFile  Set cn = CreateObject("ADODB.Connection") cn.Open strCon  strInput = InputBox("Input Desired Name")  strSQL = "SELECT NAME, Location WHERE NAME =""'strInput'"";"  cn.Execute strSQL  cn.Close Set cn = Nothing  End Sub
55286
I have lots of cells that contain unique text.   I'd like to add a &lt;p&gt; to the start of the cell and a &lt;/p&gt; to the end of the string in the cell.   Turning this: Here is some text I've written. It's different in each cell. into this: &lt;p&gt;Here is some text I've written. It's different in each cell.&lt;/p&gt;  I've tried =CONCATENATE("&lt;p&gt;",A1) but can't find a way to add something to the end of the cell as well?
92159
I'm a Java head mainly, and I want a way to generate a pseudo-random number between 0 and 74. In Java I would use the method:  Random.nextInt(74)   I'm not interested in a discussion about seeds or true randomness, just how you accomplish the same task in Objective-C. I've scoured Google, and there just seems to be lots of different and conflicting bits of information.
72992
Let's say that I create a Sub (not a function) whose mission in life is to take the active cell (i.e. Selection) and set an adjacent cell to some value.  This works fine.  When you try to convert that Sub to a Function and try to evaluate it from from spreadsheet (i.e. setting it's formula to "=MyFunction()")  Excel will bark at the fact that you are trying to affect the value of the non-active cell, and simply force the function to return #VALUE without touching the adjacent cell.  Is it possible to turn off this protective behavior?  If not, what's a good way to get around it?  I am looking for something a competent developer could accomplish over a 1-2 week period, if possible.  Regards, Alan.  Note: I am using 2002, so I would favor a solution that would work for that version.  Having that said, if future versions make this significantly easier, I'd like to know about it too.
28216
I'm working on a game for my Minecraft server that includes the element of chance.  The idea is that there are 6 buttons. One of them (randomly determined by redstone circuitry) results in wealth, prizes, etc. The other five result in doom.  When you enter the room the doors close initiating the game and beginning the primary circuit which selects which of the 6 buttons is the winning button. How to actually make the circuitry do this is my problem! I've got the door controls, win/lose circuits, and the reset circuit to prepare the room for the next player all worked out, but I'm stumped on how to make redstone do something random.  How can I use redstone to choose one of the 6 buttons to be active, randomly?
32163
Is there an easy way in C# to create  for a number? For example:   1 returns 1st 2 returns 2nd 3 returns 3rd ...etc   Can this be done through String.Format() or are there any functions available to do this?