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
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
In D2 and copy across,
=DATE(2006 + MOD(COLUMN() - 4, 3), INT(COLUMN() - 4) / 3 + 1, 1)
I appreciate your quick response but i need all column data to move accoringly...
Please let me know if you questions..
Riz Momin
In D1 and across =10000 * MONTH(D2) + YEAR(D2) and sort left to right by row 1.
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
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks