LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 44
Default transferring amount to particular month column

=IF($B13="","",IF(CHOOSE(MONTH($B13),"Jan","Feb"," Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","No v","Dec")=H$2,$G13,""))

Using This function i am transferring amount to particular month column but
when there is a same month but year is change than also it goes to that
month, i want if there is year change it should goto that year column.

I have data for year 2004,2005 & 2006 so i have created 36 column for every
month.

Is there any way?

Thanks
tiya


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
how can i multiply two columns edgar Excel Worksheet Functions 7 March 2nd 06 03:29 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
match and count words David Excel Worksheet Functions 5 July 4th 05 02:24 AM
Lookup Table Dilemma Karen Excel Worksheet Functions 2 June 10th 05 08:22 PM
Return Count for LAST NonBlank Cell in each Row Sam via OfficeKB.com Excel Worksheet Functions 12 April 17th 05 10:36 PM


All times are GMT +1. The time now is 03:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"