Re: $$Excel-Macros$$ Re: Help with Budget - Formula

2011-05-19 Thread Ashish Pradhan
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

RE: $$Excel-Macros$$ Re: Help with Budget - Formula

2011-05-19 Thread Anil Bhange
: $$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 > prope

Re: $$Excel-Macros$$ Re: Help with Budget - Formula

2011-05-19 Thread Ashish Pradhan
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, As

Re: $$Excel-Macros$$ Re: Help with Budget - Formula

2011-05-18 Thread ashish koul
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 wrote: > > Hello Guyscell > > Any help? > > > Thanks > > > Ashish Pradhan > > On 5/15/2011 10:52 PM, Ashish Pradhan wrote: > >> Hello All >> >> Please see attache

$$Excel-Macros$$ Re: Help with Budget - Formula

2011-05-18 Thread Ashish Pradhan
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 at