Re: $$Excel-Macros$$ Dialing a Phone Number in Excel??
http://www.phonedialerpro.com/#Excel On Fri, Feb 24, 2012 at 10:38 PM, Ms. Joy joypue...@gmail.com wrote: Someone asked me if I knew how to make Excel dial a phone number??? Has anyone ever heard of this? How would I make this happen? Can someone explain the logic and functionality? -- 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://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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
Re: $$Excel-Macros$$ Re: date format
Awesom Logic Haseeb... On Mon, Feb 27, 2012 at 8:19 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Hi Lee, try For the Week, =WEEKNUM(TEXT(A1,\-00\-00)) For the month, =TEXT(TEXT(A1,\-00\-00),) HTH Haseeb -- 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://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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
Re: $$Excel-Macros$$ Dear group, plz I need a help . Y ou are able to see cols A to E. In this I want the the formula in col C so that I can execute the relevant cost code depending on the amounts in
Dear Muneer Explain your problem in the body of the mail instead of subject and kindly also let us know one output example for your requirement On Mon, Feb 27, 2012 at 3:28 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: ** Regards, Muneer, CC -- 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$$ formula
thanks to all its very usefull for me.. On 1/17/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Most Welcome Darwin.. On Tue, Jan 17, 2012 at 9:59 AM, Darwin Chan darwin.chankaw...@gmail.comwrote: Thanks for Noorain reading notes, some tricks i even dun know. 2012/1/17 NOORAIN ANSARI noorain.ans...@gmail.com Dear Manoj, Please study attached material and follow this Excel-Macro group regularly. Hope it will help to u -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Jan 16, 2012 at 11:51 PM, Manoj Kumar kmrmanoj1...@gmail.comwrote: Hello Members i want grow my excel formula knowledge. Please provide help and some notes . regards Manoj -- 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 -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- 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
Re: $$Excel-Macros$$ formula
You can download xlfdic from google On 2/27/12, Manoj Kumar kmrmanoj1...@gmail.com wrote: thanks to all its very usefull for me.. On 1/17/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Most Welcome Darwin.. On Tue, Jan 17, 2012 at 9:59 AM, Darwin Chan darwin.chankaw...@gmail.comwrote: Thanks for Noorain reading notes, some tricks i even dun know. 2012/1/17 NOORAIN ANSARI noorain.ans...@gmail.com Dear Manoj, Please study attached material and follow this Excel-Macro group regularly. Hope it will help to u -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Mon, Jan 16, 2012 at 11:51 PM, Manoj Kumar kmrmanoj1...@gmail.comwrote: Hello Members i want grow my excel formula knowledge. Please provide help and some notes . regards Manoj -- 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 -- Darwin Chan darwin.chankaw...@gmail.com kw42c...@yahoo.com.hk -- 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)
Re: $$Excel-Macros$$ Pivot uncheck All
Dear Deba, Please send your query in seprate mail instead of Thread mail. On Mon, Feb 27, 2012 at 4:21 PM, Deba Ranjan drdeva...@gmail.com wrote: *Hi Expert, Please create a automatic pivot table by help of marcos in urgent basis. Please . * *Regards* *Deba Ranjan P** * *[image: http://www.fileden.com/files/2008/8/21/2058970/greatday.gif]*** ^^ஜ۩۞۩ஜ▬▬▬ ▬^^ * * * * On Mon, Feb 27, 2012 at 12:36 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Kiran, See attachment, it might be help to you. -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Sun, Feb 26, 2012 at 11:45 PM, Kiran Kancharla srkira...@gmail.comwrote: Hi All, Below is the Macro I have recorded for unchecking the Pivot Table. ActiveSheet.PivotTables(PivotTable2).PivotFields(Month).CurrentPage = (All) With ActiveSheet.PivotTables(PivotTable2).PivotFields(Month) .PivotItems(Jan).Visible = False .PivotItems(Feb).Visible = True End With In the real case I have More than the 500 points to uncheck. I need macro to uncheck all selected in Pivot table and select only 1. I have a separate macro to Select the required point. Please help. I cannot attach the sheet as it has client information. -- Thanks Regards, Kiran -- 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 -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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 image001.gif
$$Excel-Macros$$ saving an excel sheet
is it possible to save a particular worksheet of a workbook with a save command button on an userform ? -- 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$$ saving an excel sheet
For workbook - ActiveWorkbook.Save For active sheet only - ActiveSheet.Select ActiveSheet.Copy ActiveSheet.SaveAs Filename:=YOUR DIR YOUR FILENAME .xls HTH Abhishek On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema shankar.n...@gmail.comwrote: is it possible to save a particular worksheet of a workbook with a save command button on an userform ? -- 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$$ saving an excel sheet
http://www.mrexcel.com/forum/showthread.php?t=354 On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema shankar.n...@gmail.comwrote: is it possible to save a particular worksheet of a workbook with a save command button on an userform ? -- 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://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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
Re: $$Excel-Macros$$ Excude some sheets in macro
You have been doing this awhile and should know better. Anyway. Sub copycorrectsheets() Dim ws As Worksheet For Each ws In Worksheets If ws.Name Summary _ And ws.Name forms _ And ws.Name admin Then ws.Range(G7).CurrentRegion.Copy _ Worksheets(summary).Cells(Rows.Count, G).End(xlUp)(2) End If Next ws End Sub Don Guillett SalesAid Software dguille...@gmail.com From: Cab Boose Sent: Sunday, February 26, 2012 10:45 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excude some sheets in macro Hi See attachedI workbook. XL2000 Refer to summary sheet I am wanting to extract data from some sheets into summary sheet. I can exclude 1 sheet ok, but when I try to exclude others I get syntax error. The line of code with problem is: If Worksheets(k).Name = summary, forms, admin Then GoTo nextk I do not want to copy cells in summary, forms, or admin. Something to do with the commas, have tried also without the commas. Should I clear the summary sheet each time before paste or delete sheet and make a new one called summary? Thanks and regards Charlie Harris -- 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$$ List Box Like Tally Software
For the position, use Private Sub UserForm_Activate() Me.Top = 150 Me.Left = 250 End Sub adjust it based on your requirement... to make it dynamic for any excel application or screen size, you'll have to use API For ISERROR problem in Excel 2003, use =IF(ISERR(INDEX(Data!$A$3:$A$640,SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)0,ROW(Data!$E$3:$E$640)-2,),ROW()-4))),,INDEX(Data!$A$3:$A$640,SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)0,ROW(Data!$E$3:$E$640)-2,),ROW()-4))) in A5 and drag formula across Regards, Sam Mathai Chacko On Mon, Feb 27, 2012 at 10:57 AM, chandra sekaran duraichan...@gmail.comwrote: Dear all this file not working with excel2003 iserror function regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.com wrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.comwrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate Unique My Cutomer will display if possible please Regards chandru On Mon, Feb 20, 2012 at 5:54 PM, Maries talk2mar...@gmail.com wrote: Hi, Find the attached file. If you type first name in search cell, respective datas will show below. Regards, MARIES. On Mon, Feb 20, 2012 at 2:03 PM, chandra sekaran duraichan...@gmail.com wrote: Dear all Here with attached List Box like Tally is this possible with excelonce Active List box or Cell shown under all name after enter first letter than showing start with all names like that Advance Thanks for all Regards chandru -- 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
Re: $$Excel-Macros$$ date format
Hi Lee, =WEEKNUM(--TEXT(A1,\/00\/00)) http://www.excelfox.com/forum/f13/convert-text-mmdd-format-date-format-74/ In your case, I'd use * =TEXT(--TEXT(A1,\/00\/00),mmm)-WWEEKNUM(--TEXT(A1,\/00\/00)) * to give *Oct-W41* Regards, Sam Mathai Chacko On Mon, Feb 27, 2012 at 11:47 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Hi Sara, Addition in Venkat Formula : For weeknum =WEEKNUM(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) For Month =MONTH(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) On Mon, Feb 27, 2012 at 7:52 AM, Venkat CV venkat1@gmail.com wrote: Hi , Try This, *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* *Best Regards,* *Venkat * *Chennai* *My Linked in profilehttp://in.linkedin.com/pub/venkatesan-c/21/492/a71 * On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee lee.sar...@gmail.com wrote: i have date in this format-- 20011012... yrmmdd.. i want to extract week no and month from this date. what is the formula -- 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 -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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 -- 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-Macros$$ Validate text and number in PAN
Ah! Quote Haseeb {I think this part ISNUMBER(--MID(A3,6,4)) will allow
entry with 3 spaces before the fourth digit :-) , like}
I think that's a very good catch Haseeb. :)
I think adding an IFERROR(FIND( ,Range)) will solve the problem.
Regards,
Sam Mathai Chacko
On Mon, Feb 27, 2012 at 12:50 PM, Vijayendra Rao
vijayendrar...@gmail.comwrote:
Thanks Sam, Maries Haseeb.
All three solutions are working fine.thanks again.
Regards,
Vijayendra
2012/2/27 Haseeb Avarakkan haseeb.avarak...@gmail.com
Hi Sam,
I think this part ISNUMBER(--MID(A3,6,4)) will allow entry with 3 spaces
before the fourth digit :-) , like
ABCDE 1D
Hi Vijayendra,
This is my try. Firstly define 3 names to avoid INDIRECT function.
Name: *Alpha*
On refers to:
={A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y;Z}
Name: *Row*
Refers to: ={1;2;3;4;5}
Name: *Col*
Refers to: ={6,7,8,9}
Then use this formula in Data Validation Custom. Make sure you have
unselect *Ignore blank*
=SUMPRODUCT(ISNUMBER(MATCH(MID(C2,Row,1),Alpha,0))*ISNUMBER(MID(C2,Col,1)+0)*ISNUMBER(MATCH(MID(C2,10,250),Alpha,0)))=20
HTH
Haseeb
--
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
--
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧
Regards,
Vijayendra
94491 67631
--
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$$ date format
Hi Sam, Is *Double Minus *required? On Mon, Feb 27, 2012 at 5:47 PM, Sam Mathai Chacko samde...@gmail.comwrote: Hi Lee, =WEEKNUM(--TEXT(A1,\/00\/00)) http://www.excelfox.com/forum/f13/convert-text-mmdd-format-date-format-74/ In your case, I'd use * =TEXT(--TEXT(A1,\/00\/00),mmm)-WWEEKNUM(--TEXT(A1,\/00\/00)) * to give *Oct-W41* Regards, Sam Mathai Chacko On Mon, Feb 27, 2012 at 11:47 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Hi Sara, Addition in Venkat Formula : For weeknum =WEEKNUM(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) For Month =MONTH(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) On Mon, Feb 27, 2012 at 7:52 AM, Venkat CV venkat1@gmail.com wrote: Hi , Try This, *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* *Best Regards,* *Venkat * *Chennai* *My Linked in profilehttp://in.linkedin.com/pub/venkatesan-c/21/492/a71 * On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee lee.sar...@gmail.com wrote: i have date in this format-- 20011012... yrmmdd.. i want to extract week no and month from this date. what is the formula -- 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 -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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 -- 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 -- 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
RE: $$Excel-Macros$$ $$Excel-Macros$$ Validate text and number in PAN
Another solution
=AND(NOT(SUM(--ISNUMBER(VALUE(MID(A1,ROW(INDIRECT(1:5)),1),SUM(--ISNUMBER(INT(MID(A1,ROW(INDIRECT(6:9)),1=4,NOT(--ISNUMBER(RIGHT(A1,1))),LEN(A1)=10)
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Sam Mathai Chacko
Sent: Feb/Mon/2012 07:22
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ $$Excel-Macros$$ Validate text and number in PAN
Ah! Quote Haseeb {I think this part ISNUMBER(--MID(A3,6,4)) will allow entry
with 3 spaces before the fourth digit :-) , like}
I think that's a very good catch Haseeb. :)
I think adding an IFERROR(FIND( ,Range)) will solve the problem.
Regards,
Sam Mathai Chacko
On Mon, Feb 27, 2012 at 12:50 PM, Vijayendra Rao vijayendrar...@gmail.com
wrote:
Thanks Sam, Maries Haseeb.
All three solutions are working fine.thanks again.
Regards,
Vijayendra
2012/2/27 Haseeb Avarakkan haseeb.avarak...@gmail.com
Hi Sam,
I think this part ISNUMBER(--MID(A3,6,4)) will allow entry with 3 spaces before
the fourth digit :-) , like
ABCDE 1D
Hi Vijayendra,
This is my try. Firstly define 3 names to avoid INDIRECT function.
Name: Alpha
On refers to:
={A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y;Z}
Name: Row
Refers to: ={1;2;3;4;5}
Name: Col
Refers to: ={6,7,8,9}
Then use this formula in Data Validation Custom. Make sure you have unselect
Ignore blank
=SUMPRODUCT(ISNUMBER(MATCH(MID(C2,Row,1),Alpha,0))*ISNUMBER(MID(C2,Col,1)+0)*ISNUMBER(MATCH(MID(C2,10,250),Alpha,0)))=20
HTH
Haseeb
--
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
--
ಧನ್ಯವಾದಗಳು,
ವಿಜಯೇಂದ್ರ,
೯೪೪೯೧ ೬೭೬೩೧
Regards,
Vijayendra
94491 67631
--
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
--
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$$ date format
OK Thanks SAM. On Mon, Feb 27, 2012 at 7:30 PM, Sam Mathai Chacko samde...@gmail.comwrote: No it isn't, it's just that it's a safe practice Maries On Mon, Feb 27, 2012 at 8:29 PM, Maries talk2mar...@gmail.com wrote: Hi Sam, Is *Double Minus *required? On Mon, Feb 27, 2012 at 5:47 PM, Sam Mathai Chacko samde...@gmail.comwrote: Hi Lee, =WEEKNUM(--TEXT(A1,\/00\/00)) http://www.excelfox.com/forum/f13/convert-text-mmdd-format-date-format-74/ In your case, I'd use * =TEXT(--TEXT(A1,\/00\/00),mmm)-WWEEKNUM(--TEXT(A1,\/00\/00)) * to give *Oct-W41* Regards, Sam Mathai Chacko On Mon, Feb 27, 2012 at 11:47 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Hi Sara, Addition in Venkat Formula : For weeknum =WEEKNUM(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) For Month =MONTH(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) On Mon, Feb 27, 2012 at 7:52 AM, Venkat CV venkat1@gmail.comwrote: Hi , Try This, *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* *Best Regards,* *Venkat * *Chennai* *My Linked in profilehttp://in.linkedin.com/pub/venkatesan-c/21/492/a71 * On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee lee.sar...@gmail.comwrote: i have date in this format-- 20011012... yrmmdd.. i want to extract week no and month from this date. what is the formula -- 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 -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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 -- 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
Re: $$Excel-Macros$$ date format
Sam Awesome as always! Thanks again On Feb 27, 2012, at 10:30 AM, Sam Mathai Chacko samde...@gmail.com wrote: No it isn't, it's just that it's a safe practice Maries On Mon, Feb 27, 2012 at 8:29 PM, Maries talk2mar...@gmail.com wrote: Hi Sam, Is Double Minus required? On Mon, Feb 27, 2012 at 5:47 PM, Sam Mathai Chacko samde...@gmail.com wrote: Hi Lee, =WEEKNUM(--TEXT(A1,\/00\/00)) http://www.excelfox.com/forum/f13/convert-text-mmdd-format-date-format-74/ In your case, I'd use =TEXT(--TEXT(A1,\/00\/00),mmm)-WWEEKNUM(--TEXT(A1,\/00\/00)) to give Oct-W41 Regards, Sam Mathai Chacko On Mon, Feb 27, 2012 at 11:47 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Hi Sara, Addition in Venkat Formula : For weeknum =WEEKNUM(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) For Month =MONTH(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))) On Mon, Feb 27, 2012 at 7:52 AM, Venkat CV venkat1@gmail.com wrote: Hi , Try This, =DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)) Best Regards, Venkat Chennai My Linked in profile On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee lee.sar...@gmail.com wrote: i have date in this format-- 20011012... yrmmdd.. i want to extract week no and month from this date. what is the formula -- 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 -- Thanks regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.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 -- 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
Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function
swt asa,
thnxx 4 providing us wid sch clear xplanatns n xmplss..:)
Bhakti
On 2/25/12, Asa Rossoff a...@lovetour.info wrote:
Hi Johann,
That is another example usage of a boolean expression as a criterion. In
your example you could actually omit the -- since you are multiplying the
expression already. The multiplication will also coerce the boolean to 0 or
1:
{ =LARGE(($E$1:$E$122=$G1)*$F$1:$F$122,COUNTIF($G$1:$G1,$G1)) }
The formula builds an array of 122 elements (the size of the ranges e1:e122
/ f1:f122). Each element equals [0 or (1 if E=(thisrow's G))] * [F]. That
resolves to an array of 0's and values from column G. That array is then
sorted from largest to smallest. Then the CountIf is calculated: The
CountIf expression counts the number of occurences of [this row's G] in
[this and prior row's G values] let's call that count n. Finally, Excel
returns the nth value from the sorted array.
_EFG formula evaluation
_
2 100 1 large({0,0,150,0,0,180,0,0,50},1) = large({180,150,50,..},1)
= 180
4 200 4 large({0,200,0,0,220,0,0,130,0},1) = large({220,200,130,..},1)
= 220
1 150 2 large({100,0,0,250,0,0,75,0,0},1) = large({250,100,75,..},1)
= 250
2 250 4 large({0,200,0,0,220,0,0,130,0},2) = large({220,200,130,..},2)
= 200
4 220 1 large({0,0,150,0,0,180,0,0,50},2) = large({180,150,50,..},2)
= 150
1 180 2 large({100,0,0,250,0,0,75,0,0},2) = large({250,100,75,..},2)
= 100
275 1 large({0,0,150,0,0,180,0,0,50},3) = large({180,150,50,..},3)
= 50
4 130 4 large({0,200,0,0,220,0,0,130,0},3) = large({220,200,130,..},3)
= 130
150 1 large({0,0,150,0,0,180,0,0,50},4) =
large({180,150,50,0,..},4) = 0
...
My brain is kind of tired and I'm not sure exactly sure what the overall
function of your formula is at the moment though :)
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of johann
Sent: Friday, February 24, 2012 12:49 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel
function
what about :
{=LARGE(- -($E$1:$E$122=$G1)*$F$1:$F$122,COUNTIF($G$1:$G1,$G1))}
?
--
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 mailto:excel-macros@googlegroups.com
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
$$Excel-Macros$$ Date : Illogical date checking in a entire column
Hi All, I have a table and one column is entered date. Example: B1:B500 I want to check all the dates are entered correctly and if there is any illogical dates within it. Default date format is mm/dd/.. Please help me... with excel macro to solve this as easier way to find.. Please let me know if you did not understand my request.. thanks regards, ganesh -- 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$$ Extract last digit number
please unsubscribe the posts From: Maries talk2mar...@gmail.com To: excel-macros@googlegroups.com Sent: Saturday, February 25, 2012 10:04 PM Subject: Re: $$Excel-Macros$$ Extract last digit number My Try: =MID(A1,FIND((,A1)+1,FIND(),A1)-FIND((,A1)-1) On Sat, Feb 25, 2012 at 8:31 PM, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi Sam, Thank you very much for sending the formula. Regards Lokesh.M On Sat, Feb 25, 2012 at 9:59 PM, Sam Mathai Chacko samde...@gmail.com wrote: =SUBSTITUTE(REPLACE(A1,1,FIND((,A1),),),) Regards, Sam Mathai Chacko On Sat, Feb 25, 2012 at 9:49 PM, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi All, I need a formula to extract 20 only form the below text and fix the same in to next cell. Canada_20120223_E002_E001(20) regards Lokesh.M -- 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 -- 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
$$Excel-Macros$$ Need to copy one excel sheet to another excel sheet
HI Experts, I have an opened excel sheet from where I need to run a Macro. I need this macro to copy data from another excel (which is closed) to a sheet in the already opened excel. Can some one give me the code for the same? Any help will be greatly appreciated. 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
Re: $$Excel-Macros$$ how can i convert nomber to test
Hi, Please advice i need this same macro for converting figures in words for Rupees as this macro is working for Dollars only. Kindly help in this regard. Regards, Vikram On 2/23/12, jitendr...@gmail.com jitendr...@gmail.com wrote: Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees Mail sent via way2sms. -- 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 -- Regards, Vikram Ahuja -- 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$$ Urgent help needed please
Hi, Can anyone please help me with a simple formula for the below data set. All I need is to a sum of all the figures (+/-) except for those which are =1/-1 0.47 0.40 0.26 1.05 0.21 2.50 0.05 -0.03 -0.07 -0.08 -0.31 -0.48 -0.65 -0.66 -0.80 -11.26 I don't seem to get it, I am sorry if it sounds very trivial, but any help will be appreciated, Thanks alot -- 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$$ List Box Like Tally Software
Hi Chandra, I think the iserror formula from Sam was not completely converted for Excel 2003. It still contained IFERROR in parts. This should work. Enter it at cell A5 on the MyOutput sheet and copy to all the formula cells there. I modified the formula slightly so it will work unchanged in all columns (I removed the $ signs in front of columns in the range Data!$A$3:$A$640 to make the column reference relative). =IF(ISERROR(INDEX(Data!A$3:A$640,SMALL(IF(IF(ISERROR(SEARCH($E$1,Data!$E$3:$ E$640,1)),0,SEARCH($E$1,Data!$E$3:$E$640,1))0,ROW(Data!$E$3:$E$640)-2,),R OW()-4))),,INDEX(Data!A$3:A$640,SMALL(IF(IF(ISERROR(SEARCH($E$1,Data!$E$3: $E$640,1)),0,SEARCH($E$1,Data!$E$3:$E$640,1))0,ROW(Data!$E$3:$E$640)-2,), ROW()-4))) Make sure to array enter it with Ctrl-Shift-Enter in a single cell and copy to the other cells. Also note that the formula is in cells that appear blank all the way down to row 22. Replace that formula with the new one for all those cells. There are a few other compatibility issues Excel detected: .On the Data sheet, the data validation rules refer to named ranges in another workbook. This is not supported in Excel 2003, and the data validation in columns F-K will not work or will be deleted. Column F's data validation rule is ALLOW: List (ignore blank, in-cell dropdown) SOURCE =staOne. Column G's is the same with SOURCE =Month. Column H's is the same with SOURCE =Status. Column I's is the same with SOURCE =Month again. Column J's is the same with SOURCE =Plant. Column K's is the same with SOURCE =Product. If you want those data validation lists, you'll need to put those lists in the same workbook and update the named ranges to point to them, then recreate the data validation rules if Excel deleted them. .The conditional formats used on the Data sheet are specified in such a way that multiple formats could apply to the same cells simultaneously. It looks to me that the formats are the same for all the formatting rules, so this was probably a mistake. But I didn't confirm this positively, so if the formats are intended to be merged, this is not possible in Excel 2003. If needed, you could achieve the exact same formatting effect by using more rules that each have all the combinations of conditions and formats. Again though, my cursory examination seems to indicate that this is a non-issue in reality. .Some formatting used is not supported and will be changed. I leave it as an exercise for you to make these few changes.. if you really need someone to make them for you or there is still a compatibility issue, just post back :) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of chandra sekaran Sent: Monday, February 27, 2012 9:03 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ List Box Like Tally Software hi all I thank Marrie, SAM he helped lot thing with out him i am not get this . once again i thank to him, the same time i want ask can you convert to this file to excel 2003 i tried your advice but it won't work please... Regards chandru On Mon, Feb 27, 2012 at 8:37 PM, Maries talk2mar...@gmail.com wrote: For Speedup, Use below Tuneup codes. With Application .Calculation=xlCalculationManual .ScreenUpdating=False ' Main Coding .Calculation=xlCalculationAutomatic .ScreenUpdating = True End With Regards, MARIES. On Mon, Feb 27, 2012 at 5:35 PM, Sam Mathai Chacko samde...@gmail.com wrote: For the position, use Private Sub UserForm_Activate() Me.Top = 150 Me.Left = 250 End Sub adjust it based on your requirement... to make it dynamic for any excel application or screen size, you'll have to use API For ISERROR problem in Excel 2003, use =IF(ISERR(INDEX(Data!$A$3:$A$640,SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$6 40,1),0)0,ROW(Data!$E$3:$E$640)-2,),ROW()-4))),,INDEX(Data!$A$3:$A$640, SMALL(IF(IFERROR(SEARCH($E$1,Data!$E$3:$E$640,1),0)0,ROW(Data!$E$3:$E$640)- 2,),ROW()-4))) in A5 and drag formula across Regards, Sam Mathai Chacko On Mon, Feb 27, 2012 at 10:57 AM, chandra sekaran duraichan...@gmail.com wrote: Dear all this file not working with excel2003 iserror function regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries talk2mar...@gmail.com wrote: Hi, I got your logic. Check the attachment. Type your text in cell D1 Enter. It will give answer. Regards, MARIES. On Mon, Feb 20, 2012 at 4:39 PM, chandra sekaran duraichan...@gmail.com wrote: Hi maries, thanks for your Reply, MyOutput Sheet D1 Activate then My List of Cutomer may shwon seperate list box or Below D1 Cell there itself we want to select or like sheet Name Tally List box like that if possible [ First time i do not know what are the customer are there in my Data so once D1 is Activate
Re: $$Excel-Macros$$ saving an excel sheet
thank you On Mon, Feb 27, 2012 at 5:57 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: http://www.mrexcel.com/forum/showthread.php?t=354 On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema shankar.n...@gmail.comwrote: is it possible to save a particular worksheet of a workbook with a save command button on an userform ? -- 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://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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
RE: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function
Aww :) thank you for your swtness too =)
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of BHAKTI PRABHAKAR
Sent: Friday, February 24, 2012 11:01 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel
function
swt asa,
thnxx 4 providing us wid sch clear xplanatns n xmplss..:)
Bhakti
On 2/25/12, Asa Rossoff a...@lovetour.info wrote:
Hi Johann,
That is another example usage of a boolean expression as a criterion. In
your example you could actually omit the -- since you are multiplying the
expression already. The multiplication will also coerce the boolean to 0
or
1:
{ =LARGE(($E$1:$E$122=$G1)*$F$1:$F$122,COUNTIF($G$1:$G1,$G1)) }
The formula builds an array of 122 elements (the size of the ranges
e1:e122
/ f1:f122). Each element equals [0 or (1 if E=(thisrow's G))] * [F].
That
resolves to an array of 0's and values from column G. That array is then
sorted from largest to smallest. Then the CountIf is calculated: The
CountIf expression counts the number of occurences of [this row's G] in
[this and prior row's G values] let's call that count n. Finally, Excel
returns the nth value from the sorted array.
_EFG formula evaluation
_
2 100 1 large({0,0,150,0,0,180,0,0,50},1) =
large({180,150,50,..},1)
= 180
4 200 4 large({0,200,0,0,220,0,0,130,0},1) =
large({220,200,130,..},1)
= 220
1 150 2 large({100,0,0,250,0,0,75,0,0},1) =
large({250,100,75,..},1)
= 250
2 250 4 large({0,200,0,0,220,0,0,130,0},2) =
large({220,200,130,..},2)
= 200
4 220 1 large({0,0,150,0,0,180,0,0,50},2) =
large({180,150,50,..},2)
= 150
1 180 2 large({100,0,0,250,0,0,75,0,0},2) =
large({250,100,75,..},2)
= 100
275 1 large({0,0,150,0,0,180,0,0,50},3) =
large({180,150,50,..},3)
= 50
4 130 4 large({0,200,0,0,220,0,0,130,0},3) =
large({220,200,130,..},3)
= 130
150 1 large({0,0,150,0,0,180,0,0,50},4) =
large({180,150,50,0,..},4) = 0
...
My brain is kind of tired and I'm not sure exactly sure what the
overall
function of your formula is at the moment though :)
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of johann
Sent: Friday, February 24, 2012 12:49 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel
function
what about :
{=LARGE(- -($E$1:$E$122=$G1)*$F$1:$F$122,COUNTIF($G$1:$G1,$G1))}
?
--
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
mailto:excel-macros@googlegroups.com
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
$$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......
Dear Friends have a nice day, I have a small question. For example, I have two cols A and B as shown below one is for date the other have letter Y. A B 28-feb-2012 Y Can I do it like this? If I input letter Y in the column B I can display the current date. Regards, Muneer, CC... -- 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$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......
Please try this =IF(B1=Y,TODAY(),) On Mon, Feb 27, 2012 at 7:55 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: Dear Friends have a nice day, ** ** I have a small question. ** ** For example, I have two cols A and B as shown below one is for date the other have letter “Y”. ** ** A B ** ** 28-feb-2012 Y ** ** Can I do it like this? If I input letter “Y” in the column B I can display the current date. ** ** Regards, Muneer, CC... ** ** -- 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$$ plz, check the attached file for good explanation.....
-- 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 Book1.xls Description: Book1.xls
Re: $$Excel-Macros$$ setfocus on selected sheet
Dear Ashish, Select particular cell and press Alt+V+V and add Sheet name When and where you required to go selected cell press again Alt+VV and select sheet Name You can go on selected cell. Hope this is your requirment. On Tue, Feb 28, 2012 at 10:03 AM, Ashish Bhalara ashishbhalar...@gmail.comwrote: Dear expert, Is it possible that whenever I select the sheet, the cursor set on particular cell e.g.E1? Please suggest me? Thanks regards Ashish Bhalara -- 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://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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
Re: $$Excel-Macros$$ Urgent help needed please
Hi, Try below formula with Ctrl+Shift+Enter. =SUM(IF(A1:A160,A1:A16,0)) Find the attached file. Regards, MARIES. On Mon, Feb 27, 2012 at 4:32 PM, Arpita kapoor kapoor_arp...@yahoo.co.inwrote: = -- 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 SUM.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......
Hi, Try below codes in sheet1. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Cells.Count = 1 Then Dim rng As Range Set rng = Range(Sheet1!A1:A50) For i = 1 To 50 With rng If .Cells(i, 2).Value = Y Then .Cells(i, 1).Value = Date End If End With Next i End If End Sub Regards, MARIES. On Tue, Feb 28, 2012 at 8:08 AM, Seraj Alam seraj.ala...@gmail.com wrote: Please try this =IF(B1=Y,TODAY(),) On Mon, Feb 27, 2012 at 7:55 PM, Mohammed Muneer mmun...@ccc.com.qawrote: Dear Friends have a nice day, ** ** I have a small question. ** ** For example, I have two cols A and B as shown below one is for date the other have letter “Y”. ** ** A B ** ** 28-feb-2012 Y ** ** Can I do it like this? If I input letter “Y” in the column B I can display the current date. ** ** Regards, Muneer, CC... ** ** -- 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 DATE.xlsm Description: Binary data
RE: $$Excel-Macros$$ If I input Letter Y is should show the current date.......(28-Feb-2012) like this......
Hello Mohammed, Not without using VBA. Several people have asked similar questions recently. It is possible to do this using VBA macros, but I would suggest using the CTRL-; keyboard shortcut to enter the current date instead. A simple formula using DATE() will not work because it will be recalculated frequently, and will use the current date each day. For your solution, you could use a Worksheet_Change event like this: Private Sub Worksheet_Change(ByVal Target As Range) Dim rng As Range, cell As Range ' SUPPLY DATE FOR COLUMN A WHEN Y ENTERED IN COLUMN B. ' Identify changed cells in column B. Set rng = Application.Intersect(Me.Range(B:B), Target) ' if cells were identified... If Not rng Is Nothing Then For Each cell In rng If UCase(cell.Value2) = Y Then ' disable events to avoid another worksheet_change event Application.EnableEvents = False cell.Value2 = Empty Application.EnableEvents = True cell.Offset(, -1).Value = Date End If Next cell End If End Sub Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mohammed Muneer Sent: Monday, February 27, 2012 7:55 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ If I input Letter Y is should show the current date...(28-Feb-2012) like this.. Dear Friends have a nice day, I have a small question. For example, I have two cols A and B as shown below one is for date the other have letter Y. A B 28-feb-2012 Y Can I do it like this? If I input letter Y in the column B I can display the current date. Regards, Muneer, CC... -- 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$$ Need to copy one excel sheet to another excel sheet
Hi, *Use Macro Recording option.* With help of recorded macro codes, We will come to know File path, File Name File Version... etc. Then, you share that code to us for modification. I hope this clarify clear. Regards, MARIES. On Mon, Feb 27, 2012 at 12:49 PM, aryan rajesh aryanrajesh...@gmail.comwrote: HI Experts, I have an opened excel sheet from where I need to run a Macro. I need this macro to copy data from another excel (which is closed) to a sheet in the already opened excel. Can some one give me the code for the same? Any help will be greatly appreciated. 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$$ Urgent help needed please
Hi Arpita, You can also use.. SUMPRODUCT((A1:A160)*(A1:A16)) On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor kapoor_arp...@yahoo.co.inwrote: Hi, Can anyone please help me with a simple formula for the below data set. All I need is to a sum of all the figures (+/-) except for those which are =1/-1 0.47 0.40 0.26 1.05 0.21 2.50 0.05 -0.03 -0.07 -0.08 -0.31 -0.48 -0.65 -0.66 -0.80 -11.26 I don't seem to get it, I am sorry if it sounds very trivial, but any help will be appreciated, Thanks alot -- 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://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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
Re: $$Excel-Macros$$ how can i convert nomber to test
Dear Vikram, Please use attached excel sheet for Rupees Format. Use *=SpellCurr(D5) UDF* On Sat, Feb 25, 2012 at 10:53 PM, Vic Kumar vikramahuj...@gmail.com wrote: Hi, Please advice i need this same macro for converting figures in words for Rupees as this macro is working for Dollars only. Kindly help in this regard. Regards, Vikram On 2/23/12, jitendr...@gmail.com jitendr...@gmail.com wrote: Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees Mail sent via way2sms. -- 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 -- Regards, Vikram Ahuja -- 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://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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 Convert Number to Text(Rs).xlsm Description: Binary data
Re: $$Excel-Macros$$ how can i convert nomber to test
Vic Kumar, Please see the attachent On Sat, Feb 25, 2012 at 10:53 PM, Vic Kumar vikramahuj...@gmail.com wrote: Hi, Please advice i need this same macro for converting figures in words for Rupees as this macro is working for Dollars only. Kindly help in this regard. Regards, Vikram On 2/23/12, jitendr...@gmail.com jitendr...@gmail.com wrote: Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees Mail sent via way2sms. -- 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 -- Regards, Vikram Ahuja -- 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 currency to word.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ setfocus on selected sheet
*Try below code:* Private Sub Workbook_SheetActivate(ByVal Sh As Object) ActiveSheet.Range(E1).Select End Sub Regards, MARIES. On Tue, Feb 28, 2012 at 8:49 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Ashish, Select particular cell and press Alt+V+V and add Sheet name When and where you required to go selected cell press again Alt+VV and select sheet Name You can go on selected cell. Hope this is your requirment. On Tue, Feb 28, 2012 at 10:03 AM, Ashish Bhalara ashishbhalar...@gmail.com wrote: Dear expert, Is it possible that whenever I select the sheet, the cursor set on particular cell e.g.E1? Please suggest me? Thanks regards Ashish Bhalara -- 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://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.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 Sheet Change.xlsm Description: Binary data
RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270
Hi Asa, That's a pretty cool explanaion from you. And as you said I am having Macro Editor option in my terminal emulation software. It is in Java script - Reflection for the web. Do you have any idea on that? Thanks for your excellent contribution.:-):-):-) Thanks, Hariharan Tharagan http://knetsites.wipro.com/sites/5446/Pages/FAO-COE.aspx From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Asa Rossoff Sent: Friday, February 24, 2012 12:06 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Hariharan, Is there any special reason to do this from Excel? SendKeys is unreliable, and you have no way to verify the results using built-in VBA functionality. Usually: The best place to script would be on the server using tools installed there. The next best place would be in your terminal emulation software. Some terminal emulators have scripting capability. The next best place might a scripting language with strong general system automation capabilities, such as AutoHotKey http://autohotkey.com/ /AutoHotkey_L http://l.autohotkey.net/ and the related AutoIt http://autoitscript.com/ . If Excel's features are important to your task, you could either control Excel or export data to Excel from your other script, or you could look for a way, as per your request, to perform the automation work from Excel. At your disposal besides the built-in features are external features such as various COM/ActiveX libraries that extend VBAs functionality and the Windows API. With those tools at your disposal, there is practically no limit to what you can do, but it can be time consuming and more complicated. And I don't have a ready solution for you :). A possible approach with those tools at hand would be to have your macro make it's own direct TCP/IP connection to the server and be in complete control of what is sent and received. To your list of questions: Is it possible to interact with Mainframe without connectivity? No, if you don't have a network connection to the mainframe, there is no interaction from your workstation. If you have a script running on the mainframe, though, it can work even when you are not connected, possibly even preparing results if applicable and emailing them to you or placing them for download on that or another server. Will Send Keys work from Excel to Mainframe? Probably, but I don't recommend using Sendkeys outside of Excel, and even then only as a last resort. You cannot guarantee your keystroke will be captured by your terminal emulation client and not Windows or another application. What are the ways to automate my process in mainframe? My most detailed reccomendations at the moment are what I've already stated. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hariharan.thara...@wipro.com Sent: Thursday, February 23, 2012 7:45 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Experts, Could you please help on this? Am I clear in the requirement? Thanks, Hariharan Tharagan From: excel-macros@googlegroups.com [ mailto:excel-macros@googlegroups.com] On Behalf Of hariharan.thara...@wipro.com Sent: Thursday, February 23, 2012 7:00 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel macro for IBM Mainframe 3270 Hi Experts, I am a IBM Mainframe 3270, Reflection User (Terminal Emulation Front End)and I don't have access for Session Manager. I just need a macro to do some process automation. * Is it possible to interact with Mainframe without connectivity? * Will Send Keys work from Excel to Mainframe? * What are the ways to automate my process in mainframe? Thanks in advance. Thanks, Hariharan Tharagan -- 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,
$$Excel-Macros$$ Re: Urgent help needed please
Hello Arpita,
A little confusion in the part =1/-1
If you want to SUM all 0 values, you can use
*
=SUMIF(A1:A16,0,A1:A16)*
If you are looking to SUM between =-1 to 1 (minus 1 to positive 1), use
*
=SUM(SUMIF(A1:A16,{=**-**1,1},A1:A16)*{1,-1})*
HTH
Haseeb
On Monday, February 27, 2012 3:32:19 PM UTC+3, Arpita kapoor wrote:
Hi,
Can anyone please help me with a simple formula for the below data set.
All I need is to a sum of all the figures (+/-) except for those which are
=1/-1
0.47 0.40 0.26 1.05 0.21 2.50 0.05 -0.03 -0.07 -0.08 -0.31
-0.48 -0.65 -0.66 -0.80 -11.26
I don't seem to get it, I am sorry if it sounds very trivial, but any help
will be appreciated,
Thanks alot
--
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$$ how can i convert nomber to test
Hi Dear experts Can somebody help me to convert amount in word instead of dollars rupees I need some other currency like Dirham's, Riyals Pounds etc Kindly help in this regard Gulam Hameed From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of NOORAIN ANSARI Sent: Tuesday, February 28, 2012 8:29 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ how can i convert nomber to test Dear Vikram, Please use attached excel sheet for Rupees Format. Use =SpellCurr(D5) UDF On Sat, Feb 25, 2012 at 10:53 PM, Vic Kumar vikramahuj...@gmail.com wrote: Hi, Please advice i need this same macro for converting figures in words for Rupees as this macro is working for Dollars only. Kindly help in this regard. Regards, Vikram On 2/23/12, jitendr...@gmail.com jitendr...@gmail.com wrote: Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees Mail sent via way2sms. -- 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 -- Regards, Vikram Ahuja -- 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://noorainansari.com/ http://excelmacroworld.blogspot.com/ http://excelmacroworld.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$$ Deba Ranjan wants to chat
--- Deba Ranjan wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-b026c2abc4-b877a6f567-qMCITnhVNZc-CktHu40-cW6TN3U You'll need to click this link to be able to chat with Deba Ranjan. To get Gmail - a free email account from Google with over 2,800 megabytes of storage - and chat with Deba Ranjan, visit: http://mail.google.com/mail/a-b026c2abc4-b877a6f567-qMCITnhVNZc-CktHu40-cW6TN3U Gmail offers: - Instant messaging right inside Gmail - Powerful spam protection - Built-in search for finding your messages and a helpful way of organizing emails into conversations - No pop-up ads or untargeted banners - just text ads and related information that are relevant to the content of your messages All this, and its yours for free. But wait, there's more! By opening a Gmail account, you also get access to Google Talk, Google's instant messaging service: http://www.google.com/talk/ Google Talk offers: - Web-based chat that you can use anywhere, without a download - A contact list that's synchronized with your Gmail account - Free, high quality PC-to-PC voice calls when you download the Google Talk client We're working hard to add new features and make improvements, so we might also ask for your comments and suggestions periodically. We appreciate your help in making our products even better! Thanks, The Google Team To learn more about Gmail and Google Talk, visit: http://mail.google.com/mail/help/about.html http://www.google.com/talk/about.html (If clicking the URLs in this message does not work, copy and paste them into the address bar of your browser). -- 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$$ Re: ifError not woking with excel 2003 version
Hi Chandru, In a cell eg: A1 use this formula to count total count, where E1 contains in Data!E3:E640 =SUMPRODUCT(ISNUMBER(SEARCH(E1,Data!E3:E640))*(E1)) Then in A3 with CTRL+SHIFT+ENTER, rather than just ENTER =IF(ROWS(A$3:A3)=A$1,INDEX(Data!E:E,SMALL(IF(ISNUMBER(SEARCH(E$1,Data!E$3:E$640)),ROW(Data!E$3:E$640)),ROWS(A$3:A3))),) Drag down as necessary. HTH Haseeb -- 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
