Re: $$Excel-Macros$$ Matching Total of pair

2014-02-09 Thread kartikey patel
> > my logic is colom a amount sum match with c colom > 1 example. : a2 amount is 1068190/- ref .1 match with c colom amounts > 62226,16094,7066,191520,367764,423520 total = 1068190/- and ref.1 write > in colom d > 2 example. : a3 amount is 351971/- ref. 3match with c colom amounts 151972

Re: $$Excel-Macros$$ Matching Total of pair

2014-02-08 Thread kartikey patel
Dear, I want a2 colom amount match c2 : c7 total See this attached file to i want it. Thanks Kartik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel F

Re: $$Excel-Macros$$ Matching Total of pair

2014-02-08 Thread kartikey patel
On Saturday, February 8, 2014 10:09:12 PM UTC+5:30, bé trần văn wrote: > > Using Temporary File. > > > 2014-02-08 13:58 GMT+07:00 kartikey patel > >: > >> here attached file >> >> pls. help urgently >> >> Thanks >> Kartik >

Re: $$Excel-Macros$$ Matching Total of pair

2014-02-07 Thread kartikey patel
here attached file pls. help urgently Thanks Kartik On Saturday, October 19, 2013 5:38:58 PM UTC+5:30, ashish wrote: > please share sample file > > > On Thu, Oct 17, 2013 at 4:54 PM, kartikey patel > > > wrote: > >> Dear Sir, There are a

$$Excel-Macros$$ Matching Total of pair

2013-10-17 Thread kartikey patel
Dear Sir,There are a set of debit values and a set ot credit values in a column. I want a vba code by whcich the debit value plus a single / multiple credit value is zero that needs to be marked . finally i will come to know out of the avaibale debits which cannot be used the with a