generate

I wanted to see if there is a way to create a button in excel. When clicked on it will give an outcome based on an average. For instance, if in a cell I had the average of a batter in baseball. Would I be able to create a formula to calculate if an at bat results in a hit or an out when a button...

Hello all, I have been racking my brain for a few days trying to solve an issue with a spreadsheet that I am having. There is a list generate by a formulas (From True/False) that returns the result, but I need it to filter out blanks and make a consecutive list. See an example below with the...

It's early morning here and brain not in gear. In Excel, I need a formula to generate an integer depending upon the column number. Starting at column 3, the integers are simply 1,2,3. Column 3 : Integer 1 Column 5 : Integer 2 Column 7 : Integer 3 and so on. I'll be embarrassed when I see it...

I just have a quick question. I have a sum that I want divided up randomly 25 times. For example: The sum is 25000 and I want excel to divide it up 28 times with different values. Is there a formula or macro for something like that? Thanks in advance!

I need to generate a formula on the fly based on thelast entry in the worksheet. I have the last row number thanks to a posting byPeter_SSs; =MATCH(TRUE,INDEX(A2:A3200="",0),0). I found in reading olderpost. Thanks Peter. This last row number is in H1, the array of datais B2:Fnnn last row number...

Hi All, I'm fairly new to VBA work in Excel, but I'm learning quickly. I've sorted out how to generate a new workbook from a template excel file, but I'm struggling to sort out how to generate two different new workbooks from two different excel template files (named Template1 and Template2)...

I have a specific code structure that I would like to be automatically generated based off of text from other columns in the same row. The code Structure is: XX.XXXX.XXXX (PROCESS AREA . COMPONENT/DISCIPLINE . ITEM) The first two digits are meant to represent an "Area" (##.XXXX.XXXX) The next...

Hello I'm a total novice excel user but have a need at work that I'm hoping we can use excel to solve. We need to create one place where 3 separate people can log applications taken from our customers - excel workbook. To that end, they all need a unique identifier that we don't want them to...

Hi there, How do i generate a set of data using exponential distribution with a mean of 10? Thank you!

Generate 3 digit training (pick3) Have one of the 10 pairs with consecutive digitios The ten = pairs = 01 12 23 34 45 56 67 78 89 90 Example 126 712 192 821 291 214 Note that the consecutive pair (12) had 6 formations Rotating in the 3 positions inside the pick3 From left to right is also...

I would greatly appreciate help for a problem that I don't think is too difficult but my VBA are still ramping up. My objective is based on the picture of the table below: For the table below, using VBA produce 36 (F5) unique and random numbers between 1 and 70 (F3) Sorted from lowest...

Hi I like to generate Range FROM and TO Values in Column B and C from Column C as shown in below. What will be formula which will achieve same ? Basically I want to create range for all Continuous values and create range in Column B/C Col A Col B ColC <colgroup><col...

Hi, I have a datasheet where the value in column A is repeated several times, columns B-G are different uses and specifications for the item in column A, I want to populate a userform with all the rows (A-G) where the value in column A is the same. Column A is sorted so all the duplicate values...

In order to find the rows of table A that are NOT in Table B, one can use M in a query. e.g., Table.NestedJoin(Employee,{"EmpID"},#"Employee Salary",{"EmployeeId"},"Employee Salary",JoinKind.LeftAnti) How can it be done in DAX, perhaps using GENERATE. GENERATE or GENERATEALL makes it easy to...

Hello All, Please let me start by saying that this is my first post after years of using these forums to learn excel when I only knew "Sum(A1:B2)". Thank you! I have spent a couple of days going through the best way to code something I have made to make my life easier at work. Essentially what...

Hi Guys, is there anyone know modulus 11 excel formulae to generate 7th digit. Please see below formulae that i tried and it didn't work. =MOD(SUM(B1:G1*B2:G2),11)=0 Below is Actual calculation. Example: find the check digit for the number 036532 <tbody> 3 6 5 3 2 x7 x6 x5 x4...

Hi. I have a permit tow work from created for external engineers attending site in excel. I would like the form to generate a unique ID when it is printed out or saved. Is this possible? Thanks, Ash.

how can i generate regex pattern without going through a lot of trouble of deciphering it. is there any software that generates pattern based on the example input given by user?

Ciao All ~ Is it possible to generate / create a sequence of binary numbers, that cannot repeat more than twice, based on an entered ratio x:y? if not a ratio, than perhaps two percentages equal to 100%? For example, a 2:1 ratio would generate a 12 cell pattern of : 1,1,0,1,1,0,1,1,0,1,1,0...

Hi, I am trying to think of ways that i can take a block of numbers say 10 col, 10 row. I intend to somehow 'profile' a completed table of numbers and then produce a replica set but slightly different following the same profile (i dont know how else to say it.) You can see there is a trend, how...