$$Excel-Macros$$ Re: Auto Mail Micro

2008-12-23 Thread SINGHAL, ATUL.
Thanx Girish, But the MACRO is not working. Regards Atul -Original Message- From: girishkr...@gmail.com [mailto:girishkr...@gmail.com] Sent: December 23, 2008 11:18 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Re: Auto Mail Micro Hi Harish, I have done a macro hat can se

$$Excel-Macros$$ Alternate formula to Goal Seek

2008-11-24 Thread SINGHAL, ATUL.
Hi All, Can any tell me any formula which can return the input required to get a specific output just like Goal Seek do. I want to do this with the help of a formula as Goal Seek requires manual intervention. Sheet is attached for your reference. Lots of thanks in advance. Regards CA. Atul Singh

$$Excel-Macros$$ Re: Use of Array Formula or other method to crea te deduplicated list of text values?

2008-11-06 Thread SINGHAL, ATUL.
Hi Dave, Using advanced filter can solve your problem. Use Data-Filter-Advanced Filter (Unique records only must be ticked) and give the reference of the cell you wanna place your filtered data. Then you can sort the data. File is enclosed for your reference. Regards CA. Atul Singhal -Orig

$$Excel-Macros$$ Re: Excel Macros totaling like values

2008-11-06 Thread SINGHAL, ATUL.
can you send the file. Regards CA. Atul Singhal -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: November 06, 2008 2:58 AM To: MS Excel & VBA Macros Subject: $$Excel-Macros$$ Excel Macros totaling like values How do I create a macro in Excel that will count t

$$Excel-Macros$$ Re: $$Excel-Macros$$

2008-10-24 Thread SINGHAL, ATUL.
t: $$Excel-Macros$$ Re: $$Excel-Macros$$ Dear Mr. Atul, But formula can not read text "comm" for taking value of %, it is taking the same on fifo basis. Regards, Kamlesh On Thu, Oct 23, 2008 at 2:35 PM, SINGHAL, ATUL. < [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >

$$Excel-Macros$$ Re: Concatenate Formula

2008-10-24 Thread SINGHAL, ATUL.
Hi Dear, Use formula =A1&" "&B1&" "&TEXT(C1,"D-MMM-YY"). Regards CA. Atul Singhal -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: October 24, 2008 7:05 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Concatenate Formula Hi All, I have an

$$Excel-Macros$$ Re: $$Excel-Macros$$

2008-10-23 Thread SINGHAL, ATUL.
Hi Abhi, I think, the enclosed file can solve your problem. Regards CA. Atul Singhal -Original Message- From: Abhijit Kanhegaonkar [mailto:[EMAIL PROTECTED] Sent: October 22, 2008 9:44 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: $$Excel-Macros$$ Hey guys,

$$Excel-Macros$$ Re: Excel Shortcuts

2008-09-12 Thread SINGHAL, ATUL.
Thanx buddy, Regards Atul Singhal -Original Message- From: HP Reddy [mailto:[EMAIL PROTECTED] Sent: September 12, 2008 1:56 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel Shortcuts Hi Everyone, Pls find attached Excel Shortcuts. Regards hpreddy This Messa

$$Excel-Macros$$ Re: Vlookup Help

2008-08-30 Thread SINGHAL, ATUL.
Hi Rishi, The formulae in the enclosed file may help you. Regards Atul -Original Message- From: rishi [mailto:[EMAIL PROTECTED] Sent: August 26, 2008 11:30 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Vlookup Help Hi All, I have a couple of problems : 1. I