$$Excel-Macros$$ Re: Complex formula Solution
=IF($K$3=ABB,IF(INDEX(A1:A195,MATCH(MIN(ABS($B$2:$B$195-M12)),ABS($B$2:$B$195-M12),0),0)K12,Minimum date is TEXT(K12,dd-mm-yy),INDEX(A1:A195,MATCH(MIN(ABS($B$2:$B$195-M12)),ABS($B$2:$B$195-M12),0),0))+1,IF(INDEX(A1:A195,MATCH(MIN(ABS($C$2:$C$195-M12)),ABS($C$2:$C$195-M12),0),0)K12,Minimum date is TEXT(K12,dd-mm-yy),INDEX(A1:A195,MATCH(MIN(ABS($C$2:$C$195-M12)),ABS($C$2:$C$195-M12),0),0)+1)) Chk dis file. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Wednesday, December 24, 2014 6:44:29 PM UTC+5:30, amar takale wrote: Dear experts team, I required formula to extract data as par my criteria but it is very complex criteria but my thought is that everything is possible in excel. Appreciate the help. Let us know in case of any further assistance. Regards Amar -- 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. Report Data (2)Final.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Urgent need of Advanced Excel Teacher
All, Do we have a directory of teachers in MS Excel-both newbies and Advanced? I need someone in Indore(Madhya Pradesh, India) urgently. Regards, Vani Sharma Information transmitted by this e-mail is proprietary to Mphasis, its associated companies and/ or its customers and is intended for use only by the individual or entity to which it is addressed, and may contain information that is privileged, confidential or exempt from disclosure under applicable law. If you are not the intended recipient or it appears that this mail has been forwarded to you without proper authority, you are notified that any use or dissemination of this information in any manner is strictly prohibited. In such cases, please notify us immediately at mailmas...@mphasis.com and delete this mail from your records. -- 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.
$$Excel-Macros$$ Import file from Text Fil
Hi Team, I have an query on Importing text file , delimit by Seperator and make particular column to be text, and import the same data into excel update those data from Row 2. thanks regards, saravanan R -- 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.
$$Excel-Macros$$ Strange behaviour with no developer code changes
With shtControlPanel Select Case UCase(strValue) Case cstrMONTHLY_PAID .optMonthly.Value = True DB_PayFrequency = PayMonthly intFrequency = cintMONTHLY_PAID Case cstrWEEKLY_PAID .optWeekly.Value = True DB_PayFrequency = PayWeekly intFrequency = cintWEEKLY_PAID Case cstr4WEEKLY_PAID .optOther.Value = True DB_PayFrequency = PayEvery4Weeks intFrequency = cint4WEEKLY_PAID Case Else .optWeekly.Value = True DB_PayFrequency = PayWeekly intFrequency = cintWEEKLY_PAID End Select ' ... End With In this code fragment, shtControlPanel is the CodeName of the worksheet containing, among other things, 3 ActiveX option button (radio) controls, namelY: optMonthly optWeekly optOther This code fragment has worked for months in Excel 2013 workbooks. Suddenly, without any alterations made to the software, the code fails at the compile stage opening the workbook, objecting to optMonthly, saying the member cannot be found. Has anyone experienced a similar problem? The environment has bee subject to Windows updates only. Any ideas would be appreciated. Thanks John A Cooke -- 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.
$$Excel-Macros$$ Re: Import file from Text Fil
send file On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote: Hi Team, I have an query on Importing text file , delimit by Seperator and make particular column to be text, and import the same data into excel update those data from Row 2. thanks regards, saravanan R -- 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$$ Re: Import file from Text Fil
here it is On Fri, Dec 26, 2014 at 4:55 PM, Mandeep Baluja rockerna...@gmail.com wrote: send file On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote: Hi Team, I have an query on Importing text file , delimit by Seperator and make particular column to be text, and import the same data into excel update those data from Row 2. thanks regards, saravanan R -- 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. 000707 SAR VAOOWJO (MWX) 600660.06.2014 6000802776 8 XXIOW666T60 OW666\T60 6800,000600,000 6600,000 6,872668,00 6600,0002668,00 0,000 0,0006.62.2014 N\A 06.62.2014 000707 SAR VAOOWJO (MWX) 600670.00.2014 6000868766 00022 XXIRZ7XT60 RZ7X\T600060,000200,000 0760,000 0,707682,00 7220,0000660,00 0,000 0,0028.66.2014 N\A 67.62.2014 000707 SAR VAOOWJO (MWX) 600670.00.2014 6000868766 00068 XXIOW666T60 OW666\T60 6800,0000,000 6800,000 6,877766,00 0,000 0,006800,0007766,00 26.62.2014 0 or OWss . . 000707 SAR VAOOWJO (MWX) 600606.06.2014 6000876266 7 XXIOW686T60 OW686\T60 7600,0002200,000 6600,0006,602760,00 6600,0002760,00 0,000 0,00 00.62.2014 N\A27.66.2014 000707 SAR VAOOWJO (MWX) 600620.06.2014 6000870866 2 XXXWON7077 WON7\0776080,0000,000 6080,000 6,08,60 6080,000,60 0,000 0,0027.62.2014 N\A 27.62.2014 000707 SAR VAOOWJO (MWX) 600627.06.2014 6000878668 6 XXIRZ7XT60 RZ7X\T602000,0000,000 2000,000 0,706000,00 2000,0006000,00 0,000 0,0028.66.2014 N\A 06.62.2014 000707 SAR VAOOWJO (MWX) 600627.06.2014 6000878666 0 XXIOW676T60 OW676\T60 0600,0002800,000 2600,0006,706000,00 2600,0006000,00 0,000 0,00 66.66.2014 N\A66.62.2014 000707 SAR VAOOWJO (MWX) 600620.07.2014 6000888670 00062 XXIOW006T60 OW006\T60 6800,000600,000 6600,000 0,866676,00 6200,0007602,00 0,000 0,0008.62.2014 N\A 66.62.2014 000707 SAR VAOOWJO (MWX) 600620.07.2014 6000888670
$$Excel-Macros$$ Re: Import file from Text Fil
Want this result ? Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Friday, December 26, 2014 4:33:13 PM UTC+5:30, saravanan R wrote: Hi Team, I have an query on Importing text file , delimit by Seperator and make particular column to be text, and import the same data into excel update those data from Row 2. thanks regards, saravanan R -- 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. abc.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Help on coding to change cell value after every printing
Dear experts, I want to change cell value on every automatic printing as per series given, please see attached file in which describe in detail. Regards. Ashish Bhalara 9624111822 P*Please do not print this email unless it is absolutely necessary. Spread environmental üawareness.♣♣♣* -- 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. query.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Conditional Formatting
Hi. I have a spreadsheet with cells containing month and year (ie. Mar 2014) without using a day. I would like the cell to be yellow if we are in the current month and year, and appear red if the month and year has passed. Using Excel 2013, what cell date formatting should I use, and how should the formula be structured? Thank you. -- 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$$ Conditional Formatting
PFA On 27/12/2014 1:06, Alison Toczko wrote: Hi. I have a spreadsheet with cells containing month and year (ie. Mar 2014) without using a day. I would like the cell to be yellow if we are in the current month and year, and appear red if the month and year has passed. Using Excel 2013, what cell date formatting should I use, and how should the formula be structured? Thank you. -- 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 mailto:excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com mailto: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. month colour.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: What is this Cache stands for.
You have installed a addin in your sheet. remove the addin first it will automatically remove. 1. Click the Microsoft Office Button [image: Office button image], click Excel Options, and then click Add-Ins. then select addin and press go uncheck the addin. Regards, Mandeep Baluja LearningZmyPassion https://www.linkedin.com/profile/view?id=312532939 https://www.facebook.com/VBAEXCELSQL?ref=hl On Saturday, December 27, 2014 11:48:23 AM UTC+5:30, sandeep chhajer wrote: Dear Excel Gurus, Please check the print screen attached herewith. I am getting a sheet called Acerno_cache_x with a status very hidden, in every workbook I am opening. Can any one help me out. -- Regards, CA Sandeep Kumar Chhajer. Membership no: 160212 -- 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.