RE: $$Excel-Macros$$ about set focus event
Also, regular form controls support the Enter event which is very similar. It fires when the control gets focus from another control on the form. Form controls also have an Exit event, which is like LostFocus but only among the form's controls (when the form gets/loses focus these events are not fired.) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Friday, January 27, 2012 11:47 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ about set focus event Hello Shankar, If you mean a SetFocus method, form and ActiveX controls have that in Excel. If you mean a GotFocus event, ActiveX controls have that and you can use them in Excel. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shankar Bheema Sent: Friday, January 27, 2012 9:07 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ about set focus event Dear Experts In VB there is a facility of SET FOCUS event whereas in Excel VBA it is not provided. Is there any alternative for it in excel vba ? regards shankar sb -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Excel - Array Help
Thanks Noorain, I have just seen your email... I understand the formula...only part i am not getting is... this pat ($A$2:$A2=A2)*($B$2:$B2=B2))1...how the result of 2 comparison can be greater than 1? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 21 January 2012 21:51 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Array Help Dear Amit, In this formula we are searching unique value of two columns Red Color part is 1st criteria Green Color part is 2nd Criteria =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique) we can also use.. =IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2)1,Duplicate,Unique) -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Sat, Jan 21, 2012 at 11:27 AM, Amit Desai (MERU) amit.de...@merucabs.commailto:amit.de...@merucabs.com wrote: Dear All, Can someone please explain how the below formula will work I mean what logic it will follow. Regards, Amit Desai From: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.commailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 20 January 2012 16:22 To: excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Array Help Dear Sourabh, Please use this one to find unique value of more than one column without using helping column =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique) See attached sheet. On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra rhtdmja...@gmail.commailto:rhtdmja...@gmail.com wrote: Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.commailto:noorain.ans...@gmail.com wrote: Dear Sourabh, Please see attached sheet. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra rhtdmja...@gmail.commailto:rhtdmja...@gmail.com wrote: dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.commailto:noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name =SUM(1/COUNTIF(B2:B6,B2:B6)) press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. =IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) see attached sheet.. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.commailto:kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to
Re: $$Excel-Macros$$ help
Hi Vijay, Look Below about relative refrence.. *What are the types of references?*1. Absolute Column/Absolute Rowe.g. $A$1means Whether you use auto-fill across column or across row, the reference won't be changed. 2. Absolute Column/Relative Rowe.g. $A1means When you use auto-fill across column, it will remain column A but when you auto-fill across row, the reference will change to $A2, $A3, $A4 and so on. 3. Relative Column/Absolute Rowe.g. A$1means When you use auto-fill across row, it will remain row 1 but when you auto-fill across column, the reference will change to B$1, C$1, D$1 and so on. 4. Relative Column/Relative Rowe.g. A1means When you use auto-fill across column, the reference will change to B1, C1, D1 and so on and when you auto-fill across row, the reference will change to A2, A3, A4 and so on.*How to change the reference?*1. Prefix with $ manually.2. Right after entering the formula use F4 to toggle between the four kinds of references. (recommended) *Where to use?*You can use it in formula or function in Excel spreadsheet, rest depends on your logic. *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Sat, Jan 28, 2012 at 11:21 AM, vijayajith VA vijayajith...@gmail.comwrote: Hello sir, Just i want to know about use relative reference in vb developer tab.? What is use of that ? Thanks in advance ' -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * * * * -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ about set focus event
Hai Asa. May I have one example pls. Because I tried but I did not get. regards shankar sb On Sat, Jan 28, 2012 at 1:30 PM, Asa Rossoff a...@lovetour.info wrote: Also, regular form controls support the Enter event which is very similar. It fires when the control gets focus from another control on the form. Form controls also have an Exit event, which is like LostFocus but only among the form's controls (when the form gets/loses focus these events are not fired.) ** ** Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Asa Rossoff *Sent:* Friday, January 27, 2012 11:47 PM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ about set focus event ** ** Hello Shankar, If you mean a SetFocus method, form and ActiveX controls have that in Excel. If you mean a GotFocus event, ActiveX controls have that and you can use them in Excel. ** ** Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema *Sent:* Friday, January 27, 2012 9:07 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ about set focus event ** ** Dear Experts In VB there is a facility of SET FOCUS event whereas in Excel VBA it is not provided. Is there any alternative for it in excel vba ? regards shankar sb -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Hours calculate highlighted colum
Dear Yasir Please find the solution in the attached file. On Sat, Jan 28, 2012 at 10:12 AM, yasir_shahjee yasir.shah...@gmail.comwrote: Respected Masters, Kindly check attached sheet. i need Time calculate in Hours. hopefully its really easier for Masters. thanks -- Yasir Waheed Factory Manager Sinopak Extrusion Technologies (Pvt.) Ltd. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Hours calculate (Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ help
Venkat, You are digressing from the question, although explaining what absolute and relative reference is good for common understanding. The question in particular, however, is regarding relative reference in vb developer tab. Vijay, the Relative Reference button is just a way to tell the VBA whether to record macros using and absolute reference, or whether to keep the active cells as a reference point to where the action takes place. In simple terms for example, if you record a macro, keeping your active cells as A1, and if you select D4, the macro will say that you selected D4. However, if you use relative reference, the macro will say you selected a cell that is offset by 3 rows and 3 columns. Hope that's clear. Regards, Sam Mathai Chacko On Sat, Jan 28, 2012 at 5:25 PM, Venkat CV venkat1@gmail.com wrote: Hi Vijay, Look Below about relative refrence.. *What are the types of references?* 1. Absolute Column/Absolute Rowe.g. $A$1 means Whether you use auto-fill across column or across row, the reference won't be changed. 2. Absolute Column/Relative Rowe.g. $A1means When you use auto-fill across column, it will remain column A but when you auto-fill across row, the reference will change to $A2, $A3, $A4 and so on. 3. Relative Column/Absolute Rowe.g. A$1 means When you use auto-fill across row, it will remain row 1 but when you auto-fill across column, the reference will change to B$1, C$1, D$1 and so on. 4. Relative Column/Relative Rowe.g. A1means When you use auto-fill across column, the reference will change to B1, C1, D1 and so on and when you auto-fill across row, the reference will change to A2, A3, A4 and so on. *How to change the reference?*1. Prefix with $ manually. 2. Right after entering the formula use F4 to toggle between the four kinds of references. (recommended) *Where to use?* You can use it in formula or function in Excel spreadsheet, rest depends on your logic. *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71 * On Sat, Jan 28, 2012 at 11:21 AM, vijayajith VA vijayajith...@gmail.comwrote: Hello sir, Just i want to know about use relative reference in vb developer tab.? What is use of that ? Thanks in advance ' -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * * * * -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ about set focus event
Here's a simple example where you can SETFOCUS on a user form control Regards, Sam Mathai Chacko On Sat, Jan 28, 2012 at 5:46 PM, Shankar Bheema shankar.n...@gmail.comwrote: Hai Asa. May I have one example pls. Because I tried but I did not get. regards shankar sb On Sat, Jan 28, 2012 at 1:30 PM, Asa Rossoff a...@lovetour.info wrote: Also, regular form controls support the Enter event which is very similar. It fires when the control gets focus from another control on the form. Form controls also have an Exit event, which is like LostFocus but only among the form's controls (when the form gets/loses focus these events are not fired.) ** ** Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Asa Rossoff *Sent:* Friday, January 27, 2012 11:47 PM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ about set focus event ** ** Hello Shankar, If you mean a SetFocus method, form and ActiveX controls have that in Excel. If you mean a GotFocus event, ActiveX controls have that and you can use them in Excel. ** ** Asa ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Shankar Bheema *Sent:* Friday, January 27, 2012 9:07 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ about set focus event ** ** Dear Experts In VB there is a facility of SET FOCUS event whereas in Excel VBA it is not provided. Is there any alternative for it in excel vba ? regards shankar sb -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ Hours calculate highlighted colum
You cannot add time to a date that already has time. The solution has to take out the date value and time value separately. Otherwise, it will give inconsistent results. Here's how the calculation should be. Also, formatting it to [h]:mm:ss will give an exact idea of the duration. =ROUNDDOWN(G6,0)+H6-ROUNDDOWN(E6,0)-F6 Regards, Sam Mathai Chacko On Sat, Jan 28, 2012 at 6:16 PM, Yahya Muhammad yahya...@gmail.com wrote: Dear Yasir Please find the solution in the attached file. On Sat, Jan 28, 2012 at 10:12 AM, yasir_shahjee yasir.shah...@gmail.comwrote: Respected Masters, Kindly check attached sheet. i need Time calculate in Hours. hopefully its really easier for Masters. thanks -- Yasir Waheed Factory Manager Sinopak Extrusion Technologies (Pvt.) Ltd. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Hour Calculate.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Excel - Array Help
Did you copy down the formula? Don Guillett SalesAid Software dguille...@gmail.com From: Amit Desai (MERU) Sent: Saturday, January 28, 2012 2:43 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel - Array Help Thanks Noorain, I have just seen your email... I understand the formula...only part i am not getting is... this pat ($A$2:$A2=A2)*($B$2:$B2=B2))1...how the result of 2 comparison can be greater than 1? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 21 January 2012 21:51 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Array Help Dear Amit, In this formula we are searching unique value of two columns Red Color part is 1st criteria Green Color part is 2nd Criteria =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique) we can also use.. =IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2)1,Duplicate,Unique) -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Sat, Jan 21, 2012 at 11:27 AM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear All, Can someone please explain how the below formula will work I mean what logic it will follow. Regards, Amit Desai From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 20 January 2012 16:22 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Array Help Dear Sourabh, Please use this one to find unique value of more than one column without using helping column =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique) See attached sheet. On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra rhtdmja...@gmail.com wrote: Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sourabh, Please see attached sheet. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra rhtdmja...@gmail.com wrote: dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name =SUM(1/COUNTIF(B2:B6,B2:B6)) press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. =IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) see attached sheet.. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Adding an Item to a Collection within a Dictionary
I am trying to add an item to a specific collection within a dictionary. I am not sure how to do this. Any ideas? Thank you. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Adding an Item to a Collection within a Dictionary
Posting the code might help! Sam On Sat, Jan 28, 2012 at 2:09 AM, IF itayfeld...@gmail.com wrote: I am trying to add an item to a specific collection within a dictionary. I am not sure how to do this. Any ideas? Thank you. -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel - Array Help
You don't compare RESULT of two, you check if the count of the number of times your equation is satisfying the criteria is greater than 1 or not. So if you equate $A$2:$A6=A6 you will get some TRUE and some FALSE. Similary for column B also you'll get some TRUE and FALSE. The multiplication of boolean values will either give 0 or 1. 1 only when both the equations give a TRUE. And you can only get 2 or more if there are duplicates. Otherwise it will always be 1. Hope that explains ($A$2:$A2=A2)*($B$2:$B2=B2) Regards, Sam Mathai Chacko On Sat, Jan 28, 2012 at 7:21 PM, dguillett1 dguille...@gmail.com wrote: Did you copy down the formula? Don Guillett SalesAid Software dguille...@gmail.com *From:* Amit Desai (MERU) amit.de...@merucabs.com *Sent:* Saturday, January 28, 2012 2:43 AM *To:* excel-macros@googlegroups.com *Subject:* RE: $$Excel-Macros$$ Excel - Array Help Thanks Noorain, I have just seen your email... I understand the formula...only part i am not getting is... this pat ($A$2:$A2=A2)*($B$2:$B2=B2))1...how the result of 2 comparison can be greater than 1? *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* 21 January 2012 21:51 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Excel - Array Help Dear Amit, In this formula we are searching unique value of two columns Red Color part is 1st criteria Green Color part is 2nd Criteria =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique) we can also use.. =IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2)1,Duplicate,Unique) -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Sat, Jan 21, 2012 at 11:27 AM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear All, Can someone please explain how the below formula will work I mean what logic it will follow. Regards, *Amit Desai* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* 20 January 2012 16:22 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Excel - Array Help Dear Sourabh, Please use this one to find unique value of more than one column without using helping column *=IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique)* See attached sheet. On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra rhtdmja...@gmail.com wrote: Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sourabh, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra rhtdmja...@gmail.com wrote: * * dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * see attached sheet.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- FORUM RULES (986+ 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)
Re: $$Excel-Macros$$ Excel - Array Help
Hey Amit, look for SUMPRODUCT formula information and you will get your answer. From: Amit Desai (MERU) Sent: Saturday, January 28, 2012 2:43 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel - Array Help Thanks Noorain, I have just seen your email... I understand the formula...only part i am not getting is...this pat ($A$2:$A2=A2)*($B$2:$B2=B2))1...how the result of 2 comparison can be greater than 1? From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 21 January 2012 21:51 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Array Help Dear Amit, In this formula we are searching unique value of two columns Red Color part is 1st criteria Green Color part is 2nd Criteria =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique) we can also use.. =IF(COUNTIFS($A$2:A2,A2,$B$2:B2,B2)1,Duplicate,Unique) -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Sat, Jan 21, 2012 at 11:27 AM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear All, Can someone please explain how the below formula will work I mean what logic it will follow. Regards, Amit Desai From:excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: 20 January 2012 16:22 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel - Array Help Dear Sourabh, Please use this one to find unique value of more than one column without using helping column =IF(SUMPRODUCT(($A$2:$A2=A2)*($B$2:$B2=B2))1,Duplicate,Unique) See attached sheet. On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra rhtdmja...@gmail.com wrote: Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Sourabh, Please see attached sheet. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra rhtdmja...@gmail.com wrote: dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name =SUM(1/COUNTIF(B2:B6,B2:B6)) press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. =IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) see attached sheet.. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay
Re: $$Excel-Macros$$ Re: Need help in building pivot using vba
hi Ansari, I am bit new to vba coding as this pivot source data is within sheet as per attached sheet . *my query is * if i have data in different sheet please advise. can you please help to provide this below listed steps code 1) to copy particular sheet from one existing workbook to new workbook 2) in that new work book i want to build the pivot . On Fri, Jan 27, 2012 at 3:07 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Rekha, Please find the code to build pivot using vba On Fri, Jan 27, 2012 at 10:53 AM, rekha siri rekha.siri2...@gmail.comwrote: Need pivot macro assistance.. On Wed, Jan 18, 2012 at 9:59 PM, rekha siri rekha.siri2...@gmail.comwrote: hi experts, Please provide the code to build pivot using vba this macro is provided to me in past by rajan really thank full for the concern. adding to that i need to prepare pivot for west bu from attached macro raw data sheet. pivot format is also attached it should be as per West december2011 file's pivot manner. attached are macro and west december workbooks which contain pivot .. kindly help in this concern thanks. Rekha -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Display numbers in Lakhs
Hi, In Excel I needs to convert numbers in to indian format and the value should divided by lakhs and display in Lakhs. Example Rs.924104600.90 should reflect as Rs.9,241(in lakhs, Indian format) Plz help. Regards, Prabhu -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ By Default 2003
Dear Experts, I am using windows 7 platform and installed Excel 2003 2007 (both). When i click at any excel file it open by default in excel 2007. I want default should be excel 2003. Please give me suggesstion. I have done from view menu and programme default in 2003 but it's not working. Awaiting your positive responce Regards, Sajid Memon -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Display numbers in Lakhs
Hi Prabhu, If you have the amount in number format, simply divide it by 10. If you have the amount in text i.e., Rs.924104600.90, use following formula:- =Rs.TEXT(VALUE(MID(a1,4,50))/10,0,000) You can play around with format 0,000 which is present at the right end of the formula. Thanks. Regards, DILIPandey On 1/29/12, Prabhu prabhugate...@gmail.com wrote: Hi, In Excel I needs to convert numbers in to indian format and the value should divided by lakhs and display in Lakhs. Example Rs.924104600.90 should reflect as Rs.9,241(in lakhs, Indian format) Plz help. Regards, Prabhu -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ By Default 2003
Hi Sajid, I had the similar issue and corrected that later... since I run Office 2010 and can't test this out but sill remember following two option which I had tried during my encounter :) Two tryouts :- 1) Right click an excel file (preferable xlsx) - open with - choose Excel 2003 as the default application. 2) Install 2007 first and Install 2003 later. Let me know what works ... I am also interested to know about this. :) Regards, DILIPandey On 1/29/12, SAJID MEMON sajidwi...@hotmail.com wrote: Dear Experts, I am using windows 7 platform and installed Excel 2003 2007 (both). When i click at any excel file it open by default in excel 2007. I want default should be excel 2003. Please give me suggesstion. I have done from view menu and programme default in 2003 but it's not working. Awaiting your positive responce Regards, Sajid Memon -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Please Help me to create summary and Macro.
Hi Avinash, Not entirely getting your point. Please confirm if you need following which I can understand per your post :) 1) Following results as per Date in first field this you have already attached DateTotal Product Actual PriceTotal Number Of ProductsGrand Total Sheet Location 2) Hyperlink in last field to each row entered ? I believe either you are explained too much in your post or missed to put the crux of your issue in lime light. :) Regards, DILIPandey On 1/27/12, Avinash Patil avinash007pa...@gmail.com wrote: Hi Experts, i am currently facing very serious problem cuz every day i have to generate data from various workbooks wich is bassed on the daily reports. and i have to show any increase or decrease on any perticular day to get this done i have to insert 1 sheet called summary it contains following details like day wise details. but to show the day wise performance i have to link specific cells e.g sheet name jan 01 total products = 06 (D14) so if the client wants to see performance for the specific day i have to vlookup for the results and the lookup is bassed on summary sheet plus if there there will be uncertain increase or decrease in the data i have to create link for that specific day. but link should not be in hyperlink format it should b in normal format but only highlited in red font. and by the way i have to create summary sheet for my refrence not for client client want result only for specific day like for increase and decrease. client result is using red border. i have attached the sheet for your refrence please see the attached file and kindly help me in this regards. if possible can anyone please prepare a macro/formula to get the details -- Thanks and Regards, Avinash Love does not happen its a choice. Its not magic or fate, but it is when a person takes their natural affinity/attraction for someone and translates it into commitment and actions that express love. Disclaimer: The information transmitted is intended only for the person(s) or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the intended recipient of this message you are hereby notified that any use, review, retransmission, dissemination, distribution, reproduction or any action taken in reliance upon this message is prohibited. If you receive this in error, please contact the sender -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ By Default 2003
Hi, this is simple way to do. Go to XLstartup folder and delete excel 2007 icon. So default excel 2003 opens. i m travelling . so cannot provide the exact path where xlstartup exist. Try this if not possible one more solution is there.. On 1/29/12, Dilip Pandey dilipan...@gmail.com wrote: Hi Sajid, I had the similar issue and corrected that later... since I run Office 2010 and can't test this out but sill remember following two option which I had tried during my encounter :) Two tryouts :- 1) Right click an excel file (preferable xlsx) - open with - choose Excel 2003 as the default application. 2) Install 2007 first and Install 2003 later. Let me know what works ... I am also interested to know about this. :) Regards, DILIPandey On 1/29/12, SAJID MEMON sajidwi...@hotmail.com wrote: Dear Experts, I am using windows 7 platform and installed Excel 2003 2007 (both). When i click at any excel file it open by default in excel 2007. I want default should be excel 2003. Please give me suggesstion. I have done from view menu and programme default in 2003 but it's not working. Awaiting your positive responce Regards, Sajid Memon -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks Regards, DILIP KUMAR PANDEY, mvp MBA,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sent from my mobile device Regards Yogananda Muthaiah Ph : 973 123 7267 -- FORUM RULES (986+ 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. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com