Re: $$Excel-Macros$$ Disable Ctrl+D option in excel
Hi Abhishek, Its working fine, but when iam closed the file and reopen it is not working. Thanks in Advance. On Sat, Mar 31, 2012 at 1:29 PM, Abhishek Jain wrote: > Dear Muralidhar, > > To my knowledge, there is not a direct way to disable a shortcut without > using VBA. If you are still interested, read on. > > To disable, we can use this line - Application.OnKey "^d", "" > To enable it again - Application.OnKey "^d" > > Now to make them work them unattended we can use as following - > > Choose to disable it upon opening of the workbook - > > *Private Sub Workbook_Open()* > *Application.OnKey "^d", ""* > *End Sub* > > Choose to re-enable it before close of the workbook so that it doesn't > mess with other files - > > *Private Sub Workbook_BeforeClose(Cancel As Boolean)* > *Application.OnKey "^d"* > *End Sub* > > You can copy-paste both these 02 codes in code area for "ThisWorkbook" > object. > > HTH > > Abhishek > > On Sat, Mar 31, 2012 at 12:03 PM, muralidhar e wrote: > >> >> hi dear group members, >> >> Good afternoon >> >> Iam using excel-2007 & 2010, with a huge data, with this when iam suppose >> to use Ctrl+F for find the batches by overlook when iam pressing ctrl+F iam >> pressing Ctrl+D. In this case the data is changing. >> >> I want to disable the Ctl+D option, it is very better useful it we not >> use Macros. >> >> Thanks in Advance. >> -- >> *Thanks & Regards,* >> ** >> *Muralidhar E.* >> >> -- >> 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,* ** *Muralidhar E.* -- 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$$ Disable Ctrl+D option in excel
Hi, Very sorry repeating the mail, iam unable to find the code to copy at my original file. Message run-time error 1004 Method onkey of object_application failed. Thanks in advance -- *Thanks & Regards,* ** *Muralidhar E.* On Sat, Mar 31, 2012 at 3:20 PM, Abhishek Jain wrote: > There was no code in this one under "ThisWorkbook" object. Please find > attached the updated file which is working fine. > > HTH > > > On Sat, Mar 31, 2012 at 3:09 PM, muralidhar e wrote: > >> >> Hi Abhishek, >> Find the attached file, and the passward for macro is 151176. >> >> Thanks in advance. >> ** >> *Thanks & Regards,* >> ** >> *Muralidhar E.* >> >> On Sat, Mar 31, 2012 at 2:32 PM, Abhishek Jain >> wrote: >> >>> I tested those and working fine even after closing and reopening the >>> workbook. Can you share your sample file which is giving problem? >>> >>> >>> On Sat, Mar 31, 2012 at 2:22 PM, muralidhar e >>> wrote: >>> >>>> Hi Abhishek, >>>> >>>> Its working fine, but when iam closed the file and reopen it is not >>>> working. >>>> >>>> Thanks in Advance. >>>> >>>> >>>> >>>> >>>> >>>> >>>> On Sat, Mar 31, 2012 at 1:29 PM, Abhishek Jain >>>> wrote: >>>> >>>>> Dear Muralidhar, >>>>> >>>>> To my knowledge, there is not a direct way to disable a shortcut >>>>> without using VBA. If you are still interested, read on. >>>>> >>>>> To disable, we can use this line - Application.OnKey "^d", "" >>>>> To enable it again - Application.OnKey "^d" >>>>> >>>>> Now to make them work them unattended we can use as following - >>>>> >>>>> Choose to disable it upon opening of the workbook - >>>>> >>>>> *Private Sub Workbook_Open()* >>>>> *Application.OnKey "^d", ""* >>>>> *End Sub* >>>>> >>>>> Choose to re-enable it before close of the workbook so that it doesn't >>>>> mess with other files - >>>>> >>>>> *Private Sub Workbook_BeforeClose(Cancel As Boolean)* >>>>> *Application.OnKey "^d"* >>>>> *End Sub* >>>>> >>>>> You can copy-paste both these 02 codes in code area for "ThisWorkbook" >>>>> object. >>>>> >>>>> HTH >>>>> >>>>> Abhishek >>>>> >>>>> On Sat, Mar 31, 2012 at 12:03 PM, muralidhar e < >>>>> emuralidha...@gmail.com> wrote: >>>>> >>>>>> >>>>>> hi dear group members, >>>>>> >>>>>> Good afternoon >>>>>> >>>>>> Iam using excel-2007 & 2010, with a huge data, with this when iam >>>>>> suppose to use Ctrl+F for find the batches by overlook when iam pressing >>>>>> ctrl+F iam pressing Ctrl+D. In this case the data is changing. >>>>>> >>>>>> I want to disable the Ctl+D option, it is very better useful it we >>>>>> not use Macros. >>>>>> >>>>>> Thanks in Advance. >>>>>> -- >>>>>> *Thanks & Regards,* >>>>>> ** >>>>>> *Muralidhar E.* >>>>>> >>>>>> -- >>>>>> 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$$ Disable Ctrl+D
hi, anil Iam not understand, if u not feel can u explain it. *Iam what i need is simply is.* iam need not want Ctrl+D option and it disable in my worksheet. if i suppose to use the Ctrl+D option i need a passward when i am using the Ctrl+D. Thanks Muralidhar E On Tue, Apr 17, 2012 at 3:11 PM, anil panchal wrote: > Hi > > Please Use alt + ctrl + L then Ctrl D > > On Tue, Apr 17, 2012 at 3:07 PM, muralidhar e wrote: > >> >> hi dear group members, >> >> Good afternoon >> >> Iam using excel-2007 & 2010, with a huge data, with this when iam suppose >> to use Ctrl+F for find the batches by overlook when iam pressing ctrl+F iam >> pressing Ctrl+D. In this case the data is changing. >> >> I want to disable the Ctl+D option, and if i want to suppose to use the >> Crl+D option i need a passward. >> >> Thanks in Advance. >> -- >> *Thanks & Regards,* >> ** >> *Muralidhar E.* >> >> -- >> 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 > Anil Kumar > > -- > 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,* ** *Muralidhar E.* -- 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$$ Enable & Disable Ctrl+D with passward
Hi, But it will not come to the notice at the same time, it was accidently going on, iam not observing it later it was effecting to the data. On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest wrote: > Dear, > > I think using Ctrl + Z will allow you to take back the action you > performed i.e Undo the last action ;-). This should help. If not, check > other experts advice. > > Thanks, > > > > > On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E wrote: > >> >> Dear all, >> >> Iam using Office 2007, when iam need to use Crl+F accidently iam hitting >> Ctrl+D, iam loosing some data and iam unable to find the changes happening >> to the data file. >> Iam want to disable Ctrl+D option with a passward and the same enable >> with passward, it should for that worksheet only. >> >> Thanks in advance. >> -- >> *Thanks & Regards,* >> ** >> *Muralidhar E.* >> >> -- >> -- >> 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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> > > > > -- > Ahmed Bawazir > *احمد باوزير* > > -- *Thanks & Regards,* ** *Muralidhar E.* -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Hi group, Because of CTRl+D just fill down the data iam facing this problem, when i want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not observing it later it was effecting to the data. So i what i need is i want to *disable Ctrl+D with a passward* and same time i want to *enable with a passward*. I think it will usefull for others also. Thanks in Advance. On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma wrote: > Do you have any add-in or macro in personal.xlsb which have any macro > assigned Ctrl+D?? > > Because excel default Ctrl+D just fill down the data. > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 27 June 2012 3:18 > *To:* excel-macros@googlegroups.com > *Cc:* ahmedhon...@gmail.com > > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > ** ** > > > Hi, > > > > But it will not come to the notice at the same time, it was accidently > going on, iam not observing it later it was effecting to the data. > > > > > On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest > wrote: > > Dear, > > > > I think using Ctrl + Z will allow you to take back the action you > performed i.e Undo the last action ;-). This should help. If not, check > other experts advice. > > > > Thanks, > > > > > > > > On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E > wrote: > > > Dear all, > > > > Iam using Office 2007, when iam need to use Crl+F accidently iam hitting > Ctrl+D, iam loosing some data and iam unable to find the changes happening > to the data file. > > Iam want to disable Ctrl+D option with a passward and the same enable with > passward, it should for that worksheet only. > > > > Thanks in advance. > -- > > *Thanks & Regards,* > > > > *Muralidhar E.* > > ** ** > > -- > -- > 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@googlegroups.com > > > > > > > > -- > > Ahmed Bawazir > > *احمد باوزير* > > ** ** > > > > > -- > > *Thanks & Regards,* > > > > *Muralidhar E.* > > ** ** > > -- > -- > 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 > > To unsubscribe, send a blank email to > excel-macros+unsubscr...@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 answer
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Hi gm experts, is anybody solve my problem reg. disable ctrl+d option. Iam waiting for solution for the problem. On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E wrote: > Hi group, > > Because of CTRl+D just fill down the data iam facing this problem, when i > want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not > observing it later it was effecting to the data. > So i what i need is i want to *disable Ctrl+D with a passward* and > same time i want to *enable with a passward*. > > I think it will usefull for others also. > > Thanks in Advance. > > > > On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma wrote: > >> Do you have any add-in or macro in personal.xlsb which have any macro >> assigned Ctrl+D?? >> >> Because excel default Ctrl+D just fill down the data. >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E >> *Sent:* 27 June 2012 3:18 >> *To:* excel-macros@googlegroups.com >> *Cc:* ahmedhon...@gmail.com >> >> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward >> >> ** ** >> >> >> Hi, >> >> >> >> But it will not come to the notice at the same time, it was accidently >> going on, iam not observing it later it was effecting to the data. >> >> >> >> >> On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest >> wrote: >> >> Dear,**** >> >> >> >> I think using Ctrl + Z will allow you to take back the action you >> performed i.e Undo the last action ;-). This should help. If not, check >> other experts advice. >> >> >> >> Thanks, >> >> >> >> >> >> >> >> On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E >> wrote: >> >> >> Dear all, >> >> >> >> Iam using Office 2007, when iam need to use Crl+F accidently iam hitting >> Ctrl+D, iam loosing some data and iam unable to find the changes happening >> to the data file. >> >> Iam want to disable Ctrl+D option with a passward and the same enable >> with passward, it should for that worksheet only. >> >> >> >> Thanks in advance. >> -- >> >> *Thanks & Regards,* >> >> >> >> *Muralidhar E.* >> >> ** ** >> >> -- >> -- >> 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 >> >> To unsubscribe, send a blank email to >> excel-macros+unsubscr...@googlegroups.com >> >> >> >> >> >> >> >> -- >> >> Ahmed Bawazir >> >> *احمد باوزير* >> >> ** ** >> >> >> >> >> -- >> >> *Thanks & Regards,* >> >> >> >> *Muralidhar E.* >> >> ** ** >> >> -- >> -- >> 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.
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
Hi, Rajan, thanks alot. Warm Ragards, Muralidhar E On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma wrote: > HI > > ** ** > > HTH > > ** ** > > Sub DisableCtrlD() > > > > Dim blnflag As Boolean > > Dim strPwd As String > > > > strPwd = Application.InputBox("Enter the Password ", "Password") > > blnflag = Application.InputBox("To Enable Key Press 1 and To disable > press 0 ", "Password") > > > > If strPwd = "GiveYourPwd" Then > > If blnflag Then > > Application.OnKey "^d", "" > > Else > > Application.OnKey "^d", "Test" > > End If > > End If > > End Sub > > ** ** > > Sub Test() > > MsgBox "Disabled" > > End Sub > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 29 June 2012 10:08 > *To:* excel-macros@googlegroups.com > > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > ** ** > > Hi gm experts, > > > > is anybody solve my problem reg. disable ctrl+d option. > > Iam waiting for solution for the problem. > > > > > > On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E > wrote: > > Hi group, > > > > Because of CTRl+D just fill down the data iam facing this problem, when i > want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not > observing it later it was effecting to the data. > > So i what i need is i want to *disable Ctrl+D with a passward* and > same time i want to *enable with a passward*. > > > > I think it will usefull for others also. > > > > Thanks in Advance. > > > > > > On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma > wrote: > > Do you have any add-in or macro in personal.xlsb which have any macro > assigned Ctrl+D?? > > Because excel default Ctrl+D just fill down the data. > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 27 June 2012 3:18 > *To:* excel-macros@googlegroups.com > *Cc:* ahmedhon...@gmail.com > > > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > > > > Hi, > > **** > > But it will not come to the notice at the same time, it was accidently > going on, iam not observing it later it was effecting to the data. > > > > > On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest > wrote: > > Dear, > > > > I think using Ctrl + Z will allow you to take back the action you > performed i.e Undo the last action ;-). This should help. If not, check > other experts advice. > > > > Thanks, > > > > > > > > On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E > wrote: > > > Dear all, > > > > Iam using Office 2007, when iam need to use Crl+F accidently iam hitting > Ctrl+D, iam loosing some data and iam unable to find the changes happening > to the data file. > > Iam want to disable Ctrl+D option with a passward and the same enable with > passward, it should for that worksheet only. > > > > Thanks in advance. > -- > > *Thanks & Regards,* > > > > *Muralidhar E.* > > > > -- > -- > 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$$ Enable & Disable Ctrl+D with passward
Hi, Can u guide the procedure how to run this code in my file. I am fail to run the code. Warm Regards, Muralidhar E. On Sat, Jun 30, 2012 at 10:25 AM, Muralidhar E wrote: > > Hi, > > Rajan, > > thanks alot. > Warm Ragards, > > Muralidhar E > On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma > wrote: > >> HI >> >> ** ** >> >> HTH >> >> ** ** >> >> Sub DisableCtrlD() >> >> >> >> Dim blnflag As Boolean >> >> Dim strPwd As String >> >> >> >> strPwd = Application.InputBox("Enter the Password ", "Password") >> >> blnflag = Application.InputBox("To Enable Key Press 1 and To disable >> press 0 ", "Password") >> >> >> >> If strPwd = "GiveYourPwd" Then >> >> If blnflag Then >> >> Application.OnKey "^d", "" >> >> Else >> >> Application.OnKey "^d", "Test" >> >> End If >> >> End If >> >> End Sub >> >> ** ** >> >> Sub Test() >> >> MsgBox "Disabled" >> >> End Sub >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> ** ** >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E >> *Sent:* 29 June 2012 10:08 >> *To:* excel-macros@googlegroups.com >> >> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward >> >> ** ** >> >> Hi gm experts, >> >> >> >> is anybody solve my problem reg. disable ctrl+d option. >> >> Iam waiting for solution for the problem. >> >> >> >> >> >> On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E >> wrote: >> >> Hi group, >> >> >> >> Because of CTRl+D just fill down the data iam facing this problem, when i >> want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not >> observing it later it was effecting to the data. >> >> So i what i need is i want to *disable Ctrl+D with a passward* and >> same time i want to *enable with a passward*. >> >> >> >> I think it will usefull for others also. >> >> >> >> Thanks in Advance. >> >> >> >> >> >> On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma >> wrote: >> >> Do you have any add-in or macro in personal.xlsb which have any macro >> assigned Ctrl+D?? >> >> Because excel default Ctrl+D just fill down the data. >> >> * * >> >> *Regards* >> >> *Rajan verma* >> >> *+91 7838100659 [IM-Gtalk]* >> >> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E >> *Sent:* 27 June 2012 3:18 >> *To:* excel-macros@googlegroups.com >> *Cc:* ahmedhon...@gmail.com >> >> >> *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward >> >> >> >> >> Hi, >> >> >> >> But it will not come to the notice at the same time, it was accidently >> going on, iam not observing it later it was effecting to the data. >> >> >> >> >> On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest >> wrote: >> >> Dear, >> >> >> >> I think using Ctrl + Z will allow you to take back the action you >> performed i.e Undo the last action ;-). This should help. If not, check >> other experts advice. >> >> >> >> Thanks, >> >> >> >> >> >> >> >> On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E >> wrote: >> >> >> Dear all, >> >> >> >> Iam using Office 2007, when iam need to use Crl+F accidently iam hitting >> Ctrl+D, iam loosing some data and iam unable to find the changes happening >> to the data file. >> >> Iam want to disable Ctrl+D option with a passward and the same enable >> with passward, it should for that worksheet onl
Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward
hi, If strPwd = "GiveYourPwd" Then i change here as 143 macros is running but for enabling ctrl+d it is not working. On Sat, Jun 30, 2012 at 10:51 AM, Rajan_Verma wrote: > HI > > ** ** > > First you need to give your password in code (Replace “GiveYourPwd” with > your password”) , Press ALT +F 11 then Insert a Module , paste the code > there, come to the worksheet and > > Just Press Alt+F8 and select DisableCtrlD , > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 30 June 2012 10:48 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > ** ** > > Hi, > > > > Can u guide the procedure how to run this code in my file. > > I am fail to run the code. > > Warm Regards, > > > > Muralidhar E. > > On Sat, Jun 30, 2012 at 10:25 AM, Muralidhar E > wrote: > > > Hi, > > > > Rajan, > > > > thanks alot. > > Warm Ragards, > > > > Muralidhar E > > On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma > wrote: > > HI > > > > HTH > > > > Sub DisableCtrlD() > > > > Dim blnflag As Boolean > > Dim strPwd As String > > > > strPwd = Application.InputBox("Enter the Password ", "Password") > > blnflag = Application.InputBox("To Enable Key Press 1 and To disable > press 0 ", "Password") > > > > If strPwd = "GiveYourPwd" Then > > If blnflag Then > > Application.OnKey "^d", "" > > Else**** > > Application.OnKey "^d", "Test" > > End If > > End If > > End Sub > > > > Sub Test() > > MsgBox "Disabled" > > End Sub > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]***** > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 29 June 2012 10:08 > *To:* excel-macros@googlegroups.com > > > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > > > Hi gm experts, > > > > is anybody solve my problem reg. disable ctrl+d option. > > Iam waiting for solution for the problem. > > > > > > On Thu, Jun 28, 2012 at 2:34 PM, Muralidhar E > wrote: > > Hi group, > > > > Because of CTRl+D just fill down the data iam facing this problem, when i > want to use Ctrl+F unfortunatley it was accidently clicking Ctrl+D iam not > observing it later it was effecting to the data. > > So i what i need is i want to *disable Ctrl+D with a passward* and > same time i want to *enable with a passward*. > > > > I think it will usefull for others also. > > > > Thanks in Advance. > > > > > > On Wed, Jun 27, 2012 at 6:38 PM, Rajan_Verma > wrote: > > Do you have any add-in or macro in personal.xlsb which have any macro > assigned Ctrl+D?? > > Because excel default Ctrl+D just fill down the data. > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 27 June 2012 3:18 > *To:* excel-macros@googlegroups.com > *Cc:* ahmedhon...@gmail.com > > > *Subject:* Re: $$Excel-Macros$$ Enable & Disable Ctrl+D with passward > > > > > Hi, > > > > But it will not come to the notice at the same time, it was accidently > going on, iam not observing it later it was effecting to the data. > > > > > On Wed, Jun 27, 2012 at 3:09 PM, Ahmed Honest > wrote: > > Dear, > > > > I think using Ctrl + Z will allow you to take back the action you > performed i.e Undo the last action ;-). This should help. If not, check > other experts advice. > > > > Thanks, > > > > > > > > On Wed, Jun 27, 2012 at 12:33 PM, Muralidhar E
$$Excel-Macros$$ total for unique values
hai friends, This is murali when iam entering the Batches or numbers(values) in a column it should be repeat more than one time, i want the sum for entering the values. plz help and give a solution for me. iam using office 2007.iam also attaching a file for easy understand. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,800 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe Unique total.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Vlookup
Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts I want.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fwd: $$Excel-Macros$$ Vlookup
Dear all, This is urgent to me, plz suggest solution as early as possible. Warm Regards, Muralidhar E. -- Forwarded message -- From: muralidhar e Date: Thu, Nov 11, 2010 at 11:02 AM Subject: $$Excel-Macros$$ Vlookup To: excel-macros@googlegroups.com Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts I want.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Vlookup
hai, sorry like this, it is not useful for me(for my internal office work). for my work i want like this only, Is their any possibility like this plz find the solution, and one more thing is that the batches are like this are nearly 2,so their is no possiblity to use the pivot table, i check like this also. Plz give the solution what i have asked format. it will usefull me. Thanks and Regards, Muralidhar E. On Thu, Nov 11, 2010 at 12:47 PM, Rajasekhar Praharaju < rajasekhar.prahar...@gmail.com> wrote: > Hello Muralidhar, > > Instead of Vlookup you can use Pivot table it depicts good results. > > Please find Attached is the solved sheet.. > > Let me know if you are looking for the same or anything else. > > Thanks, > Raj > > On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e wrote: > >> Dear all group members, >> >> I want to get the L T no, by using vlookup formula, by repeated batches. >> file was attached plz suggest me how to do this by using lookup formula for >> repeated.Iam using MS-Office 2007. >> >> Warm Regards, >> >> Muralidhar E. >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
$$Excel-Macros$$ LOOK
Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts I want.xlsx 11K View as HTML Open as a Google spreadsheet Download Reply Forward muralidhar eDear all, This is urgent to me, plz suggest solution as early as possible. Wa... 12:49 PM (4 hours ago) muralidhar eLoading...12:49 PM (4 hours ago) Reply |muralidhar e to excel-macros show details 12:49 PM (4 hours ago) Dear all, This is urgent to me, plz suggest solution as early as possible. Warm Regards, Muralidhar E. - Show quoted text - -- Forwarded message -- From: muralidhar e Date: Thu, Nov 11, 2010 at 11:02 AM Subject: $$Excel-Macros$$ Vlookup To: excel-macros@googlegroups.com Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts I want.xlsx 11K View as HTML Open as a Google spreadsheet Download Reply Forward Rajasekhar PraharajuHello Muralidhar, Instead of Vlookup you can use Pivot table it depicts good ... 12:47 PM (4 hours ago) Rajasekhar PraharajuLoading...12:47 PM (4 hours ago) Reply |Rajasekhar Praharaju to excel-macros show details 12:47 PM (4 hours ago) Hello Muralidhar, Instead of Vlookup you can use Pivot table it depicts good results. Please find Attached is the solved sheet.. Let me know if you are looking for the same or anything else. Thanks, Raj - Show quoted text - On Thu, Nov 11, 2010 at 11:02 AM, muralidhar e wrote: Dear all group members, I want to get the L T no, by using vlookup formula, by repeated batches. file was attached plz suggest me how to do this by using lookup formula for repeated.Iam using MS-Office 2007. Warm Regards, Muralidhar E. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to e
$$Excel-Macros$$ Entered data should be locked
Dear Friends, If any one can helped can be appreciated i have data like frequently repeated data so i would like to lock the entered data and it should not be modified i.e. my file should allow empty cells should be entered, if any correction or modification needed that should ask the password.If the help is without macro is better to me. -- *Thanks & Regards,* ** *Muralidhar E.* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel lock entered data.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fwd: $$Excel-Macros$$ Entered data should be locked
Hello friend, Thank you but i need without macros is it possible to do this it is more helpful to me. Regards, Muralidhar E. -- Forwarded message -- From: Daniel Date: Sun, Jul 31, 2011 at 8:44 PM Subject: RE: $$Excel-Macros$$ Entered data should be locked To: excel-macros@googlegroups.com Hello, ** ** I protected the sheet (password : excel). In the sheet module I put the macro : ** ** Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range ActiveSheet.Unprotect "excel" For Each c In Target If c <> "" Then c.Locked = True Next c ActiveSheet.Protect "excel" End Sub ** ** Have a look at the attached workbook. ** ** Regards. ** ** Daniel ** ** *De :* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *De la part de* muralidhar e *Envoyé :* dimanche 31 juillet 2011 14:25 *À :* excel-macros@googlegroups.com *Objet :* $$Excel-Macros$$ Entered data should be locked ** ** Dear Friends, ** ** If any one can helped can be appreciated i have data like frequently repeated data so i would like to lock the entered data and it should not be modified i.e. my file should allow empty cells should be entered, if any correction or modification needed that should ask the password.If the help is without macro is better to me. -- **** *Thanks & Regards,* *Muralidhar E.* ** ** -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Thanks & Regards,* ** *Muralidhar E.* -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel lock entered data.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Learn Array formula's
hi to all group members, I want to learn can anyone send me the array formula's guide for beginners with examples. Thanks in advance. -- *Thanks & Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Learn Array formula's
Hi, Thanks alot. If u give any files with examples in excel or in ppt. it will help me to learn very easily. Thanks in advance. Thanks Muralidhar E On Wed, Aug 29, 2012 at 8:25 PM, NOORAIN ANSARI wrote: > Dear Murlidhar, > > Some best sites for Array Function > > http://www.cpearson.com/excel/ArrayFormulas.aspx > http://www.ozgrid.com/Excel/arrays.htm > > > On Wed, Aug 29, 2012 at 3:38 PM, Muralidhar E wrote: > >> hi to all group members, >> >> I want to learn can anyone send me the array formula's guide for >> beginners with examples. >> >> Thanks in advance. >> -- >> *Thanks & Regards,* >> ** >> *Muralidhar E.* >> Think different >> Do Different >> Make different >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. >> >> >> > > > > -- > With Regards, > Noorain Ansari > http:// > <http://www.noorainansari.com/>noorainansari.com<http://www.noorainansari.com/> > http:// > <http://www.excelvbaclinic.blogspot.com/>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com/><http://accesssqclinic.blogspot.in/> > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- *Thanks & Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
$$Excel-Macros$$ Count when po is greater than zero
Dear all, Good morning to every body Iam using Office 2010, I need in result column(F) how many times the vendor name(column B) is repeat, it is countable when the po(column D) is greater than zero, if po is blank or zero it will not be counted(calculated). Plz, find the attached file. Thanks in advance. -- *Thanks & Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. murali.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Count when po is greater than zero
Hi, thanks, But the result is coming wrong, for blank "p o" vendor name is taking in calculation. On Mon, Sep 3, 2012 at 11:52 AM, Kuldeep Singh wrote: > > Hi Muralidhar, > > Try this. > > =IF(D2>=E2,COUNTIF($B$2:$B$10,B2),IF(COUNT($E$2:$E$10),"","0")) > > Regards, > Kuldeep Singh > > > On Mon, Sep 3, 2012 at 11:15 AM, Muralidhar E wrote: > >> >> Dear all, >> >> Good morning to every body >> >> Iam using Office 2010, I need in result column(F) how many times the >> vendor name(column B) is repeat, it is countable when the po(column D) is >> greater than zero, if po is blank or zero it will not be >> counted(calculated). Plz, find the attached file. >> >> Thanks in advance. >> -- >> *Thanks & Regards,* >> ** >> *Muralidhar E.* >> Think different >> Do Different >> Make different >> >> -- >> Join official facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES (1120+ members already BANNED for violation) >> >> 1) Use concise, accurate thread titles. Poor thread titles, like Please >> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >> will not get quick attention or may not be answered. >> >> 2) Don't post a question in the thread of another member. >> >> 3) Don't post questions regarding breaking or bypassing any security >> measure. >> >> 4) Acknowledge the responses you receive, good or bad. >> >> 5) Cross-promotion of, or links to, forums competitive to this forum in >> signatures are prohibited. >> >> 6) Jobs posting is not allowed. >> >> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >> >> NOTE : Don't ever post personal or confidential data in a workbook. Forum >> owners and members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To post to this group, send email to excel-macros@googlegroups.com. >> To unsubscribe from this group, send email to >> excel-macros+unsubscr...@googlegroups.com. > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com. > To unsubscribe from this group, send email to > excel-macros+unsubscr...@googlegroups.com. > > > -- *Thanks & Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Count when po is greater than zero
Hi, Thanks for quickly reply, but it is not working, in result columncount of name is not coming, name is appears, Plz, ignore the column E it is remarks for the status of PO under process. Actually i want the vendor name how many times it is repeat when it has PO, if PO is not confirmed it will not to be calculated(not to be counted). Thanks in advance. On Mon, Sep 3, 2012 at 12:55 PM, Kuldeep Singh wrote: > > Hi Murli, > > Try this one. > > > =IFERROR(INDEX($B$2:$B$10,SMALL(IF($D$2:$D$10>=E2,ROW($E$2:$E$10),""),COUNTIF($B$2:B10,B2))-1),"0") > > Ctrl + Shift + Enter > > Regards, > Kuldeep Singh > > > On Mon, Sep 3, 2012 at 12:29 PM, Muralidhar E wrote: > >> Hi, >> >> thanks, But the result is coming wrong, for blank "p o" vendor name is >> taking in calculation. >> >> On Mon, Sep 3, 2012 at 11:52 AM, Kuldeep Singh >> wrote: >> >>> >>> Hi Muralidhar, >>> >>> Try this. >>> >>> =IF(D2>=E2,COUNTIF($B$2:$B$10,B2),IF(COUNT($E$2:$E$10),"","0")) >>> >>> Regards, >>> Kuldeep Singh >>> >>> >>> On Mon, Sep 3, 2012 at 11:15 AM, Muralidhar E >>> wrote: >>> >>>> >>>> Dear all, >>>> >>>> Good morning to every body >>>> >>>> Iam using Office 2010, I need in result column(F) how many times the >>>> vendor name(column B) is repeat, it is countable when the po(column D) is >>>> greater than zero, if po is blank or zero it will not be >>>> counted(calculated). Plz, find the attached file. >>>> >>>> Thanks in advance. >>>> -- >>>> *Thanks & Regards,* >>>> ** >>>> *Muralidhar E.* >>>> Think different >>>> Do Different >>>> Make different >>>> >>>> -- >>>> Join official facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES (1120+ members already BANNED for violation) >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> >>>> 2) Don't post a question in the thread of another member. >>>> >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> >>>> 4) Acknowledge the responses you receive, good or bad. >>>> >>>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> 6) Jobs posting is not allowed. >>>> >>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To post to this group, send email to excel-macros@googlegroups.com. >>>> To unsubscribe from this group, send email to >>>> excel-macros+unsubscr...@googlegroups.com. >>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss.
Re: $$Excel-Macros$$ Count when po is greater than zero
Dear all, Find the attached file, I want i column E if column D is more than zero to be calculated with how many times column B is repeated. Ex. In column B Murali is repeated 3 times but in column D is more than zero is only 2 times, the result is 2. Thanks in advance. On Mon, Sep 3, 2012 at 6:02 PM, dguillett1 wrote: > Provide a file and a complete explanation and examples. > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > *From:* Muralidhar E > *Sent:* Monday, September 03, 2012 3:33 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Count when po is greater than zero > > Hi, > > Thanks for quickly reply, but it is not working, in result columncount of > name is not coming, name is appears, > > Plz, ignore the column E it is remarks for the status of PO under process. > Actually i want the vendor name how many times it is repeat when it has > PO, if PO is not confirmed it will not to be calculated(not to be counted). > > Thanks in advance. > > > On Mon, Sep 3, 2012 at 12:55 PM, Kuldeep Singh > wrote: > >> >> Hi Murli, >> >> Try this one. >> >> >> =IFERROR(INDEX($B$2:$B$10,SMALL(IF($D$2:$D$10>=E2,ROW($E$2:$E$10),""),COUNTIF($B$2:B10,B2))-1),"0") >> >> Ctrl + Shift + Enter >> >> Regards, >> Kuldeep Singh >> >> >> On Mon, Sep 3, 2012 at 12:29 PM, Muralidhar E >> wrote: >> >>> Hi, >>> >>> thanks, But the result is coming wrong, for blank "p o" vendor name is >>> taking in calculation. >>> >>> On Mon, Sep 3, 2012 at 11:52 AM, Kuldeep Singh < >>> naukrikuld...@gmail.com> wrote: >>> >>>> >>>> Hi Muralidhar, >>>> >>>> Try this. >>>> >>>> =IF(D2>=E2,COUNTIF($B$2:$B$10,B2),IF(COUNT($E$2:$E$10),"","0")) >>>> >>>> Regards, >>>> Kuldeep Singh >>>> >>>> >>>> On Mon, Sep 3, 2012 at 11:15 AM, Muralidhar E >>> > wrote: >>>> >>>>> >>>>> Dear all, >>>>> >>>>> Good morning to every body >>>>> >>>>> Iam using Office 2010, I need in result column(F) how many times the >>>>> vendor name(column B) is repeat, it is countable when the po(column D) is >>>>> greater than zero, if po is blank or zero it will not be >>>>> counted(calculated). Plz, find the attached file. >>>>> >>>>> Thanks in advance. >>>>> -- >>>>> *Thanks & Regards,* >>>>> ** >>>>> *Muralidhar E.* >>>>> Think different >>>>> Do Different >>>>> Make different >>>>> >>>>> -- >>>>> Join official facebook page of this forum @ >>>>> https://www.facebook.com/discussexcel >>>>> >>>>> FORUM RULES (1120+ members already BANNED for violation) >>>>> >>>>> 1) Use concise, accurate thread titles. Poor thread titles, like >>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need >>>>> Advice will not get quick attention or may not be answered. >>>>> >>>>> 2) Don't post a question in the thread of another member. >>>>> >>>>> 3) Don't post questions regarding breaking or bypassing any security >>>>> measure. >>>>> >>>>> 4) Acknowledge the responses you receive, good or bad. >>>>> >>>>> 5) Cross-promotion of, or links to, forums competitive to this forum >>>>> in signatures are prohibited. >>>>> >>>>> 6) Jobs posting is not allowed. >>>>> >>>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not >>>>> allowed. >>>>> >>>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>>> Forum owners and members are not responsible for any loss. >>>>> --- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>> To unsubscribe from this group, send email to >>>>> mailto:excel-macros%2bunsubscr...@googlegroups.com >>>>
Re: $$Excel-Macros$$ Count when po is greater than zero
Thanks it was working. On Tue, Sep 4, 2012 at 7:04 PM, Rajan_Verma wrote: > * * > > * * > > *=SUMPRODUCT(N($B$2:$B$10=B2),N($D$2:$D$10<>""))* > > * * > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Muralidhar E > *Sent:* 04 September 2012 11:28 > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Count when po is greater than zero > > ** ** > > > Dear all, > > > > Find the attached file, I want i column E if column D is more than zero to > be calculated with how many times column B is repeated. > > Ex. In column B Murali is repeated 3 times but in column D is more than > zero is only 2 times, the result is 2. > > > > Thanks in advance. > > On Mon, Sep 3, 2012 at 6:02 PM, dguillett1 wrote:** > ** > > Provide a file and a complete explanation and examples. > > > > Don Guillett > Microsoft Excel Developer > SalesAid Software > dguille...@gmail.com > > > > *From:* Muralidhar E > > *Sent:* Monday, September 03, 2012 3:33 AM > > *To:* excel-macros@googlegroups.com > > *Subject:* Re: $$Excel-Macros$$ Count when po is greater than zero > > > > Hi, > > > > Thanks for quickly reply, but it is not working, in result columncount of > name is not coming, name is appears, > > > > Plz, ignore the column E it is remarks for the status of PO under process. > > > Actually i want the vendor name how many times it is repeat when it has > PO, if PO is not confirmed it will not to be calculated(not to be counted). > > > > > Thanks in advance. > > > > > On Mon, Sep 3, 2012 at 12:55 PM, Kuldeep Singh > wrote: > > > > Hi Murli, > > > > Try this one. > > > > > =IFERROR(INDEX($B$2:$B$10,SMALL(IF($D$2:$D$10>=E2,ROW($E$2:$E$10),""),COUNTIF($B$2:B10,B2))-1),"0") > > > > > Ctrl + Shift + Enter > > > > Regards, > > Kuldeep Singh > > ** ** > > On Mon, Sep 3, 2012 at 12:29 PM, Muralidhar E > wrote: > > Hi, > > > > thanks, But the result is coming wrong, for blank "p o" vendor name is > taking in calculation. > > On Mon, Sep 3, 2012 at 11:52 AM, Kuldeep Singh > wrote: > > > > Hi Muralidhar, > > > > Try this. > > > > =IF(D2>=E2,COUNTIF($B$2:$B$10,B2),IF(COUNT($E$2:$E$10),"","0")) > > > > Regards, > > Kuldeep Singh > > > > > > On Mon, Sep 3, 2012 at 11:15 AM, Muralidhar E > wrote: > > > > Dear all, > > Good morning to every body > > > > Iam using Office 2010, I need in result column(F) how many times the > vendor name(column B) is repeat, it is countable when the po(column D) is > greater than zero, if po is blank or zero it will not be > counted(calculated). Plz, find the attached file. > > > Thanks in advance. > -- > > *Thanks & Regards,* > > > > *Muralidhar E.* > > Think different > > Do Different > > Make different > > > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice > will not get quick attention or may not be answered. > > 2) Don't post a question in the thread of another member. > > 3) Don't post questions regarding breaking or bypassing any security > measure. > > 4) Acknowledge the responses you receive, good or bad. > > 5) Cross-promotion of, or links to, forums competitive to this forum in > signatures are prohibited. > > 6) Jobs posting is not allowed. > > 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. > > NOTE : Don't ever post personal or confidential data in a workbook. Forum > owners and members are not responsible for any loss. > --- > You received this message because you are subscribed to the Google Groups > "MS EXCEL AND VBA MACROS" group. > To post to this group, send email to excel-macros@googlegroups.com.
Re: $$Excel-Macros$$ Learn Array formula's
hi, Expecting examples excel file, reg. Array formula functions. On Thu, Aug 30, 2012 at 5:58 PM, NOORAIN ANSARI wrote: > Sure Murlidhar, > > i will provide you shortly. > > > On Thu, Aug 30, 2012 at 12:44 PM, Muralidhar E wrote: > >> Hi, >> Thanks alot. If u give any files with examples in excel or in ppt. it >> will help me to learn very easily. >> >> Thanks in advance. >> >> Thanks >> Muralidhar E >> >> On Wed, Aug 29, 2012 at 8:25 PM, NOORAIN ANSARI < >> noorain.ans...@gmail.com> wrote: >> >>> Dear Murlidhar, >>> >>> Some best sites for Array Function >>> >>> http://www.cpearson.com/excel/ArrayFormulas.aspx >>> http://www.ozgrid.com/Excel/arrays.htm >>> >>> >>> On Wed, Aug 29, 2012 at 3:38 PM, Muralidhar E >>> wrote: >>> >>>> hi to all group members, >>>> >>>> I want to learn can anyone send me the array formula's guide for >>>> beginners with examples. >>>> >>>> Thanks in advance. >>>> -- >>>> *Thanks & Regards,* >>>> ** >>>> *Muralidhar E.* >>>> Think different >>>> Do Different >>>> Make different >>>> >>>> -- >>>> Join official facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES (1120+ members already BANNED for violation) >>>> >>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>>> will not get quick attention or may not be answered. >>>> >>>> 2) Don't post a question in the thread of another member. >>>> >>>> 3) Don't post questions regarding breaking or bypassing any security >>>> measure. >>>> >>>> 4) Acknowledge the responses you receive, good or bad. >>>> >>>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>>> signatures are prohibited. >>>> >>>> 6) Jobs posting is not allowed. >>>> >>>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>>> >>>> NOTE : Don't ever post personal or confidential data in a workbook. >>>> Forum owners and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To post to this group, send email to excel-macros@googlegroups.com. >>>> To unsubscribe from this group, send email to >>>> excel-macros+unsubscr...@googlegroups.com. >>>> >>>> >>>> >>> >>> >>> >>> -- >>> With Regards, >>> Noorain Ansari >>> http:// >>> <http://www.noorainansari.com/>noorainansari.com<http://www.noorainansari.com/> >>> http:// >>> <http://www.excelvbaclinic.blogspot.com/>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com/><http://accesssqclinic.blogspot.in/> >>> >>> >>> -- >>> Join official facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES (1120+ members already BANNED for violation) >>> >>> 1) Use concise, accurate thread titles. Poor thread titles, like Please >>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice >>> will not get quick attention or may not be answered. >>> >>> 2) Don't post a question in the thread of another member. >>> >>> 3) Don't post questions regarding breaking or bypassing any security >>> measure. >>> >>> 4) Acknowledge the responses you receive, good or bad. >>> >>> 5) Cross-promotion of, or links to, forums competitive to this forum in >>> signatures are prohibited. >>> >>> 6) Jobs posting is not allowed. >>> >>> 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. >>> >>> NOTE : Don't ever post personal or confidential data in a workbook. >>> Forum owners and members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>&g
$$Excel-Macros$$ Vlookup function using with match & columns
Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with me. *1.This is using match function* =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match type),*range lookup). *2.This is using columns function* =vlookup(lookup_value, Table array,*columns(array)*,range lookup). I want to know how can we use both these functions. 1. Shall we can get the left side result by using vlookup function? 2. Shall we can get the second value result by using vlookup function? *Note:* It is more helpful with sharing date by examples. Thanks in advance. -- *Thanks & Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Fwd: $$Excel-Macros$$ Vlookup function using with match & columns
Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with me. *1.This is using match function* =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match type),*range lookup). *2.This is using columns or column function* =vlookup(lookup_value, Table array,*columns or column(array)*,range lookup). I want to know how can we use both these functions. 1. Shall we can get the left side result by using vlookup function? 2. Shall we can get the second value result by using vlookup function? *Note:* It is more helpful with sharing date by examples. Thanks in advance. -- Forwarded message -- From: Muralidhar E Date: 10 July 2013 15:30 Subject: $$Excel-Macros$$ Vlookup function using with match & columns To: excel-macros@googlegroups.com Dear friends, Good afternoon, I need a help and I want to know how to use vlookup function by using match and columns function. How it is works? Plz, share with me. *1.This is using match function* =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match type),*range lookup). *2.This is using columns function* =vlookup(lookup_value, Table array,*columns(array)*,range lookup). I want to know how can we use both these functions. 1. Shall we can get the left side result by using vlookup function? 2. Shall we can get the second value result by using vlookup function? *Note:* It is more helpful with sharing date by examples. Thanks in advance. -- *Thanks & Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- *Thanks & Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Vlookup function using with match & columns
Hi, Dear friends, Thank u With the same i want to know using column & columns *2.This is using columns or column function* =vlookup(lookup_value, Table array,*columns or column(array)*,range lookup). I want to know how can we use both these functions. 1. Shall we can get the left side result by using vlookup function? 2. Shall we can get the second value result by using vlookup function? Thanks in advance. On 10 July 2013 16:34, Prafull Jadhav wrote: > > Dear Murli, > > Find the same > > Regards, > Prafull Jadhav. > > > On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E wrote: > >> Dear friends, >> >> Good afternoon, >> >> I need a help and I want to know how to use vlookup function by using >> match and columns function. How it is works? >> Plz, share with me. >> >> *1.This is using match function* >> =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match >> type),*range lookup). >> >> *2.This is using columns or column function* >> =vlookup(lookup_value, Table array,*columns or column(array)*,range >> lookup). >> >> I want to know how can we use both these functions. >> >> 1. Shall we can get the left side result by using vlookup function? >> 2. Shall we can get the second value result by using vlookup function? >> >> *Note:* It is more helpful with sharing date by examples. >> >> Thanks in advance. >> >> >> -- Forwarded message -- >> From: Muralidhar E >> Date: 10 July 2013 15:30 >> Subject: $$Excel-Macros$$ Vlookup function using with match & columns >> To: excel-macros@googlegroups.com >> >> >> >> Dear friends, >> >> Good afternoon, >> >> I need a help and I want to know how to use vlookup function by using >> match and columns function. How it is works? >> Plz, share with me. >> >> *1.This is using match function* >> =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match >> type),*range lookup). >> >> *2.This is using columns function* >> =vlookup(lookup_value, Table array,*columns(array)*,range lookup). >> >> I want to know how can we use both these functions. >> >> 1. Shall we can get the left side result by using vlookup function? >> 2. Shall we can get the second value result by using vlookup function? >> >> *Note:* It is more helpful with sharing date by examples. >> >> Thanks in advance. >> -- >> *Thanks & Regards,* >> ** >> *Muralidhar E.* >> Think different >> Do Different >> Make different >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 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) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> >> >> >> -- >> *Thanks & Regards,* >> ** >> *Muralidhar E.* >> Think different >> Do Different >> Make different >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 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 att
Fwd: $$Excel-Macros$$ Vlookup function using with match & columns
Dear Friends, It is possible to lookup the values for the left side and second value, third value Is their any other ways or functions to get the results.? 1. Shall we can get the left side result by using vlookup function? 2. Shall we can get the second value result by using vlookup function? Thanks in advance. -- Forwarded message -- From: Prafull Jadhav Date: 10 July 2013 16:52 Subject: Re: $$Excel-Macros$$ Vlookup function using with match & columns To: excel-macros@googlegroups.com Dear Murli, You can just give ref of column,,, for example if you want B column then put (B:B). =VLOOKUP($L24,$A$3:$D$6,COLUMN(B:B),0) On Wed, Jul 10, 2013 at 4:43 PM, Muralidhar E wrote: > Hi, > Dear friends, > > Thank u > > With the same i want to know using column & columns > > *2.This is using columns or column function* > =vlookup(lookup_value, Table array,*columns or column(array)*,range > lookup). > > I want to know how can we use both these functions. > > 1. Shall we can get the left side result by using vlookup function? > 2. Shall we can get the second value result by using vlookup function? > > Thanks in advance. > On 10 July 2013 16:34, Prafull Jadhav wrote: > >> >> Dear Murli, >> >> Find the same >> >> Regards, >> Prafull Jadhav. >> >> >> On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E wrote: >> >>> Dear friends, >>> >>> Good afternoon, >>> >>> I need a help and I want to know how to use vlookup function by using >>> match and columns function. How it is works? >>> Plz, share with me. >>> >>> *1.This is using match function* >>> =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match >>> type),*range lookup). >>> >>> *2.This is using columns or column function* >>> =vlookup(lookup_value, Table array,*columns or column(array)*,range >>> lookup). >>> >>> I want to know how can we use both these functions. >>> >>> 1. Shall we can get the left side result by using vlookup function? >>> 2. Shall we can get the second value result by using vlookup function? >>> >>> *Note:* It is more helpful with sharing date by examples. >>> >>> Thanks in advance. >>> >>> >>> -- Forwarded message -- >>> From: Muralidhar E >>> Date: 10 July 2013 15:30 >>> Subject: $$Excel-Macros$$ Vlookup function using with match & columns >>> To: excel-macros@googlegroups.com >>> >>> >>> >>> Dear friends, >>> >>> Good afternoon, >>> >>> I need a help and I want to know how to use vlookup function by using >>> match and columns function. How it is works? >>> Plz, share with me. >>> >>> *1.This is using match function* >>> =vlookup(lookup_value,Table array*,match(lookup_value,lookup_array,match >>> type),*range lookup). >>> >>> *2.This is using columns function* >>> =vlookup(lookup_value, Table array,*columns(array)*,range lookup). >>> >>> I want to know how can we use both these functions. >>> >>> 1. Shall we can get the left side result by using vlookup function? >>> 2. Shall we can get the second value result by using vlookup function? >>> >>> *Note:* It is more helpful with sharing date by examples. >>> >>> Thanks in advance. >>> -- >>> *Thanks & Regards,* >>> ** >>> *Muralidhar E.* >>> Think different >>> Do Different >>> Make different >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 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) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not respon
$$Excel-Macros$$ Query on lookup left side and second, and third values
Dear Friends good afternoon, I need help reg. lookup values 1.It is possible to vlookup the values for the left side 2.Vlookup for the second value(occurence), third value Is their any other ways or functions to get the results.? Thanks in advance. -- *Thanks & Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Query on lookup left side and second, and third values
Hi, ThanksVijay. can u present me with an example,it is better to understand me. Thanks in advance. On 16 July 2013 15:07, P.VIJAYKUMAR wrote: > Respected Muralidhar, > > You can use Index,Match,Indirect functions for accomplishing some look up > tasks which are not possible by VLookup. > > Regards, > VijayKumar > > > On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI > wrote: > >> Dear Murlidhar, >> >> Please visit here.. >> >> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html >> >> >> >> On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E >> wrote: >> >>> >>> Dear Friends good afternoon, >>> >>> I need help reg. lookup values >>> >>> 1.It is possible to vlookup the values for the left side >>> 2.Vlookup for the second value(occurence), third value >>> Is their any other ways or functions to get the results.? >>> >>> Thanks in advance. >>> >>> -- >>> *Thanks & Regards,* >>> ** >>> *Muralidhar E.* >>> Think different >>> Do Different >>> Make different >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 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) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss. >>> --- >>> You received this message because you are subscribed to the Google >>> Groups "MS EXCEL AND VBA MACROS" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to excel-macros+unsubscr...@googlegroups.com. >>> To post to this group, send email to excel-macros@googlegroups.com. >>> Visit this group at http://groups.google.com/group/excel-macros. >>> For more options, visit https://groups.google.com/groups/opt_out. >>> >>> >>> >> >> >> >> -- >> With Regards, >> Noorain Ansari >> http:// >> <http://www.noorainansari.com/>noorainansari.com<http://www.noorainansari.com/> >> http:// >> <http://www.excelvbaclinic.blogspot.com/>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com/><http://accesssqclinic.blogspot.in/> >> >> -- >> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s >> =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >> https://www.facebook.com/discussexcel >> >> FORUM RULES >> >> 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) Jobs posting is not allowed. >> 6) Sharing copyrighted material and their links is not allowed. >> >> NOTE : Don't ever post confidential data in a workbook. Forum owners and >> members are not responsible for any loss. >> --- >> You received this message because you are subscribed to the Google Groups >> "MS EXCEL AND VBA MACROS" group. >> To unsubscribe from this group and stop receiving emails from it, send an >> email to excel-macros+unsubscr...@googlegroups.com. >> To post to this group, send email to excel-macros@googlegroups.com. >> Visit this group at http://groups.google.com/group/excel-macros. >> For more options, visit https://groups.google.com/groups/opt_out. >> >> >> > > > > -- > > > > > > > > > > P.VIJAY KUMAR > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do yo
Re: $$Excel-Macros$$ Query on lookup left side and second, and third values
Thanks mr, Ansari, I cant understand the 9E+307 in the below formula =LOOKUP(9E+307,1/(C3:C9=E9),B3:B9) plz, help me on this with an example,it is help me more. Thanks in advance Warm Regards, Muralidhar On 16 July 2013 15:37, Muralidhar E wrote: > Hi, > > ThanksVijay. can u present me with an example,it is better to understand > me. > > Thanks in advance. > > On 16 July 2013 15:07, P.VIJAYKUMAR wrote: > >> Respected Muralidhar, >> >> You can use Index,Match,Indirect functions for accomplishing some look up >> tasks which are not possible by VLookup. >> >> Regards, >> VijayKumar >> >> >> On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI > > wrote: >> >>> Dear Murlidhar, >>> >>> Please visit here.. >>> >>> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html >>> >>> >>> >>> On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E >>> wrote: >>> >>>> >>>> Dear Friends good afternoon, >>>> >>>> I need help reg. lookup values >>>> >>>> 1.It is possible to vlookup the values for the left side >>>> 2.Vlookup for the second value(occurence), third value >>>> Is their any other ways or functions to get the results.? >>>> >>>> Thanks in advance. >>>> >>>> -- >>>> *Thanks & Regards,* >>>> ** >>>> *Muralidhar E.* >>>> Think different >>>> Do Different >>>> Make different >>>> >>>> -- >>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>> https://www.facebook.com/discussexcel >>>> >>>> FORUM RULES >>>> >>>> 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) Jobs posting is not allowed. >>>> 6) Sharing copyrighted material and their links is not allowed. >>>> >>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>> and members are not responsible for any loss. >>>> --- >>>> You received this message because you are subscribed to the Google >>>> Groups "MS EXCEL AND VBA MACROS" group. >>>> To unsubscribe from this group and stop receiving emails from it, send >>>> an email to excel-macros+unsubscr...@googlegroups.com. >>>> To post to this group, send email to excel-macros@googlegroups.com. >>>> Visit this group at http://groups.google.com/group/excel-macros. >>>> For more options, visit https://groups.google.com/groups/opt_out. >>>> >>>> >>>> >>> >>> >>> >>> -- >>> With Regards, >>> Noorain Ansari >>> http:// >>> <http://www.noorainansari.com/>noorainansari.com<http://www.noorainansari.com/> >>> http:// >>> <http://www.excelvbaclinic.blogspot.com/>excelvbaclinic.com<http://www.excelvbaclinic.blogspot.com/><http://accesssqclinic.blogspot.in/> >>> >>> -- >>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>> https://www.facebook.com/discussexcel >>> >>> FORUM RULES >>> >>> 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) Jobs posting is not allowed. >>> 6) Sharing copyrighted material and their links is not allowed. >>> >>> NOTE : Don't ever post confidential data in a workbook. Forum owners and >>> members are not responsible for any loss
Re: $$Excel-Macros$$ Query on lookup left side and second, and third values
Thank u On 16 July 2013 16:34, NOORAIN ANSARI wrote: > Dear Muralidhar. > > it's the largest number that Excel can store. This "Big number" is used to > look up the last number in a range. > > > On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E wrote: > >> >> Thanks mr, Ansari, >> >> I cant understand the 9E+307 in the below formula >> >> =LOOKUP(9E+307,1/(C3:C9=E9),B3:B9) >> >> plz, help me on this with an example,it is help me more. >> >> Thanks in advance >> >> Warm Regards, >> >> Muralidhar >> >> On 16 July 2013 15:37, Muralidhar E wrote: >> >>> Hi, >>> >>> ThanksVijay. can u present me with an example,it is better to understand >>> me. >>> >>> Thanks in advance. >>> >>> On 16 July 2013 15:07, P.VIJAYKUMAR wrote: >>> >>>> Respected Muralidhar, >>>> >>>> You can use Index,Match,Indirect functions for accomplishing some look >>>> up tasks which are not possible by VLookup. >>>> >>>> Regards, >>>> VijayKumar >>>> >>>> >>>> On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI < >>>> noorain.ans...@gmail.com> wrote: >>>> >>>>> Dear Murlidhar, >>>>> >>>>> Please visit here.. >>>>> >>>>> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html >>>>> >>>>> >>>>> >>>>> On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E < >>>>> emuralidha...@gmail.com> wrote: >>>>> >>>>>> >>>>>> Dear Friends good afternoon, >>>>>> >>>>>> I need help reg. lookup values >>>>>> >>>>>> 1.It is possible to vlookup the values for the left side >>>>>> 2.Vlookup for the second value(occurence), third value >>>>>> Is their any other ways or functions to get the results.? >>>>>> >>>>>> Thanks in advance. >>>>>> >>>>>> -- >>>>>> *Thanks & Regards,* >>>>>> ** >>>>>> *Muralidhar E.* >>>>>> Think different >>>>>> Do Different >>>>>> Make different >>>>>> >>>>>> -- >>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>> https://www.facebook.com/discussexcel >>>>>> >>>>>> FORUM RULES >>>>>> >>>>>> 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) Jobs posting is not allowed. >>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>> >>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>>> and members are not responsible for any loss. >>>>>> --- >>>>>> You received this message because you are subscribed to the Google >>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>> send an email to excel-macros+unsubscr...@googlegroups.com. >>>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>>> Visit this group at http://groups.google.com/group/excel-macros. >>>>>> For more options, visit https://groups.google.com/groups/opt_out. >>>>>> >>>>>> >>>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> With Regards, >>>>> Noorain Ansari >>>>> http:// >>>>> <http://www.noorainansari.com/>noorainansari.com<h
Re: $$Excel-Macros$$ Query on lookup left side and second, and third values
Dear Vijay Kumar. Thank u On 16 July 2013 16:40, Muralidhar E wrote: > Thank u > > > > On 16 July 2013 16:34, NOORAIN ANSARI wrote: > >> Dear Muralidhar. >> >> it's the largest number that Excel can store. This "Big number" is used >> to look up the last number in a range. >> >> >> On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E wrote: >> >>> >>> Thanks mr, Ansari, >>> >>> I cant understand the 9E+307 in the below formula >>> >>> =LOOKUP(9E+307,1/(C3:C9=E9),B3:B9) >>> >>> plz, help me on this with an example,it is help me more. >>> >>> Thanks in advance >>> >>> Warm Regards, >>> >>> Muralidhar >>> >>> On 16 July 2013 15:37, Muralidhar E wrote: >>> >>>> Hi, >>>> >>>> ThanksVijay. can u present me with an example,it is better to >>>> understand me. >>>> >>>> Thanks in advance. >>>> >>>> On 16 July 2013 15:07, P.VIJAYKUMAR wrote: >>>> >>>>> Respected Muralidhar, >>>>> >>>>> You can use Index,Match,Indirect functions for accomplishing some look >>>>> up tasks which are not possible by VLookup. >>>>> >>>>> Regards, >>>>> VijayKumar >>>>> >>>>> >>>>> On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI < >>>>> noorain.ans...@gmail.com> wrote: >>>>> >>>>>> Dear Murlidhar, >>>>>> >>>>>> Please visit here.. >>>>>> >>>>>> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html >>>>>> >>>>>> >>>>>> >>>>>> On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E < >>>>>> emuralidha...@gmail.com> wrote: >>>>>> >>>>>>> >>>>>>> Dear Friends good afternoon, >>>>>>> >>>>>>> I need help reg. lookup values >>>>>>> >>>>>>> 1.It is possible to vlookup the values for the left side >>>>>>> 2.Vlookup for the second value(occurence), third value >>>>>>> Is their any other ways or functions to get the results.? >>>>>>> >>>>>>> Thanks in advance. >>>>>>> >>>>>>> -- >>>>>>> *Thanks & Regards,* >>>>>>> ** >>>>>>> *Muralidhar E.* >>>>>>> Think different >>>>>>> Do Different >>>>>>> Make different >>>>>>> >>>>>>> -- >>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? >>>>>>> It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ >>>>>>> https://www.facebook.com/discussexcel >>>>>>> >>>>>>> FORUM RULES >>>>>>> >>>>>>> 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) Jobs posting is not allowed. >>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>> >>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners >>>>>>> and members are not responsible for any loss. >>>>>>> --- >>>>>>> You received this message because you are subscribed to the Google >>>>>>> Groups "MS EXCEL AND VBA MACROS" group. >>>>>>> To unsubscribe from this group and stop receiving emails from it, >>>>>>> send an email to excel-macros+unsubscr...@googlegroups.com. >>>>>>> To post to this group, send email to excel-macros@googlegroups.com. >>>>>>> Visit this group at http://groups.google.com/group/exce
Re: $$Excel-Macros$$ Query on lookup left side and second, and third values
Repected Vijay Kumar and Noorain Ansari. Both of u and the team Thank u very much. On 16 July 2013 16:46, P.VIJAYKUMAR wrote: > Respected Muralidhar, > > See the following link and attached File. > http://chandoo.org/wp/2010/11/02/multi-condition-lookup/ > > Regards, > Vijaykumar > > > On Tue, Jul 16, 2013 at 4:40 PM, Muralidhar E wrote: > >> Thank u >> >> >> >> On 16 July 2013 16:34, NOORAIN ANSARI wrote: >> >>> Dear Muralidhar. >>> >>> it's the largest number that Excel can store. This "Big number" is used >>> to look up the last number in a range. >>> >>> >>> On Tue, Jul 16, 2013 at 4:09 PM, Muralidhar E >>> wrote: >>> >>>> >>>> Thanks mr, Ansari, >>>> >>>> I cant understand the 9E+307 in the below formula >>>> >>>> =LOOKUP(9E+307,1/(C3:C9=E9),B3:B9) >>>> >>>> plz, help me on this with an example,it is help me more. >>>> >>>> Thanks in advance >>>> >>>> Warm Regards, >>>> >>>> Muralidhar >>>> >>>> On 16 July 2013 15:37, Muralidhar E wrote: >>>> >>>>> Hi, >>>>> >>>>> ThanksVijay. can u present me with an example,it is better to >>>>> understand me. >>>>> >>>>> Thanks in advance. >>>>> >>>>> On 16 July 2013 15:07, P.VIJAYKUMAR wrote: >>>>> >>>>>> Respected Muralidhar, >>>>>> >>>>>> You can use Index,Match,Indirect functions for accomplishing some >>>>>> look up tasks which are not possible by VLookup. >>>>>> >>>>>> Regards, >>>>>> VijayKumar >>>>>> >>>>>> >>>>>> On Tue, Jul 16, 2013 at 3:02 PM, NOORAIN ANSARI < >>>>>> noorain.ans...@gmail.com> wrote: >>>>>> >>>>>>> Dear Murlidhar, >>>>>>> >>>>>>> Please visit here.. >>>>>>> >>>>>>> http://www.excelvbaclinic.com/2011/08/reverse-vlookup-example.html >>>>>>> >>>>>>> >>>>>>> >>>>>>> On Tue, Jul 16, 2013 at 2:15 PM, Muralidhar E < >>>>>>> emuralidha...@gmail.com> wrote: >>>>>>> >>>>>>>> >>>>>>>> Dear Friends good afternoon, >>>>>>>> >>>>>>>> I need help reg. lookup values >>>>>>>> >>>>>>>> 1.It is possible to vlookup the values for the left side >>>>>>>> 2.Vlookup for the second value(occurence), third value >>>>>>>> Is their any other ways or functions to get the results.? >>>>>>>> >>>>>>>> Thanks in advance. >>>>>>>> >>>>>>>> -- >>>>>>>> *Thanks & Regards,* >>>>>>>> ** >>>>>>>> *Muralidhar E.* >>>>>>>> Think different >>>>>>>> Do Different >>>>>>>> Make different >>>>>>>> >>>>>>>> -- >>>>>>>> Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna >>>>>>>> be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this >>>>>>>> forum @ >>>>>>>> https://www.facebook.com/discussexcel >>>>>>>> >>>>>>>> FORUM RULES >>>>>>>> >>>>>>>> 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) Jobs posting is not allowed. >>>>>>>> 6) Sharing copyrighted material and their links is not allowed. >>>>>>>> &g
$$Excel-Macros$$ Matching values
Dear Friends & experts, Good morning If any one can helped can be appreciated,iam using excel-2010, my problem is i want to get the result for third match(occurence) value, but iam failed to do so.Information reg. data is explained the file. Thanks in advance. *Thanks & Regards,* ** *Muralidhar E.* Think different Do Different Make different -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. Matching.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Power BI
Hi friends, I want to learn Power BI(Power Pivots, Power query and power maps) in briefly with examples, and training material also, with tips and tricks. Any useful links, PPT's and PDF etc Thanks in advance -- *Thanks & Regards,* *Muralidhar E.* Think different Do Different Make different -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.