Column Display Manipulation

1. Column Display Manipulation

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

2. In D2 and copy across,

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

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

Please let me know if you questions..

Riz Momin

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

5. 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

6. 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)

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1