$$Excel-Macros$$ Re: Introduce Yourself !!
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 excel, thats when i found about this group and instantly joined. I would like to know if that's possible at all. if u have a tool for that, kindly lemme know. that would be of gr8 help coz i am doing it manually now. Regards Reshma -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
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 krishnak...@gmail.comwrote: Hi Replace the commandbutton1 code with this one. Private Sub CommandButton1_Click() Dim wbkActive As Workbook Dim FilePathAs String Dim FileNameAs String Dim wbkOpen As Workbook Dim LastRow As Long If wbkActive Is Nothing Then Set wbkActive = ThisWorkbook FilePath = C:\Users\Indra\Desktop\ If Right(FilePath, 1) \ Then FilePath = FilePath \ If Len(Me.TextBox1.Value) Then If Len(Me.TextBox2.Value) Then If Len(Me.TextBox3.Value) Then FileName = FilePath Me.TextBox3.Value .xlsx Dim r r = Evaluate(match( Me.TextBox3.Value ,'MasterSheet'!B4:B1000,0)) If Not FileIsOpen(FileName) Then Set wbkOpen = Workbooks.Open(FilePath Me.TextBox3.Value .xlsx) With wbkOpen.Worksheets(1) LastRow = .Range(b .Rows.Count).End(3).Row + 1 .Range(a LastRow) = LastRow - 3 .Range(b LastRow).Resize(, 3) = Split(Me.TextBox2.Value , Me.TextBox1.Value , Me.TextBox3.Value, ,) End With wbkOpen.Close 1 Set wbkOpen = Nothing MsgBox Done, , ExcelFox.com Unload Me If Not IsError(r) Then Cells(r, f) = Assigned End If Else MsgBox Workbook ' FileName ' is already opened vbLf Close the workbook and try again, vbInformation, ExcelFox.com If Not IsError(r) Then Cells(r, f) = Unassigned End If Exit Sub End If Else MsgBox Emp ID is missing, vbInformation, ExcelFox.com Me.TextBox3.SetFocus End If Else MsgBox Batch No is missing, vbInformation, ExcelFox.com Me.TextBox2.SetFocus End If Else MsgBox Site is missing, vbInformation, ExcelFox.com Me.TextBox1.SetFocus End If End Sub 1. Through this Master file I'm able to create the slave files, but it's not opening, showing an error invalid format. I'm not sure how you create the slave files. So I can't comment on that. 3. In the Master file Batch Assign to and Batch Status is not updating after assigning any Batch to the slave file. See the code above. Kris ExcelFox -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to
Re: $$Excel-Macros$$ Query
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 aamirshahza...@gmail.com wrote: Dear Group, When I mannualy enter the C7 into the following formula, it has no problem, =SUMPRODUCT(($H$2:$H$9=$H13)*(C7)) but when I am trying to generate C7, it's given me #value error, however address function is creating the C7 ok seperaterly. =SUMPRODUCT(($H$2:$H$9=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2 Sample file is also attached, Please suggest. Regards, Aamir Shahzad -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards, Aamir Shahzad -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
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 jainayus...@gmail.com wrote: 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 excel, thats when i found about this group and instantly joined. I would like to know if that's possible at all. if u have a tool for that, kindly lemme know. that would be of gr8 help coz i am doing it manually now. Regards Reshma -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards, Aamir Shahzad -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
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 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 =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 aamirshahza...@gmail.com wrote: Dear Group, When I mannualy enter the C7 into the following formula, it has no problem, =SUMPRODUCT(($H$2:$H$9=$H13)*(C7)) but when I am trying to generate C7, it's given me #value error, however address function is creating the C7 ok seperaterly. =SUMPRODUCT(($H$2:$H$9=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2 Sample file is also attached, Please suggest. Regards, Aamir Shahzad -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards, Aamir Shahzad -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive,
Re: $$Excel-Macros$$ Re: Introduce Yourself !!
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 Jain jainayus...@gmail.comwrote: 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 excel, thats when i found about this group and instantly joined. I would like to know if that's possible at all. if u have a tool for that, kindly lemme know. that would be of gr8 help coz i am doing it manually now. Regards Reshma -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Regards, Aamir Shahzad -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Thanks Regards, Amol Shrivastava +91 99671 18180 -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Error in excel file
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 file Dear experts, Files original format is .xlsm and this file is attached herewith and the password is 'ashish' to open this file, kindly know me how to solve this error and if it is corrupted kindly suggest me software to recover my file. Thanks regards Ashish On Fri, Sep 28, 2012 at 9:57 AM, Pravin Gunjal isk1...@gmail.com wrote: Dear Ashish Request to please post ur file on group for further assistance. Regards Pravin. -- Forwarded message -- From: Ashish Bhalara ashishbhalar...@gmail.com Date: Fri, Sep 28, 2012 at 9:39 AM Subject: Re: $$Excel-Macros$$ Error in excel file To: excel-macros@googlegroups.com Dear Pravin, I do what you say but same error is still continue during the opening of file, please suggest how to solve? Thanks On Thu, Sep 27, 2012 at 6:04 PM, Pravin Gunjal isk1...@gmail.com wrote: Dear Ashish You might have renamed the file from nay other extension to xlsm without opening it. Pl confirm. On Thu, Sep 27, 2012 at 5:30 PM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear experts, During the working in excel file I found the error and now the below mention error occurred to open the file, the file format is Excel Macro-Enable file and now its not open, could you explain how to solve this error. [image: Inline image 1] Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Thanks regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated
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, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
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 ANSARI Sent: 29 September 2012 12:20 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in excel graph * Nice Creativity Rajan... On Sat, Sep 29, 2012 at 12:05 AM, Rajan_Verma rajanverma1...@gmail.com wrote: https://www.boxbe.com/overview Boxbe http://www.boxbe.com/stfopen?tc=12523733031_1064418514 This message is eligible for Automatic Cleanup! (rajanverma1...@gmail.com) https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftok en%3D1dpgyyl0KYOxyEEj6wZg0S4CzsuRC0C2FrF6bJPcxr6eYzv4jvWjpJZRziJArmzCKqRs%25 2B6uTFUDLSqUhwccXyrUSZ5kxzSFzrCYHYGMSKEvE7OBcFM63zUScD7n32KJ5WVbrPiVHROD3YJS JHZS0DQ%253D%253D%26key%3DMW3z8G4047LkKs0ZKqsh%252BpCl56jXn0IDvk609ed%252Fvy w%253Dtc=12523733031_1064418514 Add cleanup rule | http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12523733031_106441 8514 More info Hi Christi See the attached File . Its dynamic if you want to add more angle you can add in the yellow table ... Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 27 September 2012 10:19 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ circular x axis in excel graph I am working on this . will get back to you shortly Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of David Grugeon Sent: 27 September 2012 1:58 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in excel graph I think you can make a list of all 360 points and leave those without data blank Regards David Grugeon On 27 September 2012 03:03, Christi Jacob christi.ja...@gmail.com wrote: Hello Rajan, the result is close to the requirement although it looks like the radar has been rotated by some angle. thanks can the graph be modified for angles which are not evenly spaced (ie in the example the angles are spaced 45deg apart. in actual case the first angle might be 25deg followed by 65 deg followed by 90deg...) regards, christi jacob On Wed, Sep 26, 2012 at 8:48 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Not exactly same.. but I made something J See the attached Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Christi Jacob Sent: 26 September 2012 7:09 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in excel graph Dear friends, i am attaching a image file of the expected graph note: instead of radial line i actually require a curve through the points as shown in the image file ( :( ) also the number of data points may be 8, 10, 20 etc in various cases hence if it is possible to automate it it will be good thanks christi jacob On Wed, Sep 26, 2012 at 6:03 AM, David Grugeon da...@grugeon.com.au wrote: See attachment for the sort of chart required. Regards David Grugeon On 26 September 2012 10:22, David Grugeon da...@grugeon.com.au wrote: There is an explanation how to do it and a very useful sample workbook download at this site http://www.ozgrid.com/Excel/polar-plot-chart.htm Regards David Grugeon On 26 September 2012 09:56, David Grugeon da...@grugeon.com.au wrote: I do not know of a chat type in excel that does what you want directly. Since you only have 8 data points (360 is the same as 0 so can be ignored) you could do it by making 8 doughnut charts and putting them on top of each other. Clunky, I know, but it is probably better than trying to plot the 8 points and join them each to 0,0 coordinate. Turtle Graphics anyone? Regards David Grugeon On 26 September 2012 05:41, Sam Mathai Chacko samde...@gmail.com wrote: maybe you can draw a sample in paint and post it so that people understand what exactly you are looking for in the chart. On Wed, Sep 26, 2012 at 1:06 AM, Christi Jacob christi.ja...@gmail.com wrote: Dear friends, this is my first query to this group i am having a data which may be as follows anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 the values under heading angle are in degrees i would like to plot them in a graph such that the independent axis shows up on a circle as angular location and strength value shows up as radial lines Please guide regards, christi jacob -- Join official facebook page of this forum @
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 rajanverma1...@gmail.comwrote: *Most of time it does not give fine result.* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Radoslav Ganov *Sent:* 29 September 2012 12:35 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel ** ** Sorry *Abbyy FineReader On Fri, Sep 28, 2012 at 12:03 PM, Radoslav Ganov radoslav.ga...@gmail.com wrote: Use Abbey Finereader it can convert any image with alphanumerical values to word and after that you can copy the values to excel ** ** On Fri, Sep 28, 2012 at 9:53 AM, Rajan_Verma rajanverma1...@gmail.com wrote: *I don’t think if there is a way to do that.* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Lokesh Loki *Sent:* 28 September 2012 6:24 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Convert Gif Image in to Ms Excel Hi Experts, Here it is the task for converting GIF image in to MS Excel MS Word as it is content. The image contains alpha and numeric data. Is this possible to convert this image in to MS Excel MS Word? or please advice me how can i convert this image in to ms excel ms word. Regards Lokesh M -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Radoslav Tsvetkov Ganov Microsoft Certified Professional Phone: +359897931801 E-mail: radoslav.ga...@gmail.bg -- Radoslav Tsvetkov Ganov Microsoft Certified Professional Phone: +359897931801 E-mail: radoslav.ga...@gmail.bg -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing
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 it in excel. Regards David Grugeon On 29 September 2012 21:36, Lokesh Loki lokeshsmg2...@gmail.com wrote: 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.com wrote: Most of time it does not give fine result. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Radoslav Ganov Sent: 29 September 2012 12:35 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel Sorry *Abbyy FineReader On Fri, Sep 28, 2012 at 12:03 PM, Radoslav Ganov radoslav.ga...@gmail.com wrote: Use Abbey Finereader it can convert any image with alphanumerical values to word and after that you can copy the values to excel On Fri, Sep 28, 2012 at 9:53 AM, Rajan_Verma rajanverma1...@gmail.com wrote: I don’t think if there is a way to do that. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: 28 September 2012 6:24 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert Gif Image in to Ms Excel Hi Experts, Here it is the task for converting GIF image in to MS Excel MS Word as it is content. The image contains alpha and numeric data. Is this possible to convert this image in to MS Excel MS Word? or please advice me how can i convert this image in to ms excel ms word. Regards Lokesh M -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Radoslav Tsvetkov Ganov Microsoft Certified Professional Phone: +359897931801 E-mail: radoslav.ga...@gmail.bg -- Radoslav Tsvetkov Ganov Microsoft Certified Professional Phone: +359897931801 E-mail: radoslav.ga...@gmail.bg -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure.
$$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 BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. conditional Fotmating.xls Description: MS-Excel spreadsheet
$$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 Group, When I mannualy enter the C7 into the following formula, it has no problem, =SUMPRODUCT(($H$2:$H$9=$H13)*(*C7*)) but when I am trying to generate C7, it's given me #value error, however address function is creating the C7 ok seperaterly. =SUMPRODUCT(($H$2:$H$9=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2 Sample file is also attached, Please suggest. Regards, Aamir Shahzad -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
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 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 Vin -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
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 da...@grugeon.com.au wrote: 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 it in excel. Regards David Grugeon On 29 September 2012 21:36, Lokesh Loki lokeshsmg2...@gmail.com wrote: 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.com wrote: Most of time it does not give fine result. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of Radoslav Ganov Sent: 29 September 2012 12:35 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel Sorry *Abbyy FineReader On Fri, Sep 28, 2012 at 12:03 PM, Radoslav Ganov radoslav.ga...@gmail.com wrote: Use Abbey Finereader it can convert any image with alphanumerical values to word and after that you can copy the values to excel On Fri, Sep 28, 2012 at 9:53 AM, Rajan_Verma rajanverma1...@gmail.com wrote: I don’t think if there is a way to do that. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: 28 September 2012 6:24 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert Gif Image in to Ms Excel Hi Experts, Here it is the task for converting GIF image in to MS Excel MS Word as it is content. The image contains alpha and numeric data. Is this possible to convert this image in to MS Excel MS Word? or please advice me how can i convert this image in to ms excel ms word. Regards Lokesh M -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Radoslav Tsvetkov Ganov Microsoft Certified Professional Phone: +359897931801 E-mail: radoslav.ga...@gmail.bg -- Radoslav Tsvetkov Ganov Microsoft Certified Professional Phone: +359897931801 E-mail: radoslav.ga...@gmail.bg -- Join official facebook page of this
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 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 Vin -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
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 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: 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 BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Excel Conditional Formatting formula
=(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% 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.comwrote: 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 BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. conditional Fotmating.xls Description: MS-Excel spreadsheet
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 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 rao vinod.ma...@gmail.com wrote: 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.comwrote: 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.comwrote: 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 BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Sam Mathai Chacko -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not
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 lokeshsmg2...@gmail.com wrote: 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 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 it in excel. Regards David Grugeon On 29 September 2012 21:36, Lokesh Loki lokeshsmg2...@gmail.com wrote: 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.com wrote: Most of time it does not give fine result. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Radoslav Ganov Sent: 29 September 2012 12:35 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel Sorry *Abbyy FineReader On Fri, Sep 28, 2012 at 12:03 PM, Radoslav Ganov radoslav.ga...@gmail.com wrote: Use Abbey Finereader it can convert any image with alphanumerical values to word and after that you can copy the values to excel On Fri, Sep 28, 2012 at 9:53 AM, Rajan_Verma rajanverma1...@gmail.com wrote: I don’t think if there is a way to do that. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: 28 September 2012 6:24 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert Gif Image in to Ms Excel Hi Experts, Here it is the task for converting GIF image in to MS Excel MS Word as it is content. The image contains alpha and numeric data. Is this possible to convert this image in to MS Excel MS Word? or please advice me how can i convert this image in to ms excel ms word. Regards Lokesh M -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
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 help. Regards Lokesh. M On Sun, Sep 30, 2012 at 12:52 AM, David Grugeon da...@grugeon.com.auwrote: 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: 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 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 it in excel. Regards David Grugeon On 29 September 2012 21:36, Lokesh Loki lokeshsmg2...@gmail.com wrote: 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.com wrote: Most of time it does not give fine result. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Radoslav Ganov Sent: 29 September 2012 12:35 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert Gif Image in to Ms Excel Sorry *Abbyy FineReader On Fri, Sep 28, 2012 at 12:03 PM, Radoslav Ganov radoslav.ga...@gmail.com wrote: Use Abbey Finereader it can convert any image with alphanumerical values to word and after that you can copy the values to excel On Fri, Sep 28, 2012 at 9:53 AM, Rajan_Verma rajanverma1...@gmail.com wrote: I don’t think if there is a way to do that. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lokesh Loki Sent: 28 September 2012 6:24 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Convert Gif Image in to Ms Excel Hi Experts, Here it is the task for converting GIF image in to MS Excel MS Word as it is content. The image contains alpha and numeric data. Is this possible to convert this image in to MS Excel MS Word? or please advice me how can i convert this image in to ms excel ms word. Regards Lokesh M -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums
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 noorain.ans...@gmail.comwrote: Nice Creativity Rajan... On Sat, Sep 29, 2012 at 12:05 AM, Rajan_Verma rajanverma1...@gmail.comwrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (rajanverma1...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D1dpgyyl0KYOxyEEj6wZg0S4CzsuRC0C2FrF6bJPcxr6eYzv4jvWjpJZRziJArmzCKqRs%252B6uTFUDLSqUhwccXyrUSZ5kxzSFzrCYHYGMSKEvE7OBcFM63zUScD7n32KJ5WVbrPiVHROD3YJSJHZS0DQ%253D%253D%26key%3DMW3z8G4047LkKs0ZKqsh%252BpCl56jXn0IDvk609ed%252Fvyw%253Dtc=12523733031_1064418514| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12523733031_1064418514 Hi Christi See the attached File . Its dynamic if you want to add more angle you can add in the yellow table ... Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 27 September 2012 10:19 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ circular x axis in excel graph I am working on this . will get back to you shortly Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com ] On Behalf Of David Grugeon Sent: 27 September 2012 1:58 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in excel graph I think you can make a list of all 360 points and leave those without data blank Regards David Grugeon On 27 September 2012 03:03, Christi Jacob christi.ja...@gmail.com wrote: Hello Rajan, the result is close to the requirement although it looks like the radar has been rotated by some angle. thanks can the graph be modified for angles which are not evenly spaced (ie in the example the angles are spaced 45deg apart. in actual case the first angle might be 25deg followed by 65 deg followed by 90deg...) regards, christi jacob On Wed, Sep 26, 2012 at 8:48 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Not exactly same.. but I made something J See the attached Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Christi Jacob Sent: 26 September 2012 7:09 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in excel graph Dear friends, i am attaching a image file of the expected graph note: instead of radial line i actually require a curve through the points as shown in the image file ( :( ) also the number of data points may be 8, 10, 20 etc in various cases hence if it is possible to automate it it will be good thanks christi jacob On Wed, Sep 26, 2012 at 6:03 AM, David Grugeon da...@grugeon.com.au wrote: See attachment for the sort of chart required. Regards David Grugeon On 26 September 2012 10:22, David Grugeon da...@grugeon.com.au wrote: There is an explanation how to do it and a very useful sample workbook download at this site http://www.ozgrid.com/Excel/polar-plot-chart.htm Regards David Grugeon On 26 September 2012 09:56, David Grugeon da...@grugeon.com.au wrote: I do not know of a chat type in excel that does what you want directly. Since you only have 8 data points (360 is the same as 0 so can be ignored) you could do it by making 8 doughnut charts and putting them on top of each other. Clunky, I know, but it is probably better than trying to plot the 8 points and join them each to 0,0 coordinate. Turtle Graphics anyone? Regards David Grugeon On 26 September 2012 05:41, Sam Mathai Chacko samde...@gmail.com wrote: maybe you can draw a sample in paint and post it so that people understand what exactly you are looking for in the chart. On Wed, Sep 26, 2012 at 1:06 AM, Christi Jacob christi.ja...@gmail.com wrote: Dear friends, this is my first query to this group i am having a data which may be as follows anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 the values under heading angle are in degrees i would like to plot them in a graph such that the independent axis shows up on a circle as angular location and strength value shows up as radial lines Please guide regards, christi jacob -- 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
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 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, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Nice Creativity Rajan... On Sat, Sep 29, 2012 at 12:05 AM, Rajan_Verma rajanverma1...@gmail.comwrote: [image: Boxbe] https://www.boxbe.com/overview This message is eligible for Automatic Cleanup! (rajanverma1...@gmail.com) Add cleanup rulehttps://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3D1dpgyyl0KYOxyEEj6wZg0S4CzsuRC0C2FrF6bJPcxr6eYzv4jvWjpJZRziJArmzCKqRs%252B6uTFUDLSqUhwccXyrUSZ5kxzSFzrCYHYGMSKEvE7OBcFM63zUScD7n32KJ5WVbrPiVHROD3YJSJHZS0DQ%253D%253D%26key%3DMW3z8G4047LkKs0ZKqsh%252BpCl56jXn0IDvk609ed%252Fvyw%253Dtc=12523733031_1064418514| More infohttp://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=12523733031_1064418514 Hi Christi See the attached File . Its dynamic if you want to add more angle you can add in the yellow table ... Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: Rajan_Verma [mailto:rajanverma1...@gmail.com] Sent: 27 September 2012 10:19 To: 'excel-macros@googlegroups.com' Subject: RE: $$Excel-Macros$$ circular x axis in excel graph I am working on this . will get back to you shortly Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] On Behalf Of David Grugeon Sent: 27 September 2012 1:58 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in excel graph I think you can make a list of all 360 points and leave those without data blank Regards David Grugeon On 27 September 2012 03:03, Christi Jacob christi.ja...@gmail.com wrote: Hello Rajan, the result is close to the requirement although it looks like the radar has been rotated by some angle. thanks can the graph be modified for angles which are not evenly spaced (ie in the example the angles are spaced 45deg apart. in actual case the first angle might be 25deg followed by 65 deg followed by 90deg...) regards, christi jacob On Wed, Sep 26, 2012 at 8:48 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Not exactly same.. but I made something J See the attached Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Christi Jacob Sent: 26 September 2012 7:09 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ circular x axis in excel graph Dear friends, i am attaching a image file of the expected graph note: instead of radial line i actually require a curve through the points as shown in the image file ( :( ) also the number of data points may be 8, 10, 20 etc in various cases hence if it is possible to automate it it will be good thanks christi jacob On Wed, Sep 26, 2012 at 6:03 AM, David Grugeon da...@grugeon.com.au wrote: See attachment for the sort of chart required. Regards David Grugeon On 26 September 2012 10:22, David Grugeon da...@grugeon.com.au wrote: There is an explanation how to do it and a very useful sample workbook download at this site http://www.ozgrid.com/Excel/polar-plot-chart.htm Regards David Grugeon On 26 September 2012 09:56, David Grugeon da...@grugeon.com.au wrote: I do not know of a chat type in excel that does what you want directly. Since you only have 8 data points (360 is the same as 0 so can be ignored) you could do it by making 8 doughnut charts and putting them on top of each other. Clunky, I know, but it is probably better than trying to plot the 8 points and join them each to 0,0 coordinate. Turtle Graphics anyone? Regards David Grugeon On 26 September 2012 05:41, Sam Mathai Chacko samde...@gmail.com wrote: maybe you can draw a sample in paint and post it so that people understand what exactly you are looking for in the chart. On Wed, Sep 26, 2012 at 1:06 AM, Christi Jacob christi.ja...@gmail.com wrote: Dear friends, this is my first query to this group i am having a data which may be as follows anglestrength 0 10 45 20 90 30 13520 1800 22520 27030 31520 36010 the values under heading angle are in degrees i would like to plot them in a graph such that the independent axis shows up on a circle as angular location and strength value shows up as radial lines Please guide regards, christi jacob -- Join official facebook
$$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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
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 on my BlackBerryR 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$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, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$
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: excel-macros@googlegroups.com Subject: 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 on my BlackBerryR 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.