Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

2014-12-25 Thread Vaibhav Joshi
Cheers!! On Dec 26, 2014 8:18 AM, "Ashish Bhalara" wrote: > Thanks... you are always rock in excel..Cheers!! > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this email unless it is absolutely necessary. > Spread environmental üawareness.♣♣♣* > > > On Thu, Dec 25, 2014 at 10:50

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

2014-12-25 Thread Ashish Bhalara
Thanks... you are always rock in excel..Cheers!! Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Thu, Dec 25, 2014 at 10:50 PM, Vaibhav Joshi wrote: > Hi > > Check this... > > Cheers!! > > + > *I

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

2014-12-25 Thread Vaibhav Joshi
Hi Check this... Cheers!! + *I did not do this for you. God is here working through me for you.* On Thu, Dec 25, 2014 at 10:41 AM, Ashish Bhalara wrote: > Hello Mr.Vaibhav > > As per trial mail, you solved my function query to display data on > matching code, but could you please edit thi

$$Excel-Macros$$ Need function help for output of particular list on matching data

2014-12-24 Thread Ashish Bhalara
Hello Mr.Vaibhav As per trial mail, you solved my function query to display data on matching code, but could you please edit this function to display only those data which matching with code & Date, example is mention in attached sheet. Regards. Ashish Bhalara 9624111822 P*Please do not print thi

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

2014-12-23 Thread Vaibhav Joshi
Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 2:51 PM, Ashish Bhalara wrote: > Hi Mr.Vaibhav > Ones again thank you so much for your tremendous job to help me. > > Regards. > Ashish Bhalara > 9624111822 > P*Please do not print this e

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

2014-12-23 Thread Ashish Bhalara
Hi Mr.Vaibhav Ones again thank you so much for your tremendous job to help me. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Tue, Dec 23, 2014 at 2:31 PM, Vaibhav Joshi wrote: > Hi > > check this..

Re: $$Excel-Macros$$ Need function help for output of particular list on matching data

2014-12-23 Thread Vaibhav Joshi
Hi check this.. Cheers!! + *I did not do this for you. God is here working through me for you.* On Tue, Dec 23, 2014 at 11:17 AM, Ashish Bhalara wrote: > Dear experts, > > I try below function to get output from other sheet on matching data > written in L1 in sheet of 'Letter'. But this f

$$Excel-Macros$$ Need function help for output of particular list on matching data

2014-12-22 Thread Ashish Bhalara
Dear experts, I try below function to get output from other sheet on matching data written in L1 in sheet of 'Letter'. But this function is not working and I'm not able to understand error. {=INDEX(Func.Query.xlsm!InvNo,SMALL(IF(INT(SaleData!$A$2:$A$100)=$L$1,ROW(SaleData!$A$2:$A$100)-ROW(SaleDat