Letters randomly input into certain cells

[TOM R]

This is a scoring game that needs tweaking.

I need a code for random issuing of letters or numbers.
But with backwards elimination. If, a certain word is filled in any of cell or cells in D3 thru D13.

Letters would be random double A and random double B, random double C, and random double D, and single letter E.
Below is a explanation.

Explanation: If it’s… Even amount of teams no team gets a bi.
Odd amount of team’s one team will have a bi.

There up to the most 8 rounds for 9 teams.
15 points and above equals a WIN
14 points and below equals a LOSS

If odd amount of teams in that round a team gets the B for Bi
If a team has two losses they are out of the game completely.

The highest letter E would get the bi for that round of play if no team is
out.

Then if a team is out it then would be E would be eliminated.
If two teams go out in the round or even three and E is eliminated. Then D
then D then C then C then B then B then A. the only one team is left.

It's a process of elimination depending on what team is left in the game.
The highest letter is eliminated 1st and so on depending on the amount of teams eliminated.

The problem is the random picks of any round in column D3 thru D11 if, a
team is out. Then the assigning of letters are not always in pairs from A, A
to B, B ect.. For teams left in the game. Once one of them cells is filled
with "OUT" which is filled in the cell by the scoring of the rounds with two
losses. Were you able to open the excel file. And see any of it.

I really appreciate anyone contacting me I hope this will explain it to
some degree.

Thanks Tom

2007 HORSESHOE 18 PLAYER BRACKET (VBA TEST 31) demo.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2				TEAM MATCHES	1ST ROUND W/L	SCORE	2ND ROUND W/L	SCORE	3RD ROUND W/L	SCORE
3				E	**** LUCK	B	WIN	15	LOSS	12
4	This is just A small portion of this sheet. I could not get the html maker to fit the rest.			B	WIN	15	LOSS	12	WIN	15
5	The letters are created in column D3-D11 randomly from random team matches sheet.			A	LOSS	12	WIN	16	WIN	15
6	As you can see the team in d6 and D9 is out. In round 3 Now A new random pick is needed.			OUT	WIN	17	LOSS	14	OUT	12
7	The two cells = OUT so the next random team order would be A,A B,B, C,C and single D in any random cell except for D6 and D9			D	WIN	18	LOSS	13	**** LUCK	B
8				A	LOSS	8	WIN	15	WIN	17
9				OUT	WIN	15	LOSS	11	OUT	12
10				B	LOSS	10	**** LUCK	B	WIN	15
11				C	WIN	18	WIN	15	LOSS	12
TEAM SCORES

 

[Legacy 68581]

random letter

Hello,
would that help?
=CHAR(ROUND(RAND()*5+65;0))
nm

 

[TOM R]

Thanks for your reply

Happy Thanksgiving Matten,

Could you explain on what this function does on how to use it.

again, Thanks for your reply. Tom

 

[Legacy 68581]

Happy Thanksgiving!
rand() will give a random number between 0 and 1. I multiplied it by 5 because I want to have 5 possible letters, and I added 65 so that I get a number between 65 and 69. I used round(...;0) because I need an integer (0 decimals). You may need to replace that semicolon by a comma - I am using an old version of Excel.
65, 66, 67, 68 and 69 are the character codes for the letters A to E.
Try to type =char(65), Excel will return the letter A.
You can just paste this formula in any cell of your spreadsheet, and Excel will return a letter between A and E which will change randomly every time that you enter any cell in your spreadsheet or reopen your workbook.
nm

 

[TOM R]

Reply

Hi Matten,

Thanks for the explaination on this function. I'll let you know.

again, Thanks for your reply. Tom