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 abhishek@gmail.comwrote: 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 emuralidha...@gmail.comwrote: 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 abhishek@gmail.comwrote: 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 emuralidha...@gmail.comwrote: 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 abhishek@gmail.comwrote: 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 anil.kan...@gmail.com wrote: Hi Please Use alt + ctrl + L then Ctrl D On Tue, Apr 17, 2012 at 3:07 PM, muralidhar e emuralidha...@gmail.comwrote: 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 ahmedhon...@gmail.com 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 emuralidha...@gmail.comwrote: 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 rajanverma1...@gmail.comwrote: 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 ahmedhon...@gmail.com 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 emuralidha...@gmail.com 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 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
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 emuralidha...@gmail.comwrote: 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 rajanverma1...@gmail.comwrote: 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 ahmedhon...@gmail.com 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 emuralidha...@gmail.com 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 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, Rajan, thanks alot. Warm Ragards, Muralidhar E On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma rajanverma1...@gmail.comwrote: 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 emuralidha...@gmail.com 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 rajanverma1...@gmail.com 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 ahmedhon...@gmail.com 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 emuralidha...@gmail.com 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
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 emuralidha...@gmail.comwrote: Hi, Rajan, thanks alot. Warm Ragards, Muralidhar E On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma rajanverma1...@gmail.comwrote: 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 emuralidha...@gmail.com 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 rajanverma1...@gmail.com 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 ahmedhon...@gmail.com 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 emuralidha...@gmail.com 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
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 rajanverma1...@gmail.comwrote: 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 emuralidha...@gmail.com wrote: Hi, Rajan, thanks alot. Warm Ragards, Muralidhar E On Sat, Jun 30, 2012 at 10:09 AM, Rajan_Verma rajanverma1...@gmail.com 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 emuralidha...@gmail.com 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 rajanverma1...@gmail.com 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 ahmedhon...@gmail.com 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 emuralidha...@gmail.com 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
$$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=wallref=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 emuralidha...@gmail.com 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=wallref=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=wallref=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 emuralidha...@gmail.comwrote: 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=wallref=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=wallref=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=wallref=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=wallref=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 emuralidha...@gmail.com 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=wallref=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 emuralidha...@gmail.com 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=wallref=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=wallref=ts Solved key.xlsx 15K View as HTML Open as a Google spreadsheet Download Reply Forward Reply |Rajasekhar Praharaju to excel-macros show details 1:05 PM (3 hours ago) Hi Muralidhar, did u check the attached pivot solution let me know if it is not apt then i will do v-lookup fucntion as u sent. Thanks, Raj - Show quoted text
$$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 noorain.ans...@gmail.comwrote: 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 emuralidha...@gmail.comwrote: 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.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://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 naukrikuld...@gmail.comwrote: 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 emuralidha...@gmail.comwrote: 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 naukrikuld...@gmail.comwrote: 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 emuralidha...@gmail.comwrote: 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.comwrote: 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 emuralidha...@gmail.comwrote: 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
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 dguille...@gmail.com wrote: Provide a file and a complete explanation and examples. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Muralidhar E emuralidha...@gmail.com *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 naukrikuld...@gmail.comwrote: 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 emuralidha...@gmail.comwrote: 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 emuralidha...@gmail.com 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.comexcel-macros%2bunsubscr...@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 mailto:excel-macros%2bunsubscr...@googlegroups.comexcel-macros%2bunsubscr...@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
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 rajanverma1...@gmail.comwrote: * * * * *=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 dguille...@gmail.com wrote:** ** Provide a file and a complete explanation and examples. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Muralidhar E emuralidha...@gmail.com *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 naukrikuld...@gmail.com 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 emuralidha...@gmail.com 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 emuralidha...@gmail.com 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.comexcel-macros%2bunsubscr...@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
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 noorain.ans...@gmail.comwrote: Sure Murlidhar, i will provide you shortly. On Thu, Aug 30, 2012 at 12:44 PM, Muralidhar E emuralidha...@gmail.comwrote: 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 emuralidha...@gmail.comwrote: 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.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://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. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http
$$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 emuralidha...@gmail.com 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 prafulltjad...@gmail.com wrote: Dear Murli, Find the same Regards, Prafull Jadhav. On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E emuralidha...@gmail.comwrote: 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 emuralidha...@gmail.com 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. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel
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 prafulltjad...@gmail.com 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 emuralidha...@gmail.comwrote: 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 prafulltjad...@gmail.com wrote: Dear Murli, Find the same Regards, Prafull Jadhav. On Wed, Jul 10, 2013 at 3:59 PM, Muralidhar E emuralidha...@gmail.comwrote: 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 emuralidha...@gmail.com 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
$$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 vijay.4...@gmail.com 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.comwrote: 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.comwrote: 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.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://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 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
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 emuralidha...@gmail.com 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 vijay.4...@gmail.com 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.comwrote: 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.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://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 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
Re: $$Excel-Macros$$ Query on lookup left side and second, and third values
Thank u On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com 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 emuralidha...@gmail.comwrote: 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 emuralidha...@gmail.com 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 vijay.4...@gmail.com 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.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://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 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
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 emuralidha...@gmail.com wrote: Thank u On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com 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 emuralidha...@gmail.comwrote: 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 emuralidha...@gmail.com 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 vijay.4...@gmail.com 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.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://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 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
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 vijay.4...@gmail.com 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 emuralidha...@gmail.comwrote: Thank u On 16 July 2013 16:34, NOORAIN ANSARI noorain.ans...@gmail.com 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 emuralidha...@gmail.comwrote: 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 emuralidha...@gmail.com 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 vijay.4...@gmail.com 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.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://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 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
$$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.
