Hi Nitya,

Am Mon, 10 Aug 2015 06:15:46 -0700 (PDT) schrieb Nitya Satheesh:

Grid Date
1 11/10/12
1 11/10/12
1 15/10/12
1 1/1/13
1 5/1/13
1 10/1/13
2 4/12/12
2 5/12/12
2 7/12/12
2 10/4/13
3 1/1/12
3 2/1/12
3 3/1/12
3 4/1/12
4 10/6/11
4 11/6/11
4 15/6/11
4 17/6/11
5 19/6/11
5 20/5/11
5 22/5/11

grid Jan11 Feb11 MAr11 ....Oct12...dec12
1 5 0 0 5 0
2 0 0 0 0 4

please look he
https://onedrive.live.com/redir?resi...=folder%2cxlsm
for "Grid"
There is a suggestion with formula and one with Pivot.
I would prefer Pivot.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional