Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transferring amount to particular month column
You don't really need Choose. Your current formula could be =IF($B13="","",IF(TEXT($B13,"mmm")=H$2,$G13,"")) Now, to change the formula to identify the year.... If you input your headers as "jan-04", "feb-04" etc. excel should recognise these as dates and you can use =IF($B13="","",IF($B13-Day($B13)+1=H$2,$G13,"")) -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=568738 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
transferring amount to particular month column
.....in fact you don't even need the first IF function - this would suffice =IF($B13-DAY($B13)+1=H$2,$G13,"") -- daddylonglegs ------------------------------------------------------------------------ daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486 View this thread: http://www.excelforum.com/showthread...hreadid=568738 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i multiply two columns | Excel Worksheet Functions | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
match and count words | Excel Worksheet Functions | |||
Lookup Table Dilemma | Excel Worksheet Functions | |||
Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions |