View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tiya Tiya is offline
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