Microsoft Excel Formula assignment: The objective of this assignment is to create 20 [5x5] tables and each 5 by 5 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. I need to create this without having to manually type numbers and create the 5 by 5 tables. What is the fastest way to create these tables using formulas? This assignment demonstates the examples for formulas on excel. Here is two examples for 2 tables. 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 Here is an example that will NOT work. 1 2 66 4 21 6 7 8 7 9 10 11 12 39 41 82 88 88 88 29 100 33 35 32 51
Microsoft Excel Formula assignment: The objective of this assignment is to create 20 [5x5] tables and each 5 by 5 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.
I need to create this without having to manually type numbers and create the 5 by 5 tables.
What is the fastest way to create these tables using formulas? This assignment demonstates the examples for formulas on excel. Here is two examples for 2 tables.
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
Here is an example that will NOT work.
1 2 66 4 21
6 7 8 7 9
10 11 12 39 41
82 88 88 88 29
100 33 35 32 51
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
