writetoevv
Board Regular
- Joined
- Mar 9, 2012
- Messages
- 71
- Office Version
- 2019
- 2010
- Platform
- Windows
13 3/11/2016 | 14 4/11/2016 | 15 5/11/2016 | 16 6/11/2016 | 17 7/11/2016 |
12 2/11/2016 | 3 24/10/2016 | 4 25/10/2016 | 5 26/10/2016 | 18 8/1111/2016 |
11 1/11/2016 | 2 23/10/2016 | 1 22/10/2016 | 6 27/10/2016 | 19 9/11/2016 |
10 31/10/2016 | 9 30/10/2016 | 8 29/10/2016 | 7 28/10/2016 | 20 10/11/2016 |
25 15/11/2016 | 24 14/11/2016 | 23 13/11/2016 | 22 12/11/2016 | 21 11/11/2016 |
<tbody>
</tbody>
Hi Friends,
Could you help to create grid like above
In middle cell of 5 by 5 Grid , i will place a random number (ex: 1) along with random date(ex:22/10/2016)
It should Construct the remaining values (in clockwise direction) for other cells automatically using excel formulae..
Appreciate for the help..