Re: $$Excel-Macros$$ how many count zero of 10000000 with excel formula

2014-05-20 Thread Vishal Angre
=LEN(K4)-LEN(SUBSTITUTE(K4,"0","")) On Wed, May 21, 2014 at 10:19 AM, Ashish Kumar wrote: > Hi Saleem, > > PFA!!! > > > Thanks > Ashish > > > -- Forwarded message -- > From: Saleem Ansari > ​​ > < > ​​ > saleem.logic...@gmail.com> > Date: 21 May 2014 10:09 > Subject: Re: [XL-

$$Excel-Macros$$ how many count zero of 10000000 with excel formula

2014-05-20 Thread Ashish Kumar
Hi Saleem, PFA!!! Thanks Ashish -- Forwarded message -- From: Saleem Ansari ​​ < ​​ saleem.logic...@gmail.com> Date: 21 May 2014 10:09 Subject: Re: [XL-VBA Clinic] Re: Restart ! Restart ! Restart Monday Morning Batch Restart(AM) To: ​​ excelvbacli...@googlegroups.com ​​ h

$$Excel-Macros$$ Re: Can We creat Auto Mailer In Excel.

2014-05-20 Thread khagesh khera
Dear Expert, I am working with an MNC & the database is so huge. We required to send the auto emails to client with same format. The outstanding details need to mentioned on the body text only which is not happening with this macro. Regards, Khagesh Khera On Thursday, 7 April 2011 10:35:14

Re: $$Excel-Macros$$ need some help from two tables

2014-05-20 Thread Vaibhav Joshi
Hi Check this.. Cheers!! On Tue, May 20, 2014 at 1:44 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Sir / Madam, > > Please see the attachment. There is two table marked with yellow and blue. > > Both tables has one common field that is Account Code. All the field is >

Re: $$Excel-Macros$$ Password protected work sheet

2014-05-20 Thread xlstime
Thank Paul :) . Enjoy Team XLS On Mon, May 19, 2014 at 4:40 PM, Paul Schreiner wrote: > Yes, there are ways to override (break) passwords. > But, per Forum Rules #3, you shouldn't seek them here. > --- > 3) Don't post questions regarding breaking or

$$Excel-Macros$$ need some help from two tables

2014-05-20 Thread Sanjib Chatterjee
Dear Sir / Madam, Please see the attachment. There is two table marked with yellow and blue. Both tables has one common field that is Account Code. All the field is present in table yellow. But some field may or may have not present in table blue. I want If table blue Account code is matched