Skip to main content
M
MikeArmstrong1-Visitor
1-Visitor
February 25, 2010
Question

Help with programming problem

  • February 25, 2010
  • 1 reply
  • 2126 views
In the attached sheet the scramble array function posted by jmG has been used to create a random array of numbers. (Which is our 5 a-side teams)

Next I have given each element used in the scramble function a corresponding letter in a matrix(Table) which in-turn will represent a player�s name. Can anybody suggest a method of showing a resulting matrix of matching matrix(B) with the corresponding letters in matrix(Table)?


Regards

Mike

1 reply

S
StuartBruff23-Emerald V
23-Emerald V
February 25, 2010
On 2/25/2010 12:19:08 PM, m_armstrong wrote:
== Next I have given each element used in the scramble function a corresponding letter in a matrix(Table) which in-turn will represent a player�s name. Can anybody suggest a method of showing a resulting matrix of matching matrix(B) with the corresponding letters in matrix(Table)?

Do you mean something like the attached, Mike?

Stuart
M
MikeArmstrong1-VisitorAuthor
1-Visitor
February 26, 2010
Exactly what I was looking for as usual Stuart.

The only thing I don't under is how the zero after both of the lookup brackets has stopped the result being nested.

Regards

Mike
S
StuartBruff23-Emerald V
23-Emerald V
February 26, 2010
On 2/26/2010 5:02:36 AM, m_armstrong wrote:
== The only thing I don't under is how the zero after both of the lookup brackets has stopped the result being nested.

The lookup family functions return an array. In the particular instance of your example, they will return a single-element array, which is effectively a single-element vector and therefore only needs a single index to return the value.

Stuart
Terms & ConditionsAccessibility statement