Re: $$Excel-Macros$$ Re: Help with Budget - Formula
Hello Ashish Sorry for not replying earlier. This is exactly what I need. Thanks a lot for the quick solution. Thanks Ashish On 5/18/2011 8:42 PM, ashish koul wrote: cell ( b3) =B2-SUMIF(C6:C65356,B1,D6:D65356) cell(c3)=C2-SUMIF(C6:C65356,C1,D6:D65356) On Wed, May 18, 2011 at 2:00 PM, Ashish Pradhan ashlyprad...@gmail.com mailto:ashlyprad...@gmail.com wrote: Hello Guyscell Any help? Thanks Ashish Pradhan On 5/15/2011 10:52 PM, Ashish Pradhan wrote: Hello All Please see attached an excel file. I need a formula to automatically reduce the closing balance from the proper Funds wherever there are instances of the funds being utilised. The attached excel file will give more clarity. Please let me know if you need any more clarity. Thanks in advance. Ashish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com http://www.excel-macros.blogspot.com/ 4. Learn VBA Macros at http://www.quickvba.blogspot.com http://www.quickvba.blogspot.com/ 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com http://exceldailytip.blogspot.com/ To post to this group, send email to excel-macros@googlegroups.com mailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* ** *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 PBefore printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Re: Help with Budget - Formula
See if it helps... Regards, Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Pradhan Sent: Wednesday, May 18, 2011 2:00 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Help with Budget - Formula Hello Guys Any help? Thanks Ashish Pradhan On 5/15/2011 10:52 PM, Ashish Pradhan wrote: Hello All Please see attached an excel file. I need a formula to automatically reduce the closing balance from the proper Funds wherever there are instances of the funds being utilised. The attached excel file will give more clarity. Please let me know if you need any more clarity. Thanks in advance. Ashish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Solution _ sample (2).xls Description: Solution _ sample (2).xls
Re: $$Excel-Macros$$ Re: Help with Budget - Formula
Hello Thanks a lot for the good work Anil Thanks Ashish On 5/19/2011 11:12 AM, Anil Bhange wrote: See if it helps... Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Pradhan Sent: Wednesday, May 18, 2011 2:00 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Help with Budget - Formula Hello Guys Any help? Thanks Ashish Pradhan On 5/15/2011 10:52 PM, Ashish Pradhan wrote: Hello All Please see attached an excel file. I need a formula to automatically reduce the closing balance from the proper Funds wherever there are instances of the funds being utilised. The attached excel file will give more clarity. Please let me know if you need any more clarity. Thanks in advance. Ashish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Help with Budget - Formula
Hello Guys Any help? Thanks Ashish Pradhan On 5/15/2011 10:52 PM, Ashish Pradhan wrote: Hello All Please see attached an excel file. I need a formula to automatically reduce the closing balance from the proper Funds wherever there are instances of the funds being utilised. The attached excel file will give more clarity. Please let me know if you need any more clarity. Thanks in advance. Ashish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel sample.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Re: Help with Budget - Formula
cell ( b3) =B2-SUMIF(C6:C65356,B1,D6:D65356) cell(c3)=C2-SUMIF(C6:C65356,C1,D6:D65356) On Wed, May 18, 2011 at 2:00 PM, Ashish Pradhan ashlyprad...@gmail.comwrote: Hello Guyscell Any help? Thanks Ashish Pradhan On 5/15/2011 10:52 PM, Ashish Pradhan wrote: Hello All Please see attached an excel file. I need a formula to automatically reduce the closing balance from the proper Funds wherever there are instances of the funds being utilised. The attached excel file will give more clarity. Please let me know if you need any more clarity. Thanks in advance. Ashish -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel