#excel randbetween function

[eyescananalyze]

EXCEL - Formulas and Functions - Maths - randbetween #viralvideo #viralv...

[rehanaakter]

How to Generate Random Numbers with RANDBETWEEN Function in Excel  Hello everyone, Today I will present you, How to Generate Random Numbers with RANDBETWEEN Function in Excel. If this video useful to you please give it a Thumbs-Up and Subscribe to this channel so that you will notified as soon as we release another tutorial. If you have any special tutorial requests, please post them below this video. Facebook Page: https://www.facebook.com/Eot89 Twitter: https://twitter.com/RehanaDhaka1216 Please, Subscribe to My Channel: https://www.youtube.com/channel/UC-pus296zbGdNpffiuaVDvg #Microsoft_Excel #Microsoft_Excel_tutorial #randbetween_function_in_excel #how_to_generate_random_numbers_in_excel #Generate_Random_Numbers_with_RANDBETWEEN_Function_in_Excel

[esytes-encyclopedia]

The Excel Formulas You Need to Know to Save Time

There are numerous Excel formulas that can be useful in various situations, but here are some essential Excel formulas that most users should know: SUM: Adds up all the numbers in a range of cells. Example: =SUM(A1:A5). AVERAGE: Calculates the average of a range of numbers. Example: =AVERAGE(B1:B10). MAX: Returns the largest number in a range. Example: =MAX(C1:C20). MIN: Returns the smallest number in a range. Example: =MIN(D1:D15). COUNT: Counts the number of cells that contain numbers in a range. Example: =COUNT(E1:E30). IF: Performs a conditional operation. It returns one value if a condition is true and another if it's false. Example: =IF(A1>10, "Yes", "No"). VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from a specified column. Example: =VLOOKUP(G1, A1:B10, 2, FALSE). HLOOKUP: Similar to VLOOKUP, but searches horizontally in a table. Example: =HLOOKUP(G1, A1:G10, 3, FALSE). INDEX and MATCH: Used together, these functions can perform powerful lookups. INDEX returns a value from a specific row and column in a range, and MATCH searches for a value in a range and returns its relative position. Example: =INDEX(A1:B10, MATCH(G1, A1:A10, 0), 2). CONCATENATE (or CONCAT): Combines text from multiple cells into one cell. Example: =CONCATENATE(A1, " ", B1). LEFT and RIGHT: Extracts a specified number of characters from the left or right of a cell's content. Example: =LEFT(A1, 3). LEN: Returns the length (number of characters) of a text string. Example: =LEN(A1). TRIM: Removes extra spaces from text. Example: =TRIM(A1). DATE: Creates a date value. Example: =DATE(2023, 9, 7). TODAY: Returns the current date. Example: =TODAY(). NOW: Returns the current date and time. Example: =NOW(). SUMIF: Adds up all numbers in a range that meet a specified condition. Example: =SUMIF(B1:B10, ">50"). COUNTIF: Counts the number of cells in a range that meet a specified condition. Example: =COUNTIF(C1:C20, "=75"). IFERROR: Returns a custom value if a formula generates an error. Example: =IFERROR(A1/B1, "N/A"). SUMIFS: Adds up numbers in a range that meet multiple conditions. Example: =SUMIFS(B1:B10, A1:A10, "Apples", C1:C10, ">10"). COUNTIFS: Counts the number of cells that meet multiple criteria. Example: =COUNTIFS(A1:A10, "Bananas", B1:B10, ">5"). AVERAGEIFS: Calculates the average of a range based on multiple criteria. Example: =AVERAGEIFS(D1:D15, E1:E15, "Red", F1:F15, ">50"). IF, AND, OR: Combining these functions can create more complex conditional statements. Example: =IF(AND(A1>10, B1="Yes"), "Pass", "Fail"). SUMPRODUCT: Multiplies corresponding components in arrays and returns the sum of those products. Example: =SUMPRODUCT(A1:A5, B1:B5). TEXT: Converts a number into text with a specified format. Example: =TEXT(NOW(), "dd-mmm-yyyy hh:mm:ss"). PROPER: Capitalizes the first letter of each word in a text string. Example: =PROPER("john doe"). UPPER and LOWER: Converts text to all uppercase or all lowercase. Example: =UPPER("hello") and =LOWER("WORLD"). SUBTOTAL: Performs various aggregate functions (e.g., SUM, AVERAGE) on filtered data sets. Example: =SUBTOTAL(109, B1:B100). RANK: Returns the rank of a number within a list. Example: =RANK(A1, A1:A10, 1). ROUND: Rounds a number to a specified number of decimal places. Example: =ROUND(A1, 2). ROUNDUP and ROUNDDOWN: Round a number up or down to the nearest specified decimal place. Example: =ROUNDUP(A1, 0) and =ROUNDDOWN(B1, 1). PI: Returns the mathematical constant Pi (π). Example: =PI(). RAND and RANDBETWEEN: Generates random numbers. RAND() returns a decimal between 0 and 1, while RANDBETWEEN(min, max) generates a random integer within a specified range. DAYS: Calculates the number of days between two dates. Example: =DAYS(B1, C1). NETWORKDAYS: Calculates the number of working days between two dates, excluding weekends and specified holidays. Example: =NETWORKDAYS(B1, C1, holidays). DGET: Retrieves a single value from a database based on specified criteria. PMT: Calculates the monthly payment for a loan based on interest rate, principal, and term. Example: =PMT(0.05/12, 5*12, 10000). NPV: Calculates the net present value of a series of cash flows based on a discount rate. Example: =NPV(0.1, C1:C5). IRR: Calculates the internal rate of return for a series of cash flows. Example: =IRR(D1:D5). Conclusion: In conclusion, Excel offers a rich arsenal of formulas and functions that cater to a wide range of data manipulation and analysis needs. The formulas and functions listed in the previous responses cover the fundamentals, from basic arithmetic calculations to conditional statements, text manipulation, and advanced financial and statistical analysis. Familiarity with these Excel formulas empowers users to efficiently manage data, perform calculations, and derive valuable insights. Read the full article

[sophuccom]

The RANDBETWEEN Function is categorized under Excel Math and Trigonometry functions. The function will return a random integer number between the user-specified numbers. It will return …

[goaskdebbie]

In this Excel Tutorial: How to Select Your Lottery Numbers, we use the Excel Function =RANDBETWEEN to generate random numbers. I will actually show you 3 Ways to select your Lottery Numbers using Excel functions.

[makeover-blog1]

Learn MS Excel Formulas and Functions. Create Basic and Advanced Excel Formulas….

Learn MS Excel Formulas and Functions. Create Basic and Advanced Excel Formulas. Make an Excel Template Project. What you’ll learn Learn Excel Formulas and Functions from Zero. Learn how to build a professional level Excel Template using Excel functions. Requirements Microsoft Office Software Installed. Description Teaching11Courses on Excel and Data Analysis! OVER25000 visitors visit my blog ExcelDemy dotcom every month!! OVER 15000successful students have already takenmy online courses since November 2015with375totalReviews!!! Course Updated:Nov 01.2016 Excel formulas and functions are the heart of Microsoft Excel spreadsheet. They are essential to manipulating data and obtaining useful information from your Excel workbooks. Without Excel formulas and functions Excel spreadsheet would simply be a fancy word-processing document. Welcome to my Excel Formulas and Functions course. Lets discuss now what you will learn from this course. Operators and Precedence of Operators: I will start from zero and if you dont know about the operators and precedence of operators that Excel uses in its formulas then it will be tough for you to decode complex Excel formulas. So I have covered them in very details. How to use built-in Excel functions: Then you will learn how to use built-in excel functions into the Excel formulas using the Insert Function and Function Arguments dialog box. Subtotal Function: You will find many uses of Subtotal function if you are using Excel with your finance related jobs. So this function is covered in details at the start of the course. Relative Absolute and Mixed Cell References: You will work with these three concepts time to time when you will build excel formulas. So they have got a good time in the course. Formulas with Tables: Understanding how formulas work with Excel tables is very important. I have used two lectures to cover Excel formulas with tables. In the second lecture structured referencing with Excel tables has been discussed. Then you will learn how to handle circular references with Excel formulas how named cells and ranges work with Excel formulas and so on. Mathematical functions are very important in your daily work with finance or any kind of jobs. In this course you will learn about SUM AVERAGE MAX MIN INT MOD ROUND RAND and RANDBETWEEN Excel functions. Counting related excel functions are also covered in this course. Then you will work with 3-D Referencing with Excel Formulas. In Advanced Excel formulas you will learn: IF IFERROR DATE related functions Text manipulating functions and many more. Manipulating Text using Excel Functions: There is a section where you will learn how to manipulate text using Excel formulas and functions. Then you have worked with VLOOKUP INDEX and Array formulas. And at the end of the course you will build a professional Excel template where you will learn how to make complex Excel formulas using Excel functions. Here is not the end of the course. Time to time I shall add more lectures to the course that will teach you how to face real life problems using Excel formulas and functions. =====> CLICK HERE TO ENROLL FOR FREE <=====

The post Learn MS Excel Formulas and Functions. Create Basic and Advanced Excel Formulas…. appeared first on Good Info.

[doug-lewars]

Fantasy Critter

For a writer, lists can be useful. For example the following is a Wikipedia list for vertebrates:  https://en.wikipedia.org/wiki/Category:Lists_of_vertebrates   You can also obtain lists for invertebrates and plants. Why might you want such things? Consider the following: in an excel spreadsheet you have a list of, say, 50 vertebrates in column A, 75 invertebrates in column B and 200 plants in column C all starting at row 1. Now suppose you have the following functions starting at row 1 in columns D, E and F.

=Randbetween(1,50)         =Randbetween(1,75)       =Randbetween(1,200)

=Concatenate(”A”,D1)        =Concatenate(”B”,E1)      =Concatenate(”C”,F1)

=Indirect(D2)                      =Indirect(E2)                    =Indirect(F2)

Now you’ve identified a random vertebrate, invertebrate and plant. Do a search to find the general characteristics of each and voila, you can combine them into a new fantasy critter for your story.

[pptx-xlsx-templates]

How To Do Random Sampling In Excel Through Formula

How To Do Random Sampling In Excel Through Formula

There are a few different ways you can do random sampling in Excel using formulas: RANDBETWEEN function: This function generates a random integer between two given numbers. For example, to get a random number between 1 and 100, you can use the formula =RANDBETWEEN(1,100). You can use this function to generate a set of random numbers, and then use those numbers to select a random sample from your…

[tonkitk]

Numpy random permute

#Numpy random permute full

Returns outndarray Permuted sequence or array range. axisint, optional The axis which x is shuffled along. If x is an array, make a copy and shuffle the elements randomly. Parameters xint or arraylike If x is an integer, randomly permute np.arange (x). To permute both rows and columns I think you either have to run it twice, or pull some ugly shenanigans with numpy.unravel_index that hurts my head to think about. Randomly permute a sequence, or return a permuted range. PVec0, pVec1 = calcMyPermutationVectors()Īrr.take(pVec0, axis=0, out=arr, mode="clip")Īrr.take(pVec1, axis=1, out=arr, mode="clip") Numba supports top-level functions from the numpy.random module. So in total you call should look something like the following: #Inplace Rearrange On a final note, take seems to be a array method, so instead of np.take(i, rr, axis=0) If x is an integer, randomly permute np.arange (x). If x is a multi-dimensional array, it is only shuffled along its first index. If you don't set the mode it will make a copy to restore the array state on a Python exception (see here). Randomly permute a sequence, or return a permuted range. To do it in-place, all you need to do is specify the "out" parameter to be the same as the input array AND you have to set the mode="clip" or mode="wrap". Here is an example of doing a random permutation of an identity matrix's rows: import numpy as npĪrray(, We are using Excel’s RANDBETWEEN functions for Column B here. axisint, optional Slices of x in this axis are shuffled. Parameters xarraylike, at least one-dimensional Array to be shuffled. Unlike shuffle, each slice along the given axis is shuffled independently of the others. The trick here is we pre- generate the random m’s. method (x, axisNone, outNone) Randomly permute x along axis axis. You can do this in-place with numpy's take() function, but it requires a bit of hoop jumping. For simplicity, we assume N 5, but this methodology works with any N (as long as Excel can hold it) First, you need to set up k’s and m’s.

#Numpy random permute full

Warning: The below example works properly, but using the full set of parameters suggested at the post end exposes a bug, or at least an "undocumented feature" in the numpy.take() function. I currently copy matrices this large unnecessarily, but I would hope this could be easily avoided for permutation. Actually I would like to use matrices as large as possible, but I don't want to deal with the inconvenience of not being able to hold them in RAM, and I do O(N^3) LAPACK operations on the matrix which would also limit the practical matrix size. The matrix is small enough to fit into desktop RAM but big enough that I do not want to copy it thoughtlessly. shuffle: the order of the sub-arrays along the first axis, but the content remains the same, which is equivalent to. Or they mean counting or enumerating all possible permutations. Sometimes when people talk about permutations, they only mean the sampling of random permutations, for example as part of a procedure to obtain p-values in statistics. Also for some simple situations it may be sufficient to just separately track an index permutation, but this is not convenient in my case. Something like this might be possible with numpy's "advanced indexing" but my understanding is that such a solution would not be in-place. Maybe I am just failing at searching the internet. Now, let x be a permutation of the elements of x. Right now I am manually swapping rows and columns, but I would have expected numpy to have a nice function f(M, v) where M has n rows and columns, and v has n entries, so that f(M, v) updates M according to the index permutation v. Write a Python program to print all permutations of a given string (including. Given a 2D array, I would like to permute this array row-wise. Mathematically this corresponds to pre-multiplying the matrix by the permutation matrix P and post-multiplying it by P^-1 = P^T, but this is not a computationally reasonable solution. Efficiently permute array in row wise using Numpy. np.ed is a function, which you need to call, not assign to it. Julia sample without replacement.I want to modify a dense square transition matrix in-place by changing the order of several of its rows and columns, using python's numpy library.

[pinerteach]

Microsoft random password generator

MICROSOFT RANDOM PASSWORD GENERATOR HOW TO

MICROSOFT RANDOM PASSWORD GENERATOR GENERATOR

MICROSOFT RANDOM PASSWORD GENERATOR PASSWORD

If we use the formula =CHAR(33), we will output an exclamation point. For example, the formula =UNICODE(“!”) returns the value 33.

How do I know what numbers to use for a particular character?Įxcel has a built-in function called UNICODE that can return the number that corresponds to a specified character.

We can use different ranges to create a mix of lowercase letters, uppercase letters and numbers.

Next, we’ll repeat the same process and concatenate both results using the ampersand symbol ‘&’.

To pick uppercase characters, we’ll use the range 65 to 90. For this example, we want to first output a random uppercase letter.

Since the CHAR function should have a random integer as an argument, we’ll have to use the RANDBETWEEN function.

Next, we simply type the equal sign ‘ = ‘ to begin the function, followed by ‘ CHAR( ‘.

MICROSOFT RANDOM PASSWORD GENERATOR PASSWORD

In this example, we’ll be outputting our password in cell B1. First, let’s select the cell that will hold our generated password.You’ll learn how we can use the CHAR and RANDBETWEEN functions to create a string composed of randomly selected characters automatically.

MICROSOFT RANDOM PASSWORD GENERATOR GENERATOR

This section will guide you through each step needed to create a random password generator in a spreadsheet. How to Quickly Generate Random Password in Excel If you’re ready to try setting up your own password generator in Excel, read the next section to follow our step-by-step guide. You can make your own copy of the spreadsheet above using the link attached below. One limitation to this method is that the string will always be a fixed length. To create our final password, we simply concatenate multiple instances of the CHAR function. For example, the formula =CHAR(RANDBETWEEN(97, 122) can return any lowercase letter. We use the RANDBETWEEN function to choose a random integer in a specified range. This means that =CHAR(65) will return an ‘A’. For example, the uppercase letters from ‘A’ to ‘Z’ are in the range 65 to 90. The CHAR function accepts an integer value as an argument and outputs the corresponding Unicode character. To get the values in Column A, we just had to use the following formula: =CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(65,90))&CHAR(RANDBETWEEN(97,122))&CHAR(RANDBETWEEN(65,90)) The last column introduces special characters such as ‘+’ and ‘*’ to add even more security. The second column generates alphanumeric passwords. The first column creates a five character long string composed of only letters. In the example below, we have three columns with different types of generated passwords. Let’s take a look at a real example of a spreadsheet that can quickly generate a secure password in Microsoft Excel Since we now know when it’s useful to create random passwords in Excel, let’s take a look at a sample spreadsheet that uses a formula to generate them.Ī Real Example of Quickly Generate Random Password in Excel We can similarly use the same technique to create random PIN codes of arbitrary length. The CHAR function and RANDBETWEEN function will help us randomly pick letters, numbers, and symbols. The trick to create the randomized string is to build it one character at a time. For example, we could indicate that we want the first 5 characters to be letters, the next two to be numeric, and the last character being either a ‘!’ or a ‘?’. We can use Excel to quickly generate a list of random passwords of a specified length. You plan on giving each of these files a randomly generated password before sending. zip files that you would like to send out via email. Let’s take a look at a use case where you might have to generate several secure passwords at once. For example, the password ‘dQw4w9WgXcQ!’ is more secure than ‘qwerty123’.

MICROSOFT RANDOM PASSWORD GENERATOR HOW TO

How to Quickly Generate Random Password in Excelīecause of the hacking risks, it is recommended to use passwords that have a combination of uppercase and lowercase letters, numbers, and special characters.

A Real Example of Quickly Generate Random Password in Excel.

[mainslion]

Random data generator excel

RANDOM DATA GENERATOR EXCEL TRIAL

RANDOM DATA GENERATOR EXCEL PASSWORD

Show Unlocked, Locked Cells by different colors Highlight Cells That Have Formula/Name.

Pivot Table Grouping by week number, day of week and more.

Combine Workbooks and WorkSheets Merge Tables based on key columns Split Data into Multiple Sheets Batch Convert xls, xlsx and PDF.

If the rows or columns arguments are decimal numbers, they will be truncated to the whole number before the. There are five arguments in the RANDARRAY function, all of them are optional, if none of the arguments is specified.

Super Filter (save and apply filter schemes to other sheets) Advanced Sort by month/week/day, frequency and more Special Filter by bold, italic. Generate random numbers, texts, dates in Excel 365 / 2021 1.

Extract Text, Add Text, Remove by Position, Remove Space Create and Print Paging Subtotals Convert Between Cells Content and Comments.

RANDOM DATA GENERATOR EXCEL PASSWORD

Favorite and Quickly Insert Formulas, Ranges, Charts and Pictures Encrypt Cells with password Create Mailing List and send emails.Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.Merge Cells/Rows/Columns and Keeping Data Split Cells Content Combine Duplicate Rows and Sum/Average.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by

RANDOM DATA GENERATOR EXCEL TRIAL

Click for full-featured free trial inģ00 handy Excel add-ins, free to try with no limitation in With this Advanced Combine Rows of Kutools for Excel, you can quickly combine same values / same data or duplicate rows into appropriate cells. Supposing you are working with a worksheet which contains multiple duplicate records, and now you need to combine / merge the rows based on the same value and do some calculations, such as sum, average, count of the duplicate rows. Easily Combine/Consolidate data based on same value in Excel The calculated results will not be fixed, they will be recalculated if there is any change to the workbook. Then the list of data has been randomly assigned to groups, and each group may have different numbers of data. Then drag fill handle down to randomly assign data into groups. In the formula, (1, 3) indicates to group data into 3 groups, Group A, Group B and Group C are the texts will be displayed in formula cells which used to distinguish different groups. =CHOOSE(RANDBETWEEN(1,3),"Group A","Group B","Group C ") Select a blank cell next to the list you want to assign to random groups, copy or type this formula If you want to randomly assign data to a specified number of groups, each group is allowed with different numbers of data, you can use the CHOOSE and RANDBETWEEN functions.

[zanynickelempathfarm]

Click here 👇

https://youtu.be/ywWdhVJsG_E

👆Rank & Choose Function In MS-Excel Along With Sum, Randbetween And If Function As Well As Conditional Formatting.

Please subscribe the channel and watch more exclusive videos.

#exceltricks #exceleducation #Education #Education #nursingg

#Computertyping

#technolodgy

#tips&triks

#Computeranimation

#basicexcel

#Technicalcourses

#Microsoftkin

#PowerPoint

#exceltips

#ExcelTricks

#FYI

#science

#virtualreality

#news

#discoverychannel

#discovery

#Computers

#Educacion

#cybersecurity

#MS

#Excel

#computer

#Team

#technology

#Advance

#engineering

#misexecutive

#management

#technicalanalysis

#Data

#database

#dataanalyst

‪#MicrosoftTeams

#discoverychannelindia

#ExcelenteMartes

#informacion

#Microsoft

#DataScience

#Team,

#technology,

#Advance,

#engineering,

#PowerPoint,

#misexecutive,

#management,

#technicalanalysis,

#Data,

#database,

#dataanalyst,

#5G

#MS,

#Excel,

#machinelearning

#tuesdayvibe

#CloudComputing

#bigdata

#Microsoft365

#MicrosoftEDU

#XRP

#Lifestyle

#Automobile

#Business

#Cricket

#World

#Politics

#Sports

#Entertainment

#computer,

[gvtacademy]

Get  Advanced Excel Training Institute in Delhi, Noida – GVT Academy

Microsoft Excel is a general purpose electronic spreadsheet to use to organize, calculate, and analyze data. The task you can complete with Excel ranges from preparing a simple family budget, preparing a purchase order, create an elaborate graph/chart, or managing a complex accounting ledger for a medium size business.

 Provide Basic/Advanced Understanding of Excel, make user familiar to create formula and give platform to make good analysis and introduce Powerful tools of advance excel so that user can make advance analysis with the help of those tools. Introduction to Excel, Basic Understanding Menu and Toolbar, Introduction to different category of functions like Basics, Mathematical and Statistical, Date and Time, Logical, Lookup and References, Text and Information.

Mathematical Functions:- Sum, Sumif, Sumifs, Count, Counta, Countblank, Countif, Countifs, Average, Averagea, Averageif, Averageifs, Subtotal, Aggregate, Rand, Randbetween, Roundup, Rounddown, Round, Sumproduct

Text Functions & Data Validation:- Char, Clean, Code, Concatenate, Find, Search, Substitute, Replace, Len, Right, Left, Mid, Lower, Upper, Proper, Text, Trim, Value, Large, Small Filters (Basic, Advanced, Conditional), Sort (Ascending, Descending, Cell/ Font Color), Conditional Formatting, Data Validation, Group & Ungroup, Data split.

Statistical Function & Other Functions:- Isna, Isblank, Iserr, Iseven, Isodd, Islogical, Isytext, Max, Min, Len, Right, Left, Mid, ,Maxa, Maxifs, Median, Minifs, Mina, Vara, Correl, Geomen

Logical Functions:- And, Or, If, Iferror, Not, Nested If

Lookup & Reference Functions:- VLookup, HLookup, Index, Match, Offset, Indirect, Address, Column, Columns, Row, Rows, Choose, Arrays Concept In Lookup Formula’s, Past Special, Past link

Pivot Table and Charts, Import and Export data, Protect/Unprotect sheets/workbooks. Worksheet formatting and Print Display

Data Collection Method With Data Quality, Collaboration & Security Like Share Your Workbook On Share Drive With Quality

Analysis Single/Multidimensional Analysis, Like Three Dimensional (3D) Tables, Sensitive Analysis Like Data Table, Manual What-If Analysis, Threshold Values, Goal Seek, One-Variable Data Table, Two-Variable Data Table

Advanced Excel training course involves "Hands-on experience", we believe in practice what you preach and therefore each candidate is encouraged to practically conduct each topic that is discussed for better understanding of real-world scenar Advanced Excel. This practice of comprehensive training allows candidate to gain all the concepts and skills effectively and to later efficiently apply on their field of work.

GVT Academy is one of the best Advanced Excel training institute in Noida with 100% placement assistance. GVT Academy has well structure modules and training program designed for both students and working professionals separately. At GVT Academy Advanced Excel training is conducted during all 5 days, and special weekend classes. can also be arranged and scheduled. We also provide fast track training programs for students and professionals looking to upgrade themselves instantly.

Get in Touch:

Email: gvtacademy@gmail.com

Call: +91 9718394718

[multimask]

Excel has a random function (RAND)

Excel also has a random btwn two entered numbers function (RANDBETWEEN)

Rolling set dice combinations (for like healing potions) have set minimum and maximum values.

This means I could theoretically make excel roll stuff for me if I made it right and also have the worksheet double as an easy reference for what dice to roll

[kookriart]

Making a random prompt generator in Google sheets

Random generators are fun, but I sometimes found myself mashing through online random prompts and never getting anything particularly in line with my interests. So here’s a super easy thing you can do in google sheets (and probably excel but I dunno) even if you’re as programming illiterate as me, to populate a generator only with things that suit your goals/interests. I’m sure somebody with the know-how can do a way better job, but hey.

Step 1 - Filling columns 

You can have as many as you want, really. For mine I had four, but I don’t necessarily use all four every time - the more you use, the more bizarre the outcome will probably be. I picked four things: Descriptors, Genres, Settings, Subjects. As you can see mine occupy columns A through D. There’s some crossover in mine, but you could be more organized if you wanted. Crossover doesn’t matter too much but you might get redundant prompts like “crime criminal”. So here’s an example of what I have (the color coding isn’t necessary, just handy).

Step 2 - Generating Prompts

So you’ve got your lists and your column headings. Now list your column headings again a few columns beside your list. This is where your random prompts will populate. I put mine in H through K but you could put them anywhere you want. 

Directly below your first heading (in my example below, column H row 2), you want to enter (approximately) this:

=indirect(CONCATENATE("A",randbetween(2,85)))

What this basically does is picks a random choice in column A between row 2 (which would be ‘loyal’) and 85 (which is off the screen but the last row I filled for the 'descriptors’). So if you only have 30 prompts in row C, you would instead do CONCATENATE("C",randbetween(2,30)))

Repeat this function for each column, changing the column and number of prompts to fit. You’ll need to update the numbers if you add anything to your list for it to show up, just so you know. Anyway, now whenever you change anything in the sheet, it will randomly generate prompts like this:

Personally, I prefer to mix and match one or two rather than trying to do all of them. So you can get stuff like Lovecraftian Troll or Victorian Troll.

I know it’s a little primitive, I’m sure someone with an ounce more savvy could program it to generate with a button rather than entering a value on the sheet, but as it is even a sloth could do it.