Top 5 Generator

Jan 14, 2010

my spreadsheet logs call references and total times, as well as the date.

All the data is stored in the worksheet 'Data' while I want this report to be generated under the worksheet 'Admin' - I do not want it to be live either, I would want it so you press a button to generate the report so the data does not change (hopefully making this easier in the process).

There are 2 things I want to do with the report, first is to log all the calls by date to generate an average per day. Secondly, I want to generate a list of the 5 longest calls so these can be reviewed.

View 9 Replies


ADVERTISEMENT

Time Generator

Oct 19, 2008

Im trying to write a spreadsheet to generate track times (anywhere from 9 seconds to 2 hours) for a RP. Im not really sure where to start, but if I can get a push on the start I can finish it out.

View 10 Replies View Related

Random Name Generator

Jun 20, 2009

I'd like a spreadsheet that pulls out a random name.

I'll put in a lookup table, George, Fred, Ralf, Steve, Peter.

Sometimes Fred will come up, sometimes George will.

View 14 Replies View Related

How To Set Up Random Name Generator

Jan 22, 2012

I need a formula that generates random names that i have in column a (a2:a30) I need the name to be in b1 to j1 there can't be any duplicate names

View 3 Replies View Related

QR Code Generator

Jan 25, 2013

I'm trying to make a simple 2 column sheet where column "A" cells some variable text and the cell right next to it is the QR equivalent of that text. I assume there some way that you can set it up as you populate each cell, the QR appears next to it....

I did the StrokeScribe plug in etc, but I can't find a way to reference the value of the QR from another cell. it only appears to let me change each QR by right clicking and changing it in the properites which is worthless.

View 5 Replies View Related

Password Generator

Jan 11, 2010

I got this code from this board and it works OK for generating 1 password. What I want to do is to generate X amount of passwords on to sheet2, so if I use cell B1 as the amount of passwords required it will generate that amount on sheet 2. I tried doing a loop, but had no luck with it, (Not ruling out user error at this end)

Sub PasswordGenerator()
Dim Password As String
Dim PasswordLength As Byte
Dim LC As Byte 'Loop Counter
Dim strRndmChr As String
Dim LAC As Byte 'Lowest Ascii Character
Dim HAC As Byte 'Highest Ascii Character
Dim UseSymbolics As Boolean
Dim HasSymbolics As Boolean
Dim RandomNumber As Byte

'Set parameters.
PasswordLength = 14...........

View 9 Replies View Related

Random Team Generator?

Jul 11, 2013

I am organizing a sports tournament and would like excel to randomly generate the teams for it.

We have 20 people who will be organized into 10 teams of two. how to setup the formula to have two people randomly paired together without duplication. The names will be further used in other formulas for points calculations.

So, I have the names as A1:A20 and then would like the teams generated from B1:B10 and C1:C10 with the team being the row and the team members in the B and C columns.

View 1 Replies View Related

Create Random Name Generator?

Mar 1, 2012

I am trying to create a random name generator. I have tried something like this...

=INDEX('TM Names'!$A$2:$A$36,INT(RAND()*35+1))

But sometimes it will give you the same name 2 or 3 times in a row. I need it to pull up a different name each time, from a list of names I already have.

View 7 Replies View Related

Random Generator With No Duplicates

Apr 18, 2013

In Column A I have a list of 8 team names.

In column AB I have a list of 28 weeks written in date format.

In column B I'd like to chose one week from the 28 weeks listed in AB at random. But B2 - B9 can not have the same date (ie could not have two dates for the 19th of April).

How exactly is that done?

Alternatively - is it possible to have in Column AA the 8 team names. In Column AB the 28 weeks. In Column A a random team picked from column AA and in Column B a random date picked from Column AB. Both column A and Column B can not have duplicates... There's 28 weeks with 8 teams - therefore I only need 8 unique weeks.

View 5 Replies View Related

Template For Raffle Generator?

Apr 23, 2014

I would like a template that allows me to create of a randomized raffle. How to create one, but need it for a raffle I am holding, where some participants have more tickets than others.

View 2 Replies View Related

Random Word Generator

Aug 22, 2007

Has anyone seen an Excel program that will generate words based on letters entered. For example, if I had 10 cells in a row, and each cell contained a letter (duplicates are okay), what words could be derived from arranging those letters in random sequences.

It would need the ability to accept any letter of the alphabet, A thru Z

E A L R C T S S U C
___ ___ ___ ___ ___ ___ ___ ___ ___ ___

How many words could it generate, and what are the words?
I assume it would have to reference a spelling dictionary.

It could be used as a spelling learning game, etc.

View 9 Replies View Related

Random Names Generator

Feb 12, 2008

I like to know if this can be done using vb.

If I have a list of names of associates B2 to B32. Can I randomize the list in any order.

Then if I need to want that list to only randomize B2 to thru B30
Then if I need to want that list to only randomize B2 to thru B28

And so forth.

Sort of being able to pick from a pop up message box or userform that will ask you how many names to randomize in that list.

View 9 Replies View Related

Lottery Number Generator

May 30, 2008

Does anyone know of an Excel macro or function that can generate say 1000 strings of 6 numbers from 1 to 49, without repeating the same combinations?

Kind of like the random picks that lottery machines generate.

View 9 Replies View Related

Random Password Generator

Jul 2, 2008

I wrote this to help me generate a random password for a workbook. I am happy with it so far, but I was wondering if there is a way, to shuffle the order of the variables? So, instead of MyPassword always being A, B, C, D, E etc

Sub RandPass()
Dim A As String, B As String, C As String
Dim D As String, E As String, F As String
Dim H As String, I As String, J As String
Dim K As String, L As String, M As String
Dim MyPassword As String
Dim v

ReDim v(33 To 47) As Variant
A = Chr(Int((UBound(v) - LBound(v) + 1) * Rnd + LBound(v)))..............

View 9 Replies View Related

Random Cell Generator ...

Nov 16, 2009

I have a list of 200 comments in column B (B1:B200). In a seperate sheet I want to be able to add a function that calls a comment randomly.

So evertime I hit F9 the comment changes.

View 9 Replies View Related

Random Letter Generator

Nov 25, 2009

I know how to use RAND for numbers, but is it possible to use RAND for letters?

View 9 Replies View Related

Random Winner Generator

Sep 19, 2006

I need a formula that can randomly pick a persons dependent on the amount of entries they have in a competition. For Example

PersonEntries
Andrew10
Jake15
Louisa4
Fuffy33

In the above case there is 62 entries into the draw. Andrew has 10 chances to win. Is there a formula that I can use that will decide a winner for me dependent on how many chances they have.

View 2 Replies View Related

Random Generator With Several Outputs

Feb 14, 2007

I need a formula to create random letters down a column: A-F. Probability of A=3%, B=6%, C=8%, D=11%, E=14%, F=16%. I've got it worked out to where each letter is a header of a column ("A" is in A1, "B" is in B1, etc.). My question is: how do I consolidate that in one column, so that, "A" for example, reads ABFCBACFBFBECEABCEABCEAFBCEFBCAFEBCFAEBFC...? I'm using the random number generator for the 6 columns...thx

View 5 Replies View Related

Random Message Box Generator

Mar 8, 2008

i want is a way, on clicking a button on my userform, where i can bring up a quote randomly picked from a list of quotes and sayings which I will input.

View 2 Replies View Related

To Make A Random Word Generator

Mar 30, 2009

I know you can make a random number generator pretty easily in excel...but is it possible to make a random word generator? I will give the words I want randomly generated.

View 12 Replies View Related

Random Picture Selector / Generator?

Aug 22, 2013

I have a database of at least 350 products, and would like to know how I can use a form button, when clicked it will randomly display a picture of one of the list of products. I want to use this method for a mystery prize draw.

View 14 Replies View Related

Random Word Generator From Dictionary?

Mar 17, 2014

create a macro that will generate 2 words from the dictionary. The first word needs to start with the letter B and the second word must start with the letter T.

View 1 Replies View Related

Convert List To Label Generator

Nov 8, 2012

I have a wedding list in rows in an excel sheet IE Name, Address, City, State, Zip

I want to transfer it to a text deliminated file in notepad, where it will appear as follows:

Name
Address
City, State Zip

how to accomplish this.

View 1 Replies View Related

Random 12 Team Schedule Generator?

Jun 17, 2013

I have 12 teams, 4 divisions of 3... they play each team in there division twice, and every other team once... What's the easiest way to make something to randomize this automatically? This is for a contest at work that starts over every 13 weeks.

Obviously there can't be any duplicates week to week.

WeekABCDEFGHIJKL
1BAAEDDHGGKJJ
2BAAEDDHGGKJJ
3CCBFFEIIHLLK
4CCBFFEIIHLLK
5DDDAAAAAAAAA
6EEEBBBBBBBBB

[code]....

View 5 Replies View Related

Random Generator For Creating A Test

Jul 27, 2014

I am looking for a product that uses excel to create a random test form a bank of questions. I have 50 questions in all and I need a random test of 35.

I can and have messed around with the following. Excel 2012
A
B
C
D

1
Random #
Test Number
Small-Sort
Random Question

I could even shorten it a bit by placing like this. MATCH(SMALL($A$2:$A$4,B2),$A$2:$A$4,0). Of course this is only the start and it would have in column B 1-50 and in column C&D 1-35 for the selection process. Then I was going to set up on sheet 2 my list of questions 1-50 and my idea was to use 1.1, 1.2, 1.3, & 1.4 for the answers to question 1 and then vlookup. so that when and if question 1 is part of the 35 random then I could pull the answers over as well. but as I started the 'animal' will get bigger and bigger fast.

View 1 Replies View Related

Random Number Generator From 1 To 7 Other Than Cell Value

May 12, 2007

I have a range of cells that have values from 1 to 7 in them. What I would like to do is to have the next column generate a random number from 1 to 7 that does not generate the number that the cell next to it has. for example if cell A1 has 6 in it, I would like cell b1 to generate a random number other than 6 in it. if cell A2 has 3 in it then cell B2 would generate a number other that 3 (1,2,4,5,6, and 7).

View 9 Replies View Related

Random Generator, Change A Line Or Two

May 17, 2008

I have a random Generator but it only generates values that are different, is it possible to change a line of code to allow it to duplicate the same number? Here is the code I have and it works great but not for duplication:

Sub Unique_Numbers()
Dim x As Long, y As Long, z As Long, tempnum As Long
Dim flag As Boolean
Dim i As Integer
Dim foundCell As Range
Application.ScreenUpdating = False
x = Application.InputBox("Enter starting Random Number" _
, "Random Number Generation", 1, , , , , 1)
y = Application.InputBox("Enter ending Random Number" _
, "Random Number Generation", 1000, , , , , 1)
z = Application.InputBox("How many random numbers would" _
& "you like to generate (

View 9 Replies View Related

Basic Random Number Generator

Oct 9, 2008

how to create a basic random number generator within an excel spreadsheet?

Basic Lower limit = 0
Basic Upper limit = 100

View 9 Replies View Related

Random Number Generator Formula

Jan 27, 2009

I have 4 names, and a grid of 100 boxes. I need those 4 names randomly deposited in the 100 boxes, making sure each name is displayed an equal number of times (25 each) Is there an Excel formula to compute this?

View 9 Replies View Related

Random Group Generator Tonight

May 2, 2009

I am to supply this tomorrow!! I have a column of 60 names that I need to break into 15 groups of 4. {this is actually for making a group of 4 names to get together each month for a dinner discussion} I need to generate a random mix so that each month everyone is with someone new until it begins to overlap. I am a relative elementary user of excel but understand that in some manner the "RAND"[?] function.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved