Column Display Manipulation

[rizmomin]

Attach is the sheet for referance
I would like to arrange the sheet so that it would show from Column D:

Jan-06 Jan 07 Jan 08 Feb 06 Feb 07 Feb 08 ....and so on...

Please help....

Riz Momin

[shg]

In D2 and copy across,

=DATE(2006 + MOD(COLUMN() - 4, 3), INT(COLUMN() - 4) / 3 + 1, 1)

[rizmomin]

I appreciate your quick response but i need all column data to move accoringly...

Please let me know if you questions..

Riz Momin

[shg]

In D1 and across =10000 * MONTH(D2) + YEAR(D2) and sort left to right by row 1.

[rizmomin]

Thanks a lot...its working

I would like to like to ask one more question...please help

I have function :

=SUMPRODUCT(--(Data!$A$2:$A$1376='Monthly Summary'!$A5),(--(Data!$B$2:$B$1376='Monthly Summary'!$F$2)),(Data!$D$2:$D$1376))

where the function is Summing the values ..

In expression ,(--(Data!$B$2:$B$1376='Monthly Summary'!$F$2)),

i only need to match first 2 character from Data!$B$2:$B$1376 with 'Monthly Summary'!$F$2....

How would i use this expression to do that...

Thank u in advance and let me know if you any question...


Riz Momin

[shg]

Maybe

=SUMPRODUCT( (Data!$A$2:$A$1376 = 'Monthly Summary'!$A5) * (LEFT(Data!$B$2:$B$1376, 2) = 'Monthly Summary'!$F$2) * Data!$D$2:$D$1376)