Hi all,
I am just wondering how I would go about creating a nested for loop to go through each of the columns to obtain the required value. I am aware that the worksheetfunction.min exists however I don't want to use that to obtain the result.
I am just wondering how I would go about creating a nested for loop to go through each of the columns to obtain the required value. I am aware that the worksheetfunction.min exists however I don't want to use that to obtain the result.
Table 1 | |||||||
Date | Stock 1 | Stock 2 | Stock 3 | Stock 4 | Stock 5 | Stock 6 | Stock 7 |
31/1/17 | 1 | 11 | 7 | 16 | 8 | 3 | 11 |
28/2/17 | 2 | 12 | 8 | 17 | 9 | 4 | 10 |
31/3/17 | 3 | 13 | 9 | 18 | 10 | 5 | 12 |
30/4/17 | 3 | 13 | 9 | 18 | 10 | 5 | 12 |
31/5/17 | 2 | 12 | 8 | 17 | 9 | 4 | 9 |
30/6/17 | 4 | 14 | 7 | 19 | 11 | 6 | 11 |
31/7/17 | 5 | 15 | 8 | 20 | 12 | 7 | 13 |
31/8/17 | 4 | 14 | 9 | 19 | 11 | 6 | 13 |
30/9/17 | 6 | 16 | 8 | 15 | 13 | 8 | 14 |
31/10/17 | 7 | 17 | 6 | 12 | 14 | 9 | 14 |
30/11/17 | 6 | 16 | 7 | 12 | 13 | 8 | 13 |
31/12/17 | 6 | 16 | 8 | 11 | 13 | 8 | 14 |
31/1/18 | 5 | 15 | 9 | 14 | 12 | 7 | 14 |
28/2/18 | 8 | 14 | 8 | 15 | 15 | 10 | 16 |
31/3/18 | 9 | 13 | 7 | 16 | 16 | 11 | 16 |
30/4/18 | 10 | 12 | 8 | 17 | 17 | 12 | 18 |
31/5/18 | 11 | 11 | 7 | 17 | 18 | 13 | 18 |
30/6/18 | 11 | 10 | 9 | 16 | 18 | 13 | 20 |
31/7/18 | 10 | 11 | 7 | 18 | 17 | 12 | 17 |
31/8/18 | 12 | 12 | 7 | 20 | 19 | 14 | 19 |
30/9/18 | 14 | 13 | 8 | 21 | 21 | 16 | 22 |
31/10/18 | 15 | 15 | 9 | 20 | 22 | 17 | 24 |
30/11/18 | 14 | 14 | 9 | 18 | 21 | 16 | 23 |
31/12/18 | 12 | 15 | 9 | 16 | 19 | 14 | 21 |
Minumum price (For loop) | |||||||
Minimum price location (For loop) |