Imran Azam
Board Regular
- Joined
- Mar 15, 2011
- Messages
- 103
Hello people
hope all is well
i have a group of number and i am trying to create a macro that would read these numbers into an array and also calculate the min value of each row and also store this into a new array.
is there anyone that can help me with this?
below is he group of numbers ( the range is e5 to m15)
thank you
hope all is well
i have a group of number and i am trying to create a macro that would read these numbers into an array and also calculate the min value of each row and also store this into a new array.
is there anyone that can help me with this?
below is he group of numbers ( the range is e5 to m15)
50 | 1 | 2 | 3 | 46 | 7 | 2 | 2 | 1 |
10 | 3 | 5 | 7 | 8 | 9 | 0 | 12 | 1 |
20 | 4 | 6 | 8 | 9 | 10 | 1 | 13 | 2 |
30 | 5 | 7 | 9 | 10 | 11 | 2 | 14 | 3 |
40 | 6 | 8 | 10 | 11 | 12 | 3 | 15 | 4 |
70 | 7 | 9 | 11 | 12 | 13 | 4 | 16 | 5 |
71 | 8 | 10 | 12 | 13 | 14 | 5 | 17 | 6 |
72 | 9 | 11 | 13 | 14 | 15 | 6 | 18 | 7 |
73 | 10 | 12 | 14 | 15 | 16 | 7 | 19 | 8 |
74 | 11 | 13 | 15 | 16 | 17 | 8 | 20 | 9 |
75 | 12 | 14 | 16 | 17 | 18 | 9 | 21 | 10 |
thank you