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

2012-09-29 Thread Ayush Jain
Good to know you all from this post, please keep this thread alive by introducing yourself. cheers. On Friday, 28 September 2012 06:45:07 UTC+5:30, reshma shri wrote: Hi I am Reshma, new to this group. i was looking to find a macro or a tool to list wav file name and duration in a

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

2012-09-29 Thread Indrajit $nai
*@ Krishna, thanks a lot Sir. Lemme try this :)* On Fri, Sep 28, 2012 at 9:51 PM, Krishna Kumar krishnak...@gmail.comwrote: Hi Replace the commandbutton1 code with this one. Private Sub CommandButton1_Click() Dim wbkActive As Workbook Dim FilePathAs String Dim

Re: $$Excel-Macros$$ Query

2012-09-29 Thread Aamir Shahzad
David - this still showing value error. On Sat, Sep 29, 2012 at 4:48 AM, David Grugeon da...@grugeon.com.au 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

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

2012-09-29 Thread Aamir Shahzad
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 jainayus...@gmail.com wrote: Good to know you all from this post, please keep this thread alive by introducing

Re: $$Excel-Macros$$ Query

2012-09-29 Thread Kuldeep Singh
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 aamirshahza...@gmail.comwrote: David - this still showing value error. On Sat, Sep 29, 2012 at 4:48 AM, David Grugeon da...@grugeon.com.auwrote: Use

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

2012-09-29 Thread Amol Shrivastava
Amol Shrivastava From Mumbai...!! On Sat, Sep 29, 2012 at 2:51 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: 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

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

2012-09-29 Thread Ojemeni Uzoma
Ojemeni Uzoma | Call 08060700717 -Original Message- From: Ashish Bhalara ashishbhalar...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 29 Sep 2012 14:05:39 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Error in excel

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

2012-09-29 Thread Mohammed Muneer
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,

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

2012-09-29 Thread Rajan_Verma
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

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

2012-09-29 Thread Lokesh Loki
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 rajanverma1...@gmail.comwrote: *Most of time it does not give fine result.* * * * * *Regards* *Rajan verma* *+91

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

2012-09-29 Thread David Grugeon
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

$$Excel-Macros$$ Excel Conditional Formatting formula

2012-09-29 Thread vinod rao
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

$$Excel-Macros$$ Re: Query

2012-09-29 Thread Don Guillett
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

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

2012-09-29 Thread Sam Mathai Chacko
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 vinod.ma...@gmail.com wrote: Hi, I want to know how to do a conditional formatting on numbers based on the calculated percentage % Please

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

2012-09-29 Thread Lokesh Loki
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 da...@grugeon.com.au wrote: I have tried with omniformat but no luck. The image is far

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

2012-09-29 Thread vinod rao
Hi Sam, But i am unable to put 0% to 2% to yellow. On Sat, Sep 29, 2012 at 7:35 PM, vinod rao vinod.ma...@gmail.com 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

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

2012-09-29 Thread vinod rao
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 vinod.ma...@gmail.com 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 vinod.ma...@gmail.com wrote:

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

2012-09-29 Thread Sam Mathai Chacko
=(I3-J3)/J30 (RED) =AND((I3-J3)/J3=0,(I3-J3)/J3=2%) (YELLOW) =(I3-J3)/J35% (GREEN) Find attachment also Regards, Sam Mathai CHacko On Sat, Sep 29, 2012 at 8:39 PM, vinod rao vinod.ma...@gmail.com wrote: Any suggestions? I need conditional formating Yellow when the delta is 0% +2%

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

2012-09-29 Thread vinod rao
Thank you very much Sam. It was perfect On Sat, Sep 29, 2012 at 9:04 PM, Sam Mathai Chacko samde...@gmail.comwrote: =(I3-J3)/J30 (RED) =AND((I3-J3)/J3=0,(I3-J3)/J3=2%) (YELLOW) =(I3-J3)/J35% (GREEN) Find attachment also Regards, Sam Mathai CHacko On Sat, Sep 29, 2012 at 8:39 PM, vinod

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

2012-09-29 Thread David Grugeon
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 lokeshsmg2...@gmail.com wrote:

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

2012-09-29 Thread Lokesh Loki
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

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

2012-09-29 Thread Christi Jacob
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 noorain.ans...@gmail.comwrote: Nice Creativity Rajan... On Sat, Sep 29, 2012 at 12:05 AM, Rajan_Verma rajanverma1...@gmail.comwrote: [image: Boxbe]

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

2012-09-29 Thread Vikash Chandra
RajanU rocks... Thanks Regards, Vikash Chandra Statistical Analyst 9902622922 On Sun, Sep 30, 2012 at 1:30 AM, Christi Jacob christi.ja...@gmail.comwrote: Hello Rajan, Thanks! This will solve my problem for the time being Regards, Christi Jacob On Sat, Sep 29, 2012 at 12:19 AM,

$$Excel-Macros$$

2012-09-29 Thread chhajersandeep
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

RE: $$Excel-Macros$$

2012-09-29 Thread Rajan_Verma
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$$ Benford's Laws in excel

2012-09-29 Thread chhajersandeep
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,

Re: $$Excel-Macros$$

2012-09-29 Thread chhajersandeep
Sorry to all, wrongly pressed send button. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: Rajan_Verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 30 Sep 2012 08:50:52 To: excel-macros@googlegroups.com Reply-To: