Sorry for the repost: I need the explaination to be consist and clear. Microsoft Excel Formula assignment: The objective of this assignment is to create 3 unique [5x5] tables and each table will have mix of numbers from 1 to 100. (NOTE: There can't be ANY duplicate numbers in the 25 cells). The numbers placed in the 5x5 table cannot match with any other table and again, each table cannot repeat the same number. Please educate me on creating this without having to manually type numbers to later create over 50: 5 by 5 tables. What is the best approach to creating these tables? Here is examples for 2 tables that I manually typed out. TABLE 1: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 TABLE 2: 59 2 3 4 1 33 72 8 9 66 11 22 13 88 15 16 17 18 19 5 29 40 99 30 21 I want to use excel tools like formulas, copy and paste, sorting, and others if needed to mass produce tables with very few manual entry. Example of a table that will not work. 1 2 3 4 5 6 7 8 8 9 10 11 12 13 14 16 17 17 18 19 20 21 22 21 25 Tables can generate random numbers if they want to or not with the forumla =RANDBETWEEN(0,101). (Note: as long as the assignment follows -- No 1:1 charts or the duplicate numbers in a table --) Bonus: Kindly demonistrate how to check for duplicate numbers in a table. Highlight or any tools to double check to make sure that each individual chart is unque. Here are two more examples that will work. 1 22 33 44 55 22 33 44 55 66 66 77 88 99 100 77 88 99 100 11 11 12 13 14 15 12 13 14 15 16 16 17 18 19 20 17 18 19 20 21 21 22 23 24 25 22 23 24 25 1
Sorry for the repost: I need the explaination to be consist and clear.
Microsoft Excel Formula assignment: The objective of this assignment is to create 3 unique [5x5] tables and each table will have mix of numbers from 1 to 100. (NOTE: There can't be ANY duplicate numbers in the 25 cells). The numbers placed in the 5x5 table cannot match with any other table and again, each table cannot repeat the same number.
Please educate me on creating this without having to manually type numbers to later create over 50: 5 by 5 tables.
What is the best approach to creating these tables? Here is examples for 2 tables that I manually typed out.
TABLE 1:
1 2 3 4 5
6 7 8 9 10
11 12 13 14 15
16 17 18 19 20
21 22 23 24 25
TABLE 2:
59 2 3 4 1
33 72 8 9 66
11 22 13 88 15
16 17 18 19 5
29 40 99 30 21
I want to use excel tools like formulas, copy and paste, sorting, and others if needed to mass produce tables with very few manual entry.
Example of a table that will not work.
1 2 3 4 5
6 7 8 8 9
10 11 12 13 14
16 17 17 18 19
20 21 22 21 25
Tables can generate random numbers if they want to or not with the forumla =RANDBETWEEN(0,101).
(Note: as long as the assignment follows -- No 1:1 charts or the duplicate numbers in a table --)
Bonus: Kindly demonistrate how to check for duplicate numbers in a table. Highlight or any tools to double check to make sure that each individual chart is unque.
Here are two more examples that will work.
1 22 33 44 55 22 33 44 55 66
66 77 88 99 100 77 88 99 100 11
11 12 13 14 15 12 13 14 15 16
16 17 18 19 20 17 18 19 20 21
21 22 23 24 25 22 23 24 25 1
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
