$$Excel-Macros$$ Re: Interview Questions with Answers (Excel+VBA+Access+SQL Server)

*Thank u* *Noorain Ansari*, for sharing Interview questions and answers for MS Excel+VBA+MS Access+SQL Server regards thiru On Thursday, May 10, 2012 6:19:25 PM UTC+7, NOORAIN ANSARI wrote: > > Dear Group, > > Please find attached Interview questions and answers for MS Excel+VBA+MS > Access+SQL

Re: $$Excel-Macros$$

Sorry to all, wrongly pressed send button. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Sun, 30 Sep 2012 08:50:52 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Any

$$Excel-Macros$$ Benford's Laws in excel

Good morning to all, Do any one have macros or aad-in on Benford's law. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurat

RE: $$Excel-Macros$$

Any Query?? Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chhajersand...@gmail.com Sent: 30 September 2012 8:49 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Sent

$$Excel-Macros$$

Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

Re: $$Excel-Macros$$ circular x axis in excel graph *

RajanU rocks... Thanks & Regards, Vikash Chandra Statistical Analyst 9902622922 On Sun, Sep 30, 2012 at 1:30 AM, Christi Jacob wrote: > Hello Rajan, > Thanks! > This will solve my problem for the time being > > Regards, > Christi Jacob > > On Sat, Sep 29, 2012 at 12:19 AM, NOORAIN ANSARI >

Re: $$Excel-Macros$$ circular x axis in excel graph *

Hello Rajan, Thanks! This will solve my problem for the time being Regards, Christi Jacob On Sat, Sep 29, 2012 at 12:19 AM, NOORAIN ANSARI wrote: > Nice Creativity Rajan... > > On Sat, Sep 29, 2012 at 12:05 AM, Rajan_Verma wrote: > >> [image: Boxbe] This message

Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel

Yes i got it, and please let me know it covers all the image text in to the excel? or some of them readable text only. And i need the converted text in to excel based on cell wise but it looks a merged. please check david. Regards Lokesh On Sun, Sep 30, 2012 at 1:13 AM, Patil MG wrote: > Dear

Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel

Ya thanks a lot David, sure will give you good quality image. And one more daily i need to type all these image text in to excel, so if you provide me the solution will help for me to do get work easy. I am waiting for the good quality image once will get i will sent to you for further needful hel

Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel

Hi Lokesh It would be easy with a higher quality image. If you can get one and let me have it I will convert it for you and then let you know the exact (free) programs and steps you need to take. Regards David Grugeon On 30 September 2012 00:14, Lokesh Loki wrote: > Hello David, > > Thanks f

Re: $$Excel-Macros$$ Excel Conditional Formatting formula

Thank you very much Sam. It was perfect On Sat, Sep 29, 2012 at 9:04 PM, Sam Mathai Chacko wrote: > =(I3-J3)/J3<0 (RED) > =AND((I3-J3)/J3>=0,(I3-J3)/J3<=2%) (YELLOW) > =(I3-J3)/J3>5% (GREEN) > > Find attachment also > > Regards, > Sam Mathai CHacko > > > On Sat, Sep 29, 2012 at 8:39 PM, vinod rao

Re: $$Excel-Macros$$ Excel Conditional Formatting formula

=(I3-J3)/J3<0 (RED) =AND((I3-J3)/J3>=0,(I3-J3)/J3<=2%) (YELLOW) =(I3-J3)/J3>5% (GREEN) Find attachment also Regards, Sam Mathai CHacko On Sat, Sep 29, 2012 at 8:39 PM, vinod rao wrote: > > Any suggestions? > > > I need conditional formating Yellow when the delta is 0% +2% > > Thanks, > Vin > O

Re: $$Excel-Macros$$ Excel Conditional Formatting formula

Any suggestions? I need conditional formating Yellow when the delta is 0% +2% Thanks, Vin On Sat, Sep 29, 2012 at 7:53 PM, vinod rao wrote: > Hi Sam, > > But i am unable to put 0% to 2% to yellow. > On Sat, Sep 29, 2012 at 7:35 PM, vinod rao wrote: > >> Hi, >> >> I want to know how to do a c

Re: $$Excel-Macros$$ Excel Conditional Formatting formula

Hi Sam, But i am unable to put 0% to 2% to yellow. On Sat, Sep 29, 2012 at 7:35 PM, vinod rao wrote: > Hi, > > I want to know how to do a conditional formatting on numbers based on the > calculated percentage % > Please see attached file. Help me as quick as possible. > > Thanks > Vin > > > -- >

Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel

Hello David, Thanks for trying, i can't able to covert it to text so better will send high quality image may be then it converts in to excel. Regards Lokesh M On Sat, Sep 29, 2012 at 6:06 PM, David Grugeon wrote: > I have tried with omniformat but no luck. The image is far too small > and irf

Re: $$Excel-Macros$$ Excel Conditional Formatting formula

http://www.excelfox.com/forum/f2/conditional-format-based-percentage-variance-585/ Regards, Sam Mathai Chacko On Sat, Sep 29, 2012 at 7:35 PM, vinod rao wrote: > Hi, > > I want to know how to do a conditional formatting on numbers based on the > calculated percentage % > Please see attached fil

$$Excel-Macros$$ Re: Query

what is wrong with what I posted much earlier INDEX(C:C,MATCH($H12,$H:$H)) instead of this =INDEX(C2,MATCH($H12,$H$2:$H$9,0)) if you insist on sumproduct, this will do just fine. =SUMPRODUCT(($H$2:$H$9=$H12)*C$2:C$9) On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote: > > Dear G

$$Excel-Macros$$ Excel Conditional Formatting formula

Hi, I want to know how to do a conditional formatting on numbers based on the calculated percentage % Please see attached file. Help me as quick as possible. Thanks Vin -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANN

Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel

I have tried with omniformat but no luck. The image is far too small and irfanview cannot enlarge it enough (on my pc) to be readable. You would need a ot of memory to enlarge the image, then convert it to text, then replace say four spaces with a comma and then rename the file to .csv and open i

Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel

Hi Rajan/Radoslav, If any image converter software is there please send me will try and get the result. Regards Lokesh M On Sat, Sep 29, 2012 at 10:07 AM, Rajan_Verma wrote: > *Most of time it does not give fine result.* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gt

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hellow Guys I am Johnson, Chartered Accountant working currently as a Finance Controller of a SChneider Group company. I am thankful to individual memberrs of this group as they helped me a lot in learning various advanced tricks of Excel which will help me in my day to day job. Thank you guys onc

RE: $$Excel-Macros$$ circular x axis in excel graph *

Hi I have make it more suitable , please download from here.. http://excelpoweruser.wordpress.com/2012/09/29/showing-values-on-angle/ Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN A

RE: $$Excel-Macros$$ Data validation.xls

Dear Excel Learner, Thank you yea buddy! Happy! Fulfills the need! More than expected, Good! Regards, Muneer, CC... -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, a

Re: $$Excel-Macros$$ Error in excel file

Ojemeni Uzoma | Call 08060700717 -Original Message- From: Ashish Bhalara Sender: excel-macros@googlegroups.com Date: Sat, 29 Sep 2012 14:05:39 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Error in excel file Dear experts, Files original format is .xlsm an

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Amol Shrivastava From Mumbai...!! On Sat, Sep 29, 2012 at 2:51 PM, Aamir Shahzad wrote: > Hi Group, this is Aamir Shahzad from Karachi Pakistan, currently working > as MIS Officer in a Bank. Love Excel & learning. > > Aamir Shahzad > > On Sat, Sep 29, 2012 at 11:43 AM, Ayush Jain wrote: > >> Good

Re: $$Excel-Macros$$ Query

Hi Aamir, Try this one. =INDEX(C2,MATCH($H12,$H$2:$H$9,0)) Regards, Kuldeep Singh On Sat, Sep 29, 2012 at 2:48 PM, Aamir Shahzad wrote: > David - this still showing value error. > > On Sat, Sep 29, 2012 at 4:48 AM, David Grugeon wrote: > >> Use >> >> >> >> =SUMPRODUCT(($H$2:$H$9=$H12)*indire

Re: $$Excel-Macros$$ Re: Introduce Yourself !!

Hi Group, this is Aamir Shahzad from Karachi Pakistan, currently working as MIS Officer in a Bank. Love Excel & learning. Aamir Shahzad On Sat, Sep 29, 2012 at 11:43 AM, Ayush Jain wrote: > Good to know you all from this post, please keep this thread alive by > introducing yourself. > > cheers.

Re: $$Excel-Macros$$ Query

David - this still showing value error. On Sat, Sep 29, 2012 at 4:48 AM, David Grugeon wrote: > Use > > > > =SUMPRODUCT(($H$2:$H$9=$H12)*indirect((ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2) > Regards > David Grugeon > > > On 28 September 2012 22:24, Aamir Shahzad > wrote: > > Dear Group

Re: $$Excel-Macros$$ Required help in Work Allocation VBA based excel file.

*@ Krishna, thanks a lot Sir. Lemme try this :)* On Fri, Sep 28, 2012 at 9:51 PM, Krishna Kumar wrote: > Hi > > Replace the commandbutton1 code with this one. > > Private Sub CommandButton1_Click() > Dim wbkActive As Workbook > Dim FilePathAs String > Dim FileNameAs S