How to drop the first twelve month of fund returns

%3CLINGO-SUB%20id%3D%22lingo-sub-1493779%22%20slang%3D%22en-US%22%3EHow%20to%20drop%20the%20first%20twelve%20month%20of%20fund%20returns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493779%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%20all%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3ECan%20anyone%20provide%20any%20assistance%20as%20I%20need%20to%20drop%20the%20first%20twelve%20month%20of%20fund%20returns%20in%20long%20format%20where%20the%20months%20that%20contain%20no%20returns%20data%20do%20not%20count.%20There%20are%20lots%20of%20funds%20in%20my%20data%20set.%20Below%20is%20the%20example%20of%20fund%202%20from%20June%202004%20to%20May%202006.%20Therefore%2C%20following%20the%20example%20in%20fund%202%2C%20I%20would%20like%20to%20remove%20the%20returns%20from%20May%202005%20to%20April%202006%20(12%20month%20returns).%20Thank%20you%20for%20any%20help%20you%20can%20provide.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%3Eic_fund%26nbsp%3B%20year%26nbsp%3B%20%26nbsp%3Breturns%20Date%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20174%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01jun2004%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20175%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01jul2004%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20176%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01aug2004%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20177%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01sep2004%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20178%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01oct2004%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20179%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01nov2004%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20180%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01dec2004%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20181%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01jan2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20182%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01feb2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20183%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01mar2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20184%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01apr2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20185%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B-.6%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2001may2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20186%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%204.5%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2001jun2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20187%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20-.2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01jul2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20188%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%203.3%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2001aug2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20189%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B-.1%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2001sep2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20190%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20-2.7%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01oct2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20191%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20-2.1%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01nov2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20192%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B2.3%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2001dec2005%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20193%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B1.4%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2001jan2006%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20194%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B.6%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01feb2006%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20195%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%204.3%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2001mar2006%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20196%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%202.9%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%2001apr2006%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3E2%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20197%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20-.4%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B01may2006%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1493779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493855%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20drop%20the%20first%20twelve%20month%20of%20fund%20returns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493855%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F712000%22%20target%3D%22_blank%22%3E%40JoyBaa%3C%2FA%3E%26nbsp%3BCan%20you%20please%20provide%20more%20details%20with%20a%20proper%20example%20wherein%20we%20will%20know%20what%20is%20raw%20data%20and%20what%20is%20resultant%20data.%20Also%20if%20possible%20please%20attach%20a%20example%20sheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1493906%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20drop%20the%20first%20twelve%20month%20of%20fund%20returns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1493906%22%20slang%3D%22en-US%22%3E%3CP%3EMany%20thanks%20for%20your%20prompt%20reply%20but%20this%20issue%20has%20now%20been%20resolved%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F699938%22%20target%3D%22_blank%22%3E%40DevendraJain%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello all,

Can anyone provide any assistance as I need to drop the first twelve month of fund returns in long format where the months that contain no returns data do not count. There are lots of funds in my data set. Below is the example of fund 2 from June 2004 to May 2006. Therefore, following the example in fund 2, I would like to remove the returns from May 2005 to April 2006 (12 month returns). Thank you for any help you can provide.


ic_fund  year   returns Date
2            174                 01jun2004
2            175                 01jul2004
2            176                 01aug2004
2            177                 01sep2004
2            178                 01oct2004
2            179                 01nov2004
2            180                 01dec2004
2            181                 01jan2005
2            182                 01feb2005
2            183                 01mar2005
2            184                 01apr2005
2            185     -.6        01may2005
2            186      4.5      01jun2005
2            187      -.2       01jul2005
2            188      3.3      01aug2005
2            189       -.1      01sep2005
2            190      -2.7     01oct2005
2            191      -2.1     01nov2005
2            192       2.3      01dec2005
2            193       1.4      01jan2006
2            194         .6       01feb2006
2            195        4.3      01mar2006
2            196        2.9      01apr2006
2            197        -.4       01may2006

2 Replies

@JoyBaa Can you please provide more details with a proper example wherein we will know what is raw data and what is resultant data. Also if possible please attach a example sheet.

Many thanks for your prompt reply but this issue has now been resolved @DevendraJain