$$Excel-Macros$$ Autofill Macro

2014-05-09 Thread Bill Q
I have spent the better part of 40 minutes searching the web for what I believe is a simple solution. I have found many answers. I have tried them all - None are working to what I am looking for. Simply put. - Assume source Data is always is column "A". It could be 50 rows in length or 84,679

Re: $$Excel-Macros$$ Hi - Details needed for the MIS Executive Qualification

2014-05-09 Thread kapil Gupta
Is there any opening in MIS executive profile?. Actually i also looking the job in same field. Regards, Kapil Gupta On Tuesday, August 2, 2011 7:13:55 AM UTC+5:30, krishna mummina wrote: > > Sam > > Are you asking me or to whom you are referring to call you? Here is my > number : 09866902757

Re: $$Excel-Macros$$ Graph Query

2014-05-09 Thread ashish koul
wht do u wanna do .. its x y scatter chart On Thu, May 8, 2014 at 4:59 PM, Shrinivas Shevde wrote: > Dear All > I received one excel file in whih there is a graph. > When I try to edit series it shows X and Y series in same legend (screen > shot attached) > Please let me know how to do the same.

Re: $$Excel-Macros$$ if error function

2014-05-09 Thread Ashish Bhalara
Thanks, thats exactly what i found :) Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* On Fri, May 9, 2014 at 6:49 PM, Vaibhav Joshi wrote: > Hi > > You need to use =if ( ISERROR(fn)=True, if ( iserror(

Re: $$Excel-Macros$$ if error function

2014-05-09 Thread Vaibhav Joshi
Hi You need to use =if ( ISERROR(fn)=True, if ( iserror(fn)=True, , )) HTH//Cheers On Fri, May 9, 2014 at 5:49 PM, Ashish Bhalara wrote: > Dear experts, > > I want to add another function if the result of first function is error, > so please know me the function. > > for example > =if =error,

$$Excel-Macros$$ if error function

2014-05-09 Thread Ashish Bhalara
Dear experts, I want to add another function if the result of first function is error, so please know me the function. for example =if =error, if=error, , Iferror function cannot use because its contain only 1 argument. Thanks & regards. Ashish Bhalara 9624111822 P*Please do not print this emai

$$Excel-Macros$$ example.xlsx

2014-05-09 Thread Mohammed Jawed
Sorry ignore the earlier example file use this one Sent from my iPhone example.xlsx Description: MS-Excel 2007 spreadsheet -- 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

Re: $$Excel-Macros$$ copying data from Excel into a multiple .xml files

2014-05-09 Thread Mohammed Jawed
Vaibhav Joshi, Thankyou for your reply :) Attach is an example of the excel file as requested. (I've only left 4 lines of data to keep the file size small). Thanks On 8 May 2014 16:48, Vaibhav Joshi wrote: > Hi MJ, > > Can you send a sample excel file with raw data for creating excel. Also

$$Excel-Macros$$ Re: [XL-VBA Clinic] regarding vlookup and wildcard function

2014-05-09 Thread Sanjib Chatterjee
Dear Sir / Madam, Thank you for your quick reply. Regds, Sanjib On Fri, May 9, 2014 at 1:30 PM, Rajeev Kumar wrote: > Dear Sanjib, > > > > Please use below formula > > > > > > =VLOOKUP("*"&LEFT(E1,4)&"*",LIST,2,0) > > > > > > Thanks & Regards > > Rajeev Kumar > > > > *Gurgaon* > > A 10 In

RE: $$Excel-Macros$$ How to Drag & get C,D,E,F post A,B...

2014-05-09 Thread Amit Desai (MERU)
Dear Abhishek, This worked perfectly fine. Thanks a lot. I just check how Left & Address formula works! Could you please explain me how does the formula works? Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Abhishek Jain Sent: 05-Fr

$$Excel-Macros$$ regarding vlookup and wildcard function

2014-05-09 Thread Sanjib Chatterjee
Dear Sir / Madam, Please see the attachment and help me to solve the problem Thank you in advance Regards Sanjib -- - -- 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/di

$$Excel-Macros$$ Re: How to Drag & get C,D,E,F post A,B...

2014-05-09 Thread Prince
Hi Amit, this is because there is not custome list exist in your excel application, if it is not their you can add same in you excel by just clicking on sort button in in order list box select custom list option and then add the list. Regards Prince On Friday, 9 May 2014 12:21:31 UTC+5:30, Am

Re: $$Excel-Macros$$ How to Drag & get C,D,E,F post A,B...

2014-05-09 Thread Abhishek Jain
After A, B, C.Y, Z and then AA, AB and so on - if you are looking for this, you can use below after putting "A" in A1 - =LEFT(ADDRESS(1, ROW(A1), 4, TRUE), (ROW(A1)>26)+1) Regards, Abhishek On Fri, May 9, 2014 at 12:21 PM, Amit Desai (MERU) wrote: > Dear Friends, > > > > Please help me wi