$$Excel-Macros$$ Look formula required
Hi Experts please check the attached table , there i have to select a value from one table to another based on the criteria given. pls help me Regards Rajesh -- 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/d/optout. PT.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Look formula required
Hi You can use simple vlookup formula, but you need to reverse the table, check attachment formula is in col G. Cheers!! On Fri, Mar 27, 2015 at 11:41 AM, Rajesh thrissur rajeshkainikk...@gmail.com wrote: Hi Experts please check the attached table , there i have to select a value from one table to another based on the criteria given. pls help me Regards Rajesh -- 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/d/optout. -- 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/d/optout. PT.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Look for date/time stamp when any cells in a particular row are modified.
Hi Bill, As per me if you want record time/date change if cell value change then time should be changed only if new value old value is not same. PFA. Macro cheks for change in cell value in range A1 to J1, existing val is capture in cell L1, if new val is not matching to existing val then only time change is captured using worksheet change event worksheet selection change event. Cheers!! On Sun, Jul 6, 2014 at 11:23 PM, Bill Q ronsmith...@gmail.com wrote: Hi, Example: - The date/time stamp would be in cell K1. - If any cell between A1 and J1 are modified, K1 would automatically reflect the new date and time. Thanks. -- 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/d/optout. -- 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/d/optout. record time if cell value changes.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Look for date/time stamp when any cells in a particular row are modified.
check this.. On Mon, Jul 7, 2014 at 1:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi Bill, As per me if you want record time/date change if cell value change then time should be changed only if new value old value is not same. PFA. Macro cheks for change in cell value in range A1 to J1, existing val is capture in cell L1, if new val is not matching to existing val then only time change is captured using worksheet change event worksheet selection change event. Cheers!! On Sun, Jul 6, 2014 at 11:23 PM, Bill Q ronsmith...@gmail.com wrote: Hi, Example: - The date/time stamp would be in cell K1. - If any cell between A1 and J1 are modified, K1 would automatically reflect the new date and time. Thanks. -- 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/d/optout. -- 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/d/optout. record time if cell value changes.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Look for date/time stamp when any cells in a particular row are modified.
Hi, Example: - The date/time stamp would be in cell K1. - If any cell between A1 and J1 are modified, K1 would automatically reflect the new date and time. Thanks. -- 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/d/optout.
Re: $$Excel-Macros$$ Look for date/time stamp when any cells in a particular row are modified.
explain with sample files pl On Sun, Jul 6, 2014 at 11:23 PM, Bill Q ronsmith...@gmail.com wrote: Hi, Example: - The date/time stamp would be in cell K1. - If any cell between A1 and J1 are modified, K1 would automatically reflect the new date and time. Thanks. -- 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/d/optout. -- *PramodSingh* -- 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/d/optout.
RE: $$Excel-Macros$$ Look up Names from Contacts Sheet Display Name in an other sheet named call history.
PFA OR =IFERROR(VLOOKUP(A2,CHOOSE({1,2},Contacts!$B$2:$B$13,Contacts!$A$2:$A$13),2, 0),UNKNOWN NUMBER) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of M.Rafique MRU Sent: Sunday, October 27, 2013 9:57 PM To: excel-macros Subject: $$Excel-Macros$$ Look up Names from Contacts Sheet Display Name in an other sheet named call history. Dear Friends, I have attached Workbook here with the name of call history. Which has two sheets Contacts and Call History, Now I want to Look up Names from Contacts Sheet Display Name in an other sheet named call history. Your help in this regard will be highly appreciated. Thanks in Advance Muhammad Rafique Ujjan -- 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? 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. Call History VLOOKUP WITH CHOOSE.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Look up Names from Contacts Sheet Display Name in an other sheet named call history.
Thanks Ravinder this formula works for me. Thanks and regards, Rupesh On Mon, Oct 28, 2013 at 12:20 PM, Ravinder ravinderexcelgr...@gmail.comwrote: PFA OR ** ** =IFERROR(VLOOKUP(A2,CHOOSE({1,2},Contacts!$B$2:$B$13,Contacts!$A$2:$A$13),2,0),UNKNOWN NUMBER) ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *M.Rafique MRU *Sent:* Sunday, October 27, 2013 9:57 PM *To:* excel-macros *Subject:* $$Excel-Macros$$ Look up Names from Contacts Sheet Display Name in an other sheet named call history. ** ** Dear Friends, I have attached Workbook here with the name of call history. Which has two sheets Contacts and Call History, Now I want to Look up Names from Contacts Sheet Display Name in an other sheet named call history. Your help in this regard will be highly appreciated. Thanks in Advance Muhammad Rafique Ujjan -- 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? 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 and Regards, Rp. -- 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.
$$Excel-Macros$$ Look up Names from Contacts Sheet Display Name in an other sheet named call history.
Dear Friends, I have attached Workbook here with the name of call history. Which has two sheets Contacts and Call History, Now I want to Look up Names from Contacts Sheet Display Name in an other sheet named call history. Your help in this regard will be highly appreciated. Thanks in Advance Muhammad Rafique Ujjan -- 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. Call History.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
RE: $$Excel-Macros$$ Look up Names from Contacts Sheet Display Name in an other sheet named call history.
plz find attached . Date: Sun, 27 Oct 2013 21:27:29 +0500 Subject: $$Excel-Macros$$ Look up Names from Contacts Sheet Display Name in an other sheet named call history. From: imrafiqu...@gmail.com To: excel-macros@googlegroups.com Dear Friends, I have attached Workbook here with the name of call history. Which has two sheets Contacts and Call History, Now I want to Look up Names from Contacts Sheet Display Name in an other sheet named call history. Your help in this regard will be highly appreciated. Thanks in Advance Muhammad Rafique Ujjan -- 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? 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. Call History.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Look up Names from Contacts Sheet Display Name in an other sheet named call history.
hi. Plz find solution using vlookup with choose. regards, Ashwani On Mon, Oct 28, 2013 at 1:36 AM, Kashan Abbas kashanabbas...@hotmail.comwrote: plz find attached . -- Date: Sun, 27 Oct 2013 21:27:29 +0500 Subject: $$Excel-Macros$$ Look up Names from Contacts Sheet Display Name in an other sheet named call history. From: imrafiqu...@gmail.com To: excel-macros@googlegroups.com Dear Friends, I have attached Workbook here with the name of call history. Which has two sheets Contacts and Call History, Now I want to Look up Names from Contacts Sheet Display Name in an other sheet named call history. Your help in this regard will be highly appreciated. Thanks in Advance Muhammad Rafique Ujjan -- 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? 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? 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. Call History.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Look up value from Column and rows
Dear XLS Can you give me this amazing formula in Excel 2003.I use Excel 2003 Regards Amar On Thu, May 30, 2013 at 2:10 PM, Chaya chayamon...@gmail.com wrote: Thanks priti for your formula, it will be a new learning era for me with varities of formula knowledge. Regards, Chaya The excel learner :-) On Thu, May 30, 2013 at 2:05 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear XLS, It is very useful formula and nice formula I was trying the same with sumproduct ...but it not happen... first time i have seen sumifs formula with index and match formula. Regards, Prafull Jadhav MIS executive. On Thu, May 30, 2013 at 1:57 PM, Chaya chayamon...@gmail.com wrote: Thank you so much Dear Xls. I was amazed you have used sum function, Actually i thought of sum function is used in only in numerical values calculation. today i came to know it is used in many calculation. thank you for that. Thanks to all. Regards, Chaya The excel learner :-) On Thu, May 30, 2013 at 1:32 PM, xlstime xlst...@gmail.com wrote: use sumifs with index and match combination..please find attached solution . Enjoy Team XLS On Thu, May 30, 2013 at 1:03 PM, Chaya chayamon...@gmail.com wrote: Dear Experts, I was trying to find the values from Rows and coumns which match the criteria from the data validation like wise in the attached file. please suggest me the formulas, which formula might get used for finding the answer. hope that i could able to elabroate by query correctly, please find the attachment. Thank you so much in advance. Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. ---
Re: $$Excel-Macros$$ Look up value from Column and rows
Dear xlstime In file formula show #NUM! error.Pls see it. On Fri, May 31, 2013 at 6:44 PM, xlstime xlst...@gmail.com wrote: Hi Amar, PFA or excel 2003 . Enjoy Team XLS On Fri, May 31, 2013 at 4:32 PM, amar takale amartak...@gmail.com wrote: Dear XLS Can you give me this amazing formula in Excel 2003.I use Excel 2003 Regards Amar On Thu, May 30, 2013 at 2:10 PM, Chaya chayamon...@gmail.com wrote: Thanks priti for your formula, it will be a new learning era for me with varities of formula knowledge. Regards, Chaya The excel learner :-) On Thu, May 30, 2013 at 2:05 PM, Prafull Jadhav prafulltjad...@gmail.com wrote: Dear XLS, It is very useful formula and nice formula I was trying the same with sumproduct ...but it not happen... first time i have seen sumifs formula with index and match formula. Regards, Prafull Jadhav MIS executive. On Thu, May 30, 2013 at 1:57 PM, Chaya chayamon...@gmail.com wrote: Thank you so much Dear Xls. I was amazed you have used sum function, Actually i thought of sum function is used in only in numerical values calculation. today i came to know it is used in many calculation. thank you for that. Thanks to all. Regards, Chaya The excel learner :-) On Thu, May 30, 2013 at 1:32 PM, xlstime xlst...@gmail.com wrote: use sumifs with index and match combination..please find attached solution . Enjoy Team XLS On Thu, May 30, 2013 at 1:03 PM, Chaya chayamon...@gmail.com wrote: Dear Experts, I was trying to find the values from Rows and coumns which match the criteria from the data validation like wise in the attached file. please suggest me the formulas, which formula might get used for finding the answer. hope that i could able to elabroate by query correctly, please find the attachment. Thank you so much in advance. Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en . For more options, visit https://groups.google.com/groups/opt_out. -- 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
$$Excel-Macros$$ Look up value from Column and rows
Dear Experts, I was trying to find the values from Rows and coumns which match the criteria from the data validation like wise in the attached file. please suggest me the formulas, which formula might get used for finding the answer. hope that i could able to elabroate by query correctly, please find the attachment. Thank you so much in advance. Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Lookup Value.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Look up value from Column and rows
use sumifs with index and match combination..please find attached solution . Enjoy Team XLS On Thu, May 30, 2013 at 1:03 PM, Chaya chayamon...@gmail.com wrote: Dear Experts, I was trying to find the values from Rows and coumns which match the criteria from the data validation like wise in the attached file. please suggest me the formulas, which formula might get used for finding the answer. hope that i could able to elabroate by query correctly, please find the attachment. Thank you so much in advance. Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Lookup Value.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Look up value from Column and rows
Thank you so much Dear Xls. I was amazed you have used sum function, Actually i thought of sum function is used in only in numerical values calculation. today i came to know it is used in many calculation. thank you for that. Thanks to all. Regards, Chaya The excel learner :-) On Thu, May 30, 2013 at 1:32 PM, xlstime xlst...@gmail.com wrote: use sumifs with index and match combination..please find attached solution . Enjoy Team XLS On Thu, May 30, 2013 at 1:03 PM, Chaya chayamon...@gmail.com wrote: Dear Experts, I was trying to find the values from Rows and coumns which match the criteria from the data validation like wise in the attached file. please suggest me the formulas, which formula might get used for finding the answer. hope that i could able to elabroate by query correctly, please find the attachment. Thank you so much in advance. Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ Look up value from Column and rows
try this =SUMPRODUCT(N($A$2:$A$83=$T$8)*N($B$2:$B$83=$U$8)*N($C$2:$C$83=$X9)*N($D$2:$D$83=Y$8)*INDEX($A$2:$P$83,,MATCH($V$8,$A$1:$P$1,0))) On Thu, May 30, 2013 at 1:57 PM, Chaya chayamon...@gmail.com wrote: Thank you so much Dear Xls. I was amazed you have used sum function, Actually i thought of sum function is used in only in numerical values calculation. today i came to know it is used in many calculation. thank you for that. Thanks to all. Regards, Chaya The excel learner :-) On Thu, May 30, 2013 at 1:32 PM, xlstime xlst...@gmail.com wrote: use sumifs with index and match combination..please find attached solution . Enjoy Team XLS On Thu, May 30, 2013 at 1:03 PM, Chaya chayamon...@gmail.com wrote: Dear Experts, I was trying to find the values from Rows and coumns which match the criteria from the data validation like wise in the attached file. please suggest me the formulas, which formula might get used for finding the answer. hope that i could able to elabroate by query correctly, please find the attachment. Thank you so much in advance. Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in
Re: $$Excel-Macros$$ Look up value from Column and rows
Dear XLS, It is very useful formula and nice formula I was trying the same with sumproduct ...but it not happen... first time i have seen sumifs formula with index and match formula. Regards, Prafull Jadhav MIS executive. On Thu, May 30, 2013 at 1:57 PM, Chaya chayamon...@gmail.com wrote: Thank you so much Dear Xls. I was amazed you have used sum function, Actually i thought of sum function is used in only in numerical values calculation. today i came to know it is used in many calculation. thank you for that. Thanks to all. Regards, Chaya The excel learner :-) On Thu, May 30, 2013 at 1:32 PM, xlstime xlst...@gmail.com wrote: use sumifs with index and match combination..please find attached solution . Enjoy Team XLS On Thu, May 30, 2013 at 1:03 PM, Chaya chayamon...@gmail.com wrote: Dear Experts, I was trying to find the values from Rows and coumns which match the criteria from the data validation like wise in the attached file. please suggest me the formulas, which formula might get used for finding the answer. hope that i could able to elabroate by query correctly, please find the attachment. Thank you so much in advance. Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit
Re: $$Excel-Macros$$ Look up value from Column and rows
Thanks priti for your formula, it will be a new learning era for me with varities of formula knowledge. Regards, Chaya The excel learner :-) On Thu, May 30, 2013 at 2:05 PM, Prafull Jadhav prafulltjad...@gmail.comwrote: Dear XLS, It is very useful formula and nice formula I was trying the same with sumproduct ...but it not happen... first time i have seen sumifs formula with index and match formula. Regards, Prafull Jadhav MIS executive. On Thu, May 30, 2013 at 1:57 PM, Chaya chayamon...@gmail.com wrote: Thank you so much Dear Xls. I was amazed you have used sum function, Actually i thought of sum function is used in only in numerical values calculation. today i came to know it is used in many calculation. thank you for that. Thanks to all. Regards, Chaya The excel learner :-) On Thu, May 30, 2013 at 1:32 PM, xlstime xlst...@gmail.com wrote: use sumifs with index and match combination..please find attached solution . Enjoy Team XLS On Thu, May 30, 2013 at 1:03 PM, Chaya chayamon...@gmail.com wrote: Dear Experts, I was trying to find the values from Rows and coumns which match the criteria from the data validation like wise in the attached file. please suggest me the formulas, which formula might get used for finding the answer. hope that i could able to elabroate by query correctly, please find the attachment. Thank you so much in advance. Regards, Chaya -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- 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
Re: $$Excel-Macros$$ Look up errors from 2 sheets.
Thanks Every greato great gurus. Thanks Regards, *Deba Ranjan P* On Thu, Jul 12, 2012 at 9:36 AM, Seraj Alam seraj.ala...@gmail.com wrote: Hi, Please see attached solution of your query and let me knowis it full fill your requirement or not??? On Tue, Jul 10, 2012 at 2:50 AM, Deba Ranjan drdeva...@gmail.com wrote: That is what the problem, i have like wise thousand datas which manually not possible to enter one by one, i want to look up by some eventual formulas. Thanks Regards, *Deba Ranjan P* On Tue, Jul 10, 2012 at 3:17 PM, Norman Cliff May nor...@gmail.comwrote: The lookup names have to be entered the same on both sheets, some need a space and some don't have a space. Look more closely at the ones that yield #N/A. On Tue, Jul 10, 2012 at 5:23 AM, Deba Ranjan drdeva...@gmail.comwrote: Hi Experts, i am getting error in vlookups in finding the names from 2 sheets. i have used index, match formula, but still have some errors. Please look into this, might have lack of formulas in this. Please suggest what need to use in such cases. Thanks Regards, *Deba Ranjan P* -- 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...@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...@googlegroups.com -- Thanks Regards Seraj Alam *+91 989 130 1776* -- 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
Re: $$Excel-Macros$$ Look up errors from 2 sheets.
The lookup names have to be entered the same on both sheets, some need a space and some don't have a space. Look more closely at the ones that yield #N/A. On Tue, Jul 10, 2012 at 5:23 AM, Deba Ranjan drdeva...@gmail.com wrote: Hi Experts, i am getting error in vlookups in finding the names from 2 sheets. i have used index, match formula, but still have some errors. Please look into this, might have lack of formulas in this. Please suggest what need to use in such cases. Thanks Regards, *Deba Ranjan P* -- 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...@googlegroups.com
Re: $$Excel-Macros$$ Look up errors from 2 sheets.
That is what the problem, i have like wise thousand datas which manually not possible to enter one by one, i want to look up by some eventual formulas. Thanks Regards, *Deba Ranjan P* On Tue, Jul 10, 2012 at 3:17 PM, Norman Cliff May nor...@gmail.com wrote: The lookup names have to be entered the same on both sheets, some need a space and some don't have a space. Look more closely at the ones that yield #N/A. On Tue, Jul 10, 2012 at 5:23 AM, Deba Ranjan drdeva...@gmail.com wrote: Hi Experts, i am getting error in vlookups in finding the names from 2 sheets. i have used index, match formula, but still have some errors. Please look into this, might have lack of formulas in this. Please suggest what need to use in such cases. Thanks Regards, *Deba Ranjan P* -- 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...@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...@googlegroups.com
$$Excel-Macros$$ Look up and Auto Update ?
Hello I need a bit of a help with the attached excel file. (Formula would be best as I want to avoid the use of Macros / VBA) The attached excel file has two sheets: Cheque Entries Sheet: I shall be inserting data in Columns E, F, G, H and I on a regular basis. (Entries shall also be made in Columns A to D, however, I do not think they are relevant to my query). Bank Details Sheet: In this sheet, there are two main headers, [JKSB Bank Balances Log] and [SVC Bank Balances Log]; Here I want the columns from E to I in Sheet 'Cheque Entries' to be automatically updated in the proper section in Sheet Bank Details as per the name of the bank. That is, if the name of the bank mentioned in Column H in Cheque Entries Sheet is JKSB, I would like to automatically add columns E to I in Cheque Entries Sheet under the JKSB Bank Log section in Columns D to H BELOW the last entry. A row would most probably have to be added. Similarly, If the name of the bank mentioned in Column H in Cheque Entries Sheet is SVC, I would like to automatically add columns E to I in Cheque Entries Sheet under the SBC Bank Log section in Columns D to H BELOW the last entry. A row would most probably have to be added. I hope I have managed to express my query. Additional Information : Version of Excel used = 2003 (SP3) Any help in this would be highly appreciated. File Attached: Test.xls Thanks in advance Ashish -- 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 Test.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Look up and Auto Update ?
Hello Maries Thanks for the express fast reply :-) This works beautifully for me and exactly as I had hoped for. Thanks a lot. Appreciate it. Thanks Ashish Pradhan On 03-04-2012 02:11, Maries wrote: Hi, PFA. Regards, MARIES. On Mon, Apr 2, 2012 at 9:27 PM, Ashish Pradhan ashlyprad...@gmail.com mailto:ashlyprad...@gmail.com wrote: Hello I need a bit of a help with the attached excel file. (Formula would be best as I want to avoid the use of Macros / VBA) The attached excel file has two sheets: Cheque Entries Sheet: I shall be inserting data in Columns E, F, G, H and I on a regular basis. (Entries shall also be made in Columns A to D, however, I do not think they are relevant to my query). Bank Details Sheet: In this sheet, there are two main headers, [JKSB Bank Balances Log] and [SVC Bank Balances Log]; Here I want the columns from E to I in Sheet 'Cheque Entries' to be automatically updated in the proper section in Sheet Bank Details as per the name of the bank. That is, if the name of the bank mentioned in Column H in Cheque Entries Sheet is JKSB, I would like to automatically add columns E to I in Cheque Entries Sheet under the JKSB Bank Log section in Columns D to H BELOW the last entry. A row would most probably have to be added. Similarly, If the name of the bank mentioned in Column H in Cheque Entries Sheet is SVC, I would like to automatically add columns E to I in Cheque Entries Sheet under the SBC Bank Log section in Columns D to H BELOW the last entry. A row would most probably have to be added. I hope I have managed to express my query. Additional Information : Version of Excel used = 2003 (SP3) Any help in this would be highly appreciated. File Attached: Test.xls Thanks in advance Ashish -- 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 mailto:excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Look up values
Excel Experts, I need your help. I have a spreadsheet where I have unique ID, Log Types, and a Key Value. The Key Value represents a Boolean code (1,0) that suggests the Log Type equals the data I want to analyze. I want to take the most recent date for each unique lead ID where the key value = 1. If you copy and past the data into a spreadsheet, it should deliminate correctly. In this example, I have 4 unique lead ID's but many rows of data. Lead 994469 should have a date of 11/19/2011, Lead 994500 should have 11/16/2011, Lead 994610 should have 11/18/2011 and Lead 994626 should have 11/14/2011. Any help would be greatly appreciated Id Log TypeLog DateKey Value 994626 Left VM 11/22/2011 0 994626 TP - College Transcript Request Form (CCC) 11/21/2011 0 994626 TP - HS Transcript Request Form (CCC) 11/21/2011 0 994626 TP - FERPA (CCC)11/21/2011 0 994626 TP - GHE Permission Form (CCC) 11/21/2011 0 994626 TP - Application (CCC) 11/21/2011 0 994626 CCC Application Email Sent 11/19/2011 0 994626 Interview Complete 11/19/2011 1 994610 Left VM 11/21/2011 0 994610 SS - AC/TP Comments 11/18/2011 0 994610 SA Comments 11/18/2011 0 994610 FA Comments 11/17/2011 0 994610 TP - College Transcript Request Form (CCC) 11/17/2011 0 994610 TP - HS Transcript Request Form (CCC) 11/17/2011 0 994610 TP - FERPA (CCC)11/17/2011 0 994610 TP - GHE Permission Form (CCC) 11/17/2011 0 994610 TP - Application (CCC) 11/17/2011 0 994610 CCC Application Email Sent 11/16/2011 0 994610 Interview Complete 11/16/2011 1 994500 FA Comments 11/22/2011 0 994500 FA Comments 11/21/2011 0 994500 Spoke to Prospect 11/18/2011 1 994500 FA - FAFSA (CCC)11/14/2011 0 994500 FA - Estimate Signed (CCC) 11/14/2011 0 994500 Spoke to Prospect 11/14/2011 1 994500 SA Comments 11/14/2011 0 994500 TP - College Transcript Request Form (CCC) 11/14/2011 0 994500 TP - College Transcript Request Form (CCC) 11/14/2011 0 994500 SS - AC/TP Comments 11/14/2011 0 994500 TP - College Transcript Request Form (CCC) 11/14/2011 0 994500 TP - HS Transcript Request Form (CCC) 11/14/2011 0 994500 TP - FERPA (CCC)11/14/2011 0 994500 TP - GHE Permission Form (CCC) 11/14/2011 0 994500 TP - Application (CCC) 11/14/2011 0 994500 FA Comments 11/14/2011 0 994500 FA Comments 11/14/2011 0 994500 SA Comments 11/14/2011 0 994500 CCC Application Email Sent 11/14/2011 0 994500 Interview Complete 11/14/2011 1 994500 Spoke to Prospect 11/14/2011 1 994500 Left VM 11/11/2011 0 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions 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$$ Look up values
I don't think your sample matches what you said. Array formula that must be entered using ctrl+shift+enter =MAX(IF(($A$2:$A$5000=A10)*($D$2:$D$5000=1),$C$2:$C$5000)) Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: RockyFontane Sent: Tuesday, November 22, 2011 1:55 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Look up values Excel Experts, I need your help. I have a spreadsheet where I have unique ID, Log Types, and a Key Value. The Key Value represents a Boolean code (1,0) that suggests the Log Type equals the data I want to analyze. I want to take the most recent date for each unique lead ID where the key value = 1. If you copy and past the data into a spreadsheet, it should deliminate correctly. In this example, I have 4 unique lead ID's but many rows of data. Lead 994469 should have a date of 11/19/2011, Lead 994500 should have 11/16/2011, Lead 994610 should have 11/18/2011 and Lead 994626 should have 11/14/2011. Any help would be greatly appreciated Id Log Type Log Date Key Value 994626 Left VM 11/22/2011 0 994626 TP - College Transcript Request Form (CCC) 11/21/2011 0 994626 TP - HS Transcript Request Form (CCC) 11/21/2011 0 994626 TP - FERPA (CCC) 11/21/2011 0 994626 TP - GHE Permission Form (CCC) 11/21/2011 0 994626 TP - Application (CCC) 11/21/2011 0 994626 CCC Application Email Sent 11/19/2011 0 994626 Interview Complete 11/19/2011 1 994610 Left VM 11/21/2011 0 994610 SS - AC/TP Comments 11/18/2011 0 994610 SA Comments 11/18/2011 0 994610 FA Comments 11/17/2011 0 994610 TP - College Transcript Request Form (CCC) 11/17/2011 0 994610 TP - HS Transcript Request Form (CCC) 11/17/2011 0 994610 TP - FERPA (CCC) 11/17/2011 0 994610 TP - GHE Permission Form (CCC) 11/17/2011 0 994610 TP - Application (CCC) 11/17/2011 0 994610 CCC Application Email Sent 11/16/2011 0 994610 Interview Complete 11/16/2011 1 994500 FA Comments 11/22/2011 0 994500 FA Comments 11/21/2011 0 994500 Spoke to Prospect 11/18/2011 1 994500 FA - FAFSA (CCC) 11/14/2011 0 994500 FA - Estimate Signed (CCC) 11/14/2011 0 994500 Spoke to Prospect 11/14/2011 1 994500 SA Comments 11/14/2011 0 994500 TP - College Transcript Request Form (CCC) 11/14/2011 0 994500 TP - College Transcript Request Form (CCC) 11/14/2011 0 994500 SS - AC/TP Comments 11/14/2011 0 994500 TP - College Transcript Request Form (CCC) 11/14/2011 0 994500 TP - HS Transcript Request Form (CCC) 11/14/2011 0 994500 TP - FERPA (CCC) 11/14/2011 0 994500 TP - GHE Permission Form (CCC) 11/14/2011 0 994500 TP - Application (CCC) 11/14/2011 0 994500 FA Comments 11/14/2011 0 994500 FA Comments 11/14/2011 0 994500 SA Comments 11/14/2011 0 994500 CCC Application Email Sent 11/14/2011 0 994500 Interview Complete 11/14/2011 1 994500 Spoke to Prospect 11/14/2011 1 994500 Left VM 11/11/2011 0 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions 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 (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions 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$$ Look formula to select ledger group
Dear Rajesh, Apart from VLookup you can also use simple.. *=LOOKUP(2,1/($A$2:$A$8=A11),$B$2:$B$8)* *=INDEX($B$2:$B$8,MATCH($A11,$A$2:$A$8,0))* *=OFFSET($B$1,MATCH($A11,$A$2:$A$8,0),0) See attached sheet..* * * On Tue, Sep 13, 2011 at 12:21 AM, Rajesh K R rajeshkainikk...@gmail.comwrote: Hi Experts, Is there any formula we can use to select matched texts just like sumif formula(in case of numbers).Kindly find the attached file it ellaborate well about the issue.And tell me how to solve it. Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Ledger Grouping(Solved).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Look formula to select ledger group
Hi Experts, Is there any formula we can use to select matched texts just like sumif formula(in case of numbers).Kindly find the attached file it ellaborate well about the issue.And tell me how to solve it. Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Ledger Grouping.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Look formula to select ledger group
It appears that a simple vlookup should do it. =IF(ISNA(VLOOKUP(A11,$A$1:$B$8,2,0)),,(VLOOKUP(A11,$A$1:$B$8,2,0))) -Original Message- From: Rajesh K R Sent: Monday, September 12, 2011 1:51 PM To: excel-macros Subject: $$Excel-Macros$$ Look formula to select ledger group Hi Experts, Is there any formula we can use to select matched texts just like sumif formula(in case of numbers).Kindly find the attached file it ellaborate well about the issue.And tell me how to solve it. Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Look formula to select ledger group
Hi, Thanks for getting a very quick reply, I don't know lookup formulas. Regards Rajesh Kainikkara On 9/13/11, dguillett1 dguille...@gmail.com wrote: It appears that a simple vlookup should do it. =IF(ISNA(VLOOKUP(A11,$A$1:$B$8,2,0)),,(VLOOKUP(A11,$A$1:$B$8,2,0))) -Original Message- From: Rajesh K R Sent: Monday, September 12, 2011 1:51 PM To: excel-macros Subject: $$Excel-Macros$$ Look formula to select ledger group Hi Experts, Is there any formula we can use to select matched texts just like sumif formula(in case of numbers).Kindly find the attached file it ellaborate well about the issue.And tell me how to solve it. Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Look formula to select ledger group
Just put in the top cell and use the fill handle to copy down -Original Message- From: Rajesh K R Sent: Monday, September 12, 2011 2:08 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Look formula to select ledger group Hi, Thanks for getting a very quick reply, I don't know lookup formulas. Regards Rajesh Kainikkara On 9/13/11, dguillett1 dguille...@gmail.com wrote: It appears that a simple vlookup should do it. =IF(ISNA(VLOOKUP(A11,$A$1:$B$8,2,0)),,(VLOOKUP(A11,$A$1:$B$8,2,0))) -Original Message- From: Rajesh K R Sent: Monday, September 12, 2011 1:51 PM To: excel-macros Subject: $$Excel-Macros$$ Look formula to select ledger group Hi Experts, Is there any formula we can use to select matched texts just like sumif formula(in case of numbers).Kindly find the attached file it ellaborate well about the issue.And tell me how to solve it. Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$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 -
Re: $$Excel-Macros$$ LOOK
check the attachment see if it helps you On Thu, Nov 11, 2010 at 5:02 PM, 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 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
$$Excel-Macros$$ Look after ur health even ur a computer programmer
Hi dude's Ur tired o0f working on computer and loos ur health some tips are here Read and make use of it Before that go to this web page * http://mathematicalphysics.webs.com/ * Dieting TipsTo lose weight in a healthy way, we must control calorific intake and increase the amount of calories burned with some form of exercise. Regardless of the eating plan component of your weight-loss program, the following tips will help you accomplish your goals of healthy weight-loss and weight maintenance: Commit Yourself. The tomorrow diet:- if today is not right, then start your diet program tomorrow or when you feel that it is right for you. Don't start knowing that you have a big hurdle at the first bend, i.e. holiday, party etc. However once committed go for it with full determination to succeed. Write down why YOU are dieting. Make a list of reasons for you to start your new diet regime, and look at these in times of difficulty, some examples: to give yourself more self-confidence. to live a healthy lifestyle. the summer is coming and you want to look good. Make duplicate copies of your list. Place a copy on any of the food cupboards / fridge doors in the house. Place one on your weighing scales or in front of your mirror. Carry a copy with you, or make loads of copies and use the back of these as shopping lists. Feel good about yourself. A negative attitude guarantees negative results. Always feel good about yourself, make sure your self esteem is high. Even if people pass comment about your weight, you know that you are making a positive change. Don't let the pressures of thin being beautiful get to you. Stay Positive. Look at all the negatives with a positive, yeah you're chunky - but you're funky - you can go out and enjoy yourself, skinny people can't dance. Change everything to make you feel positive. Avoid the Scales. Your weight fluctuates mostly due to water weight on a daily basis. Limit your scale visits to no more than once a week. Weigh yourself on the same day and at the same time every week, and monitor your progress, not just your weight but also how you feel. Reward Yourself. Set yourself achievable goals, and treat yourself when you reach them, i.e. when you lose X amount, go and have a facial or new haircut. Its your Diet. Everyone is different on this planet, so everyone will have different results with how they are progressing on different diets. Don't compare your progress with anyone else's, yes have the support of a dieting group, but if you have a bad week compared to your dieting colleagues don't worry. Picture your Motivation. Having photos of yourself when you were slimmer, or pictures of your family can help you stay on track, use what pictures work for you. Stay away from Depressing people and TV programs. Watching or listening to depressing people rubs onto you, when most people are depressed they find food a comfort. Keep records of how much you Eat. Food diaries will help you analysis your eating habits, make sure that you eat at least 3 well balanced meals a day, avoid bingeing and starving yourself at all costs. Use the diary to see when any bad habits arise, and prepare yourself for these, i.e. the weekends. Kick one Vice at a Time. Aiming to give up smoking, chocolate, caffeine, alcohol, sex or any habit that has been a pleasure should be done one at a time in order for you and your body to adjust to the change. Keep your food in the Kitchen. Storing food in your bedroom, desk at work or in your car should be avoided, all these little snacks add up the calories you eat daily. Always have Breakfast. Start the day the right way, if you skip your first meal, you will just end up eating some junkie snack food. Eat before you get Hungry. Aim to eat before you get hungry to avoid preparing larger meals which you will just force yourself to eat. Try to eat your meals at the same time each day to condition your body to expect food at certain times. Avoid nibbling when Cooking. Start your eating when you sit at the table, you don't need to eat half the meal in the kitchen before it goes on your plate, if you find it hard to stop picking whilst you cook, aim to chew some gum. Drink plenty of Water. Help your body feel hydrated by keeping your fluid stores high, especially prior to eating, look at natural spring waters rather than carbonated as these can upset the digestive system. Eat Slowly. Take time eating your food, aim to taste it, chew it properly, placing the fork down after each mouthful, drinking sips of water at regular intervals to help with digestion. Use small Plates and Cutlery. Small plates make portions look bigger, small cutlery stops you shoveling your food in, and again helps slow down your eating process. Clean up All The Food. After you have eaten, either put the food in the bin, or storage rather than leaving it out. If the kids