Re: $$Excel-Macros$$ count group wise
Can you elaborate a bit, based on wht u want the count On Fri, Feb 24, 2012 at 1:45 PM, raghunandan rallapalli raghunandan.rallapa...@gmail.com wrote: Hello Sir, please give me a formula for the attached sheet, FRA AND STN WISE THANKS WITH REGARDS. RAGHU NANDAN R -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ count group wise
*Explain More... * On Fri, Feb 24, 2012 at 12:15 PM, raghunandan rallapalli raghunandan.rallapa...@gmail.com wrote: Hello Sir, please give me a formula for the attached sheet, FRA AND STN WISE THANKS WITH REGARDS. RAGHU NANDAN R -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Custom Format Examples
Its really a gud one, thanks noorain On Thu, Feb 23, 2012 at 10:08 PM, chandra sekaran duraichan...@gmail.comwrote: thanks Noorain, its helpful for excel users lke me , On Thu, Feb 23, 2012 at 8:17 PM, xlstime xlst...@gmail.com wrote: very useful On Wed, Feb 22, 2012 at 11:08 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Group, I have shared a Custom Format example sheet, i got it from below link http://spreadsheetpage.com/index.php/file/custom_number_formats/ Hope it will help to all of you. -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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$$ please help
Hi, Please help me how to show percentage in bar chart like value -- Thanks Regards Anil Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com SHOW PERCENTAGE.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ please help
Hi, Find the attached file. On Fri, Feb 24, 2012 at 2:11 PM, anil panchal anil.kan...@gmail.com wrote: Hi, Please help me how to show percentage in bar chart like value -- 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 SOLVED_SHOW PERCENTAGE.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ please help
Dear Anil, Please see attached sheet, Maries solution is good but You can do it without using helping column On Fri, Feb 24, 2012 at 3:41 PM, anil panchal anil.kan...@gmail.com wrote: Hi, Please help me how to show percentage in bar chart like value -- Thanks Regards Anil Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com SHOW PERCENTAGE(Without Helping COlumn).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min
Hi all, I have the data in below format, I try to convert the date format in to decimal Minutes. It comes well when the data below 24 Hrs, as soon as it exceed 24 Hrs, it gives a wrong fig. I used the below formula to get answers =HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60 gprs - national - 26:48:21168.3500 - Wrong gprs - national 25:15:4718. - Wrong gprs - national 21:23:051283.0833 - Correct to other uk mobile operators19:50:071190.1167 - Correct to other uk mobile operators14:35:19875.3167 - Correct gprs - national 11:28:10688.1667 - Correct Thanks for help Rgds Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ count group wise
Sir, I mean, its a group wise, counting from FRA+STN wise ,, like in sql (SELECT FRA,STN,COUNT(1) FROM COUNT GROUP BY FRA,STN THANKS WITH REGARDS. RRN On Fri, Feb 24, 2012 at 2:13 PM, Maries talk2mar...@gmail.com wrote: *Explain More... * On Fri, Feb 24, 2012 at 12:15 PM, raghunandan rallapalli raghunandan.rallapa...@gmail.com wrote: Hello Sir, please give me a formula for the attached sheet, FRA AND STN WISE THANKS WITH REGARDS. RAGHU NANDAN R -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Custom Format Examples
NOORAIN ROCKS ONCE AGAIN Really helpful attachment for excel user from one of the most helpful member of the group Thanks a lot brother *Kalyan Chattopadhyay* ** *Executive Sales Coordinator* *R. S. H. Pvt. Ltd.* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Custom Format Examples
Hi Noorain, One small question how can I set this formats as default in my excel. Thanks Waheed On Fri, Feb 24, 2012 at 5:30 PM, Kal xcel kalx...@gmail.com wrote: NOORAIN ROCKS ONCE AGAIN Really helpful attachment for excel user from one of the most helpful member of the group Thanks a lot brother *Kalyan Chattopadhyay* ** *Executive Sales Coordinator* *R. S. H. Pvt. Ltd.* -- 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$$ instead of formula need macros
Hi All, I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. So I need a macros instead of this formula. Could you please solve this query to me. Formula is = Selection.FormulaArray = _ =SUM(IF((R2C4:R5C4=RC[-14])*(R2C4:R5C4=R[-1]C[-22])*(R2C2:R5C2 =R[-2]C[-7]), (1/COUNTIFS(R2C4:R5C4, R2C4:R5C4, R2C2:R5C2, R2C2:R5C2)), 0)) Range(X4).Select Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ instead of formula need macros
Dear Lokesh, Can you share a sample sheet..What is your adject requirement. On Fri, Feb 24, 2012 at 6:50 PM, lokesh lokeshsmg2...@gmail.com wrote: Hi All, ** ** I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. ** ** So I need a macros instead of this formula. Could you please solve this query to me. ** ** Formula is = Selection.FormulaArray = _ =SUM(IF((R2C4:R5C4=RC[-14])*(R2C4:R5C4=R[-1]C[-22])*(R2C2:R5C2=R[-2]C[-7]), (1/COUNTIFS(R2C4:R5C4, R2C4:R5C4, R2C2:R5C2, R2C2:R5C2)), 0)) Range(X4).Select ** ** ** ** Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ instead of formula need macros
Hi Noorain, Please find the attached sample excel file for your reference. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Can you share a sample sheet..What is your adject requirement. On Fri, Feb 24, 2012 at 6:50 PM, lokesh lokeshsmg2...@gmail.com wrote: Hi All, ** ** I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. ** ** So I need a macros instead of this formula. Could you please solve this query to me. ** ** Formula is = Selection.FormulaArray = _ =SUM(IF((R2C4:R5C4=RC[-14])*(R2C4:R5C4=R[-1]C[-22])*(R2C2:R5C2=R[-2]C[-7]), (1/COUNTIFS(R2C4:R5C4, R2C4:R5C4, R2C2:R5C2, R2C2:R5C2)), 0)) Range(X4).Select ** ** ** ** Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com working days macros.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ instead of formula need macros
send a file with a complete explanation. Don Guillett SalesAid Software dguille...@gmail.com From: lokesh Sent: Friday, February 24, 2012 7:20 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ instead of formula need macros Hi All, I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. So I need a macros instead of this formula. Could you please solve this query to me. Formula is = Selection.FormulaArray = _ =SUM(IF((R2C4:R5C4=RC[-14])*(R2C4:R5C4=R[-1]C[-22])*(R2C2:R5C2=R[-2]C[-7]), (1/COUNTIFS(R2C4:R5C4, R2C4:R5C4, R2C2:R5C2, R2C2:R5C2)), 0)) Range(X4).Select Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Custom Format Examples
Gud1 Noorain Bhai - carry on On Fri, Feb 24, 2012 at 6:09 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi Noorain, One small question how can I set this formats as default in my excel. Thanks Waheed On Fri, Feb 24, 2012 at 5:30 PM, Kal xcel kalx...@gmail.com wrote: NOORAIN ROCKS ONCE AGAIN Really helpful attachment for excel user from one of the most helpful member of the group Thanks a lot brother Kalyan Chattopadhyay Executive Sales Coordinator R. S. H. Pvt. Ltd. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ instead of formula need macros
Just i want to count the working days based on names in the listed file through macros. (except Saturday and Sunday) regards Lokesh.M On Fri, Feb 24, 2012 at 8:13 PM, dguillett1 dguille...@gmail.com wrote: send a file with a complete explanation. Don Guillett SalesAid Software dguille...@gmail.com *From:* lokesh lokeshsmg2...@gmail.com *Sent:* Friday, February 24, 2012 7:20 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ instead of formula need macros Hi All, I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. So I need a macros instead of this formula. Could you please solve this query to me. Formula is = Selection.FormulaArray = _ =SUM(IF((R2C4:R5C4=RC[-14])*(R2C4:R5C4=R[-1]C[-22])*(R2C2:R5C2=R[-2]C[-7]), (1/COUNTIFS(R2C4:R5C4, R2C4:R5C4, R2C2:R5C2, R2C2:R5C2)), 0)) Range(X4).Select Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ instead of formula need macros
Dear Lokesh, Please see attached sheet with solution. Hope it help to you. On Fri, Feb 24, 2012 at 8:12 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Noorain, Please find the attached sample excel file for your reference. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Can you share a sample sheet..What is your adject requirement. On Fri, Feb 24, 2012 at 6:50 PM, lokesh lokeshsmg2...@gmail.com wrote: Hi All, ** ** I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. ** ** So I need a macros instead of this formula. Could you please solve this query to me. ** ** Formula is = Selection.FormulaArray = _ =SUM(IF((R2C4:R5C4=RC[-14])*(R2C4:R5C4=R[-1]C[-22])*(R2C2:R5C2=R[-2]C[-7]), (1/COUNTIFS(R2C4:R5C4, R2C4:R5C4, R2C2:R5C2, R2C2:R5C2)), 0)) Range(X4).Select ** ** ** ** Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com working days macros(Solved).xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Need a small MACRO to SPLIT Double Looping
Dear Sir, Pl explain questions in a small para. I am enclosing a file this has col. on which I need separate XL files/sheets made. COLM D Thru F are say dummy.cud be more also. i) Separate files as per month[ col b ] ii) Separate sheets as per subjects[ col c ] Sheet names I got fro m you [ the unique city , but how to specify file names [ say I need combination of item and say DATE, or a variable... well I need to insert a row S. No in each sheet , of alll files [ to be populated 1,2,3... and in COLm 'A' ] [ Here I need say upto first 10 entries , if exists. ] On 2/6/12, dguillett1 dguille...@gmail.com wrote: Glad to help Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Sunday, February 05, 2012 8:43 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Need a small MACRO to SPLIT Many thanks Don Guillett Sir, You hv done MORE than my requirement. =mangal ho [ GOD BLESS ] On 2/5/12, dguillett1 dguille...@gmail.com wrote: See Attached to make unique listfilter and copy to new sheets in file Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Somnath Khadilkar Sent: Sunday, February 05, 2012 11:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need a small MACRO to SPLIT Good even... I have attached a sample file depending upon colm A I need to split the whole DATA sheets into multiple sheets in the same/diff. file each sheets be named as per the COLM 'A', if possible. These entries are from few to many 100 K [ max distinct cities 25, however] =mangal ho Good Morning. I receive XL file comprising 1-sheet. Depending upon Colm 'A' I need to SPLIT this single sheet into MULTIPLE sheets [ with this colm as it name. ] The Distinct entries in this colm. would be less than say 25, but the no of entries cud be anything say 10 to 100 K. Regards You really need to give us details and send a file with a complete explanation. Don Guillett SalesAid Software dguille...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for 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
Re: $$Excel-Macros$$ instead of formula need macros
Dear Lokesh, Please use it without using Helping Column. =SUMPRODUCT(--($H$2:$H$51=B3)*(TEXT($G$2:$G$51,ddd)Sat)*(TEXT($G$2:$G$51,ddd)Sun)) On Fri, Feb 24, 2012 at 8:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Please see attached sheet with solution. Hope it help to you. On Fri, Feb 24, 2012 at 8:12 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Noorain, Please find the attached sample excel file for your reference. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Lokesh, Can you share a sample sheet..What is your adject requirement. On Fri, Feb 24, 2012 at 6:50 PM, lokesh lokeshsmg2...@gmail.comwrote: Hi All, ** ** I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. ** ** So I need a macros instead of this formula. Could you please solve this query to me. ** ** Formula is = Selection.FormulaArray = _ =SUM(IF((R2C4:R5C4=RC[-14])*(R2C4:R5C4=R[-1]C[-22])*(R2C2:R5C2=R[-2]C[-7]), (1/COUNTIFS(R2C4:R5C4, R2C4:R5C4, R2C2:R5C2, R2C2:R5C2)), 0)) Range(X4).Select ** ** ** ** Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this
Re: $$Excel-Macros$$ instead of formula need macros
Hi Noorain, In the excel file i have re corrected the dates, like this i want working days for the mentioned name in macros. please see the excel file attached. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Please see attached sheet with solution. Hope it help to you. On Fri, Feb 24, 2012 at 8:12 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Noorain, Please find the attached sample excel file for your reference. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Lokesh, Can you share a sample sheet..What is your adject requirement. On Fri, Feb 24, 2012 at 6:50 PM, lokesh lokeshsmg2...@gmail.comwrote: Hi All, ** ** I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. ** ** So I need a macros instead of this formula. Could you please solve this query to me. ** ** Formula is = Selection.FormulaArray = _ =SUM(IF((R2C4:R5C4=RC[-14])*(R2C4:R5C4=R[-1]C[-22])*(R2C2:R5C2=R[-2]C[-7]), (1/COUNTIFS(R2C4:R5C4, R2C4:R5C4, R2C2:R5C2, R2C2:R5C2)), 0)) Range(X4).Select ** ** ** ** Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are
Re: $$Excel-Macros$$ instead of formula need macros
Dear Lokesh, Please see attached sheet as per ur requirement. Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Fri, Feb 24, 2012 at 8:45 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Noorain, In the excel file i have re corrected the dates, like this i want working days for the mentioned name in macros. please see the excel file attached. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:31 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Lokesh, Please see attached sheet with solution. Hope it help to you. On Fri, Feb 24, 2012 at 8:12 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote: Hi Noorain, Please find the attached sample excel file for your reference. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Lokesh, Can you share a sample sheet..What is your adject requirement. On Fri, Feb 24, 2012 at 6:50 PM, lokesh lokeshsmg2...@gmail.comwrote: Hi All, ** ** I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. ** ** So I need a macros instead of this formula. Could you please solve this query to me. ** ** Formula is = Selection.FormulaArray = _ =SUM(IF((R2C4:R5C4=RC[-14])*(R2C4:R5C4=R[-1]C[-22])*(R2C2:R5C2=R[-2]C[-7]), (1/COUNTIFS(R2C4:R5C4, R2C4:R5C4, R2C2:R5C2, R2C2:R5C2)), 0)) Range(X4).Select ** ** ** ** Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive
Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users
Don, I spent hours going through that spreadsheet and learned a lot. Thank you for your help and teaching. John On Thu, Feb 23, 2012 at 12:16 PM, dguillett1 dguille...@gmail.com wrote: That’s because the defined name was not referenced in the chart sources. series=smith.xls!definedname Don Guillett SalesAid Software dguille...@gmail.com *From:* John A. Smith johnasmit...@gmail.com *Sent:* Thursday, February 23, 2012 9:25 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users Xlstime, I saw that but when I added another product it didn't show up on the chart. John On Thu, Feb 23, 2012 at 10:20 AM, xlstime xlst...@gmail.com wrote: in Name Manager, press alt+i+n+d On Thu, Feb 23, 2012 at 8:47 PM, John A. Smith johnasmit...@gmail.comwrote: Xlstime, Where do I put that formula? John On Thu, Feb 23, 2012 at 10:10 AM, xlstime xlst...@gmail.com wrote: Dear John, Please find the attachment use formula =OFFSET($A$2,0,0,COUNTA($A$2:$A$10),COUNTA($A$2:$F$2)) On Thu, Feb 23, 2012 at 8:13 PM, John A. Smith johnasmit...@gmail.comwrote: I would like to create a template whereby users could add any varialbe of items to track and the chart work for the 5 item user as well as the 9 item user. Please see the attached example. Thank you again for your dedicated help. John -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for
Re: $$Excel-Macros$$ instead of formula need macros
No helper =SUMPRODUCT((WEEKDAY($G$2:$G$17)1)*(WEEKDAY($G$2:$G$17)7)*($H$2:$H$17=B3)) Don Guillett SalesAid Software dguille...@gmail.com From: Lokesh Loki Sent: Friday, February 24, 2012 9:15 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ instead of formula need macros Hi Noorain, In the excel file i have re corrected the dates, like this i want working days for the mentioned name in macros. please see the excel file attached. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:31 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Lokesh, Please see attached sheet with solution. Hope it help to you. On Fri, Feb 24, 2012 at 8:12 PM, Lokesh Loki lokeshsmg2...@gmail.com wrote: Hi Noorain, Please find the attached sample excel file for your reference. Regards Lokesh.M On Fri, Feb 24, 2012 at 8:00 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Lokesh, Can you share a sample sheet..What is your adject requirement. On Fri, Feb 24, 2012 at 6:50 PM, lokesh lokeshsmg2...@gmail.com wrote: Hi All, I am using this formula to extract the working days in a month, but this formula is very big and while pulling the report it takes too much time to pull the report. So I need a macros instead of this formula. Could you please solve this query to me. Formula is = Selection.FormulaArray = _ =SUM(IF((R2C4:R5C4=RC[-14])*(R2C4:R5C4=R[-1]C[-22])*(R2C2:R5C2=R[-2]C[-7]), (1/COUNTIFS(R2C4:R5C4, R2C4:R5C4, R2C2:R5C2, R2C2:R5C2)), 0)) Range(X4).Select Regards Lokesh.M -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Thanks regards, Noorain Ansari http://noorainansari.com/ http://excelmacroworld.blogspot.com/ -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please
Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min
*=G91*1440* Regards, Sam Mathai Chacko On Fri, Feb 24, 2012 at 4:53 PM, satish narbhaviwithsatishku...@gmail.comwrote: Hi all, I have the data in below format, I try to convert the date format in to decimal Minutes. It comes well when the data below 24 Hrs, as soon as it exceed 24 Hrs, it gives a wrong fig. I used the below formula to get answers =HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60 gprs - national - 26:48:21168.3500 - Wrong gprs - national 25:15:4718. - Wrong gprs - national 21:23:051283.0833 - Correct to other uk mobile operators19:50:071190.1167 - Correct to other uk mobile operators14:35:19875.3167 - Correct gprs - national 11:28:10688.1667 - Correct Thanks for help Rgds Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel Help needed - To convert date format in to Decimal Min
If you insist on using your original formula, try a more lengthier *=QUOTIENT(G91,1)*1440+HOUR(**G9**1)*60+MINUTE(**G9**1)+SECOND(**G9**1)/60* But *=G91*1440 will give the same answer* Regards, Sam Mathai Chacko On Fri, Feb 24, 2012 at 10:19 PM, Sam Mathai Chacko samde...@gmail.comwrote: *=G91*1440* Regards, Sam Mathai Chacko On Fri, Feb 24, 2012 at 4:53 PM, satish narbhaviwithsatishku...@gmail.com wrote: Hi all, I have the data in below format, I try to convert the date format in to decimal Minutes. It comes well when the data below 24 Hrs, as soon as it exceed 24 Hrs, it gives a wrong fig. I used the below formula to get answers =HOUR(G91)*60+MINUTE(G91)+SECOND(G91)/60 gprs - national - 26:48:21168.3500 - Wrong gprs - national 25:15:4718. - Wrong gprs - national 21:23:051283.0833 - Correct to other uk mobile operators19:50:071190.1167 - Correct to other uk mobile operators14:35:19875.3167 - Correct gprs - national 11:28:10688.1667 - Correct Thanks for help Rgds Kumar -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Required Name
2012/2/23 Kris krishnak...@gmail.com Hi In C16 and copied down, =INDEX($A$2:$A$12,MATCH(B16,INDEX($B$2:$F$12,,MATCH(A16,$B$1:$F$1,0)),0)) Kris -- 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 No question, together with File -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function
Asa, Thank you very much for taking sometime and explaining the concept for us. Skanda. On Fri, Feb 24, 2012 at 3:00 AM, Asa Rossoff a...@lovetour.info wrote: Hi Skanda, I don't know much about SAS, but here is an example of a common use of --* *** =SUMPRODUCT(--(Customer[City]=Paris),--(Customer[Country]France))*** * The above uses an Excel 2010 Table notation. You can replace Customer[City] and Customer[Country] with the data range in columns containing the City and Country in a list of Customers. ** ** The formula actually counts the number of records that meet both criteria, because each criterion is evaluated to 0 or 1 and then multiplied by the other for each record, resulting in a 0 unless both criteria are met, when it will be 1. Then the results for all the records are added together.*** * ** ** If you want to know, say, the total sales for that set of customers: =SUMPRODUCT(--(Customer[City]=Paris),--(Customer[Country]France),Customer[Sales]) will work because the 0 or 1 for each record will then be multiplied by the Sales amount before being added to other record's results. ** ** ** ** In Excel 2007+ the basic examples I just gave could be achieved more efficiently (quicker calculation) using COUNTIFS and SUMIFS, which wouldn't require the double negative. ** ** I'll also throw in to my explanations that sometimes it's useful to not convert all booleans to numbers, and take advantage of the fact that booleans are ignored by aggregate functions. ** ** Take the MEDIAN and AVERAGE functions, for example. Including 0 values for records not of interest will skew the results. Instead, you can handle the boolean values using IF(boolean,value to aggregate) (you can omit the value-if-false part because IF will just return a boolean False when it's omited, which will then be disregarded by the aggregate function as if there was no value at all): =MEDIAN(IF((Customer[City]=Paris)*(Customer[Country]France)*NOT(ISBLANK(Customer[Sales])),Customer[Sales])) ** ** The attached files demonstrate. The xlsx version has both 2010 table reference and traditional range reference versions of the formulas; the xls version just has range versions. ** ** Asa ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Skanda *Sent:* Thursday, February 23, 2012 9:10 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function ** ** I'm from SAS background. Can anybody please provide an example for the following scenario. On Thu, Feb 23, 2012 at 11:02 AM, Sam Mathai Chacko samde...@gmail.com wrote: I know I mentioned otherwise in http://osdir.com/ml/excel-macros/2011-12/msg00084.html However,* you cannot use ++* You can use +0, *1, -0, /1, ^1 etc, but -- is the most elegant and common approach. Regards, Sam Mathai Chacko ** ** On Thu, Feb 23, 2012 at 12:21 PM, Asa Rossoff a...@lovetour.info wrote:** ** Hi Johann, To add to Noorain's explanation: Boolean (True/False) values cannot be added, multiplied, averaged, etc. by aggregate functions such as SUM(), PRODUCT(), AVERAGE(), MEDIAN(), and SUMPRODUCT. In fact, boolean values are always completely ignored by aggregate functions. To summarize boolean values with an aggregate function, you must convert the the boolean to a number. When you use a value in a formula as if it were a different type of data, Excel will in most circumstances convert the value to that type of data. This implicit method of data type conversion is called coercion. You can coerce boolean values to a number, text representations of a number to a number, textual dates/times to actual date/times (dateserials), anything to text,… Boolean values can be coerced to a number (1 for True, 0 for False) in several ways. If you use an arithmetic operator with a boolean value, the boolean is coerced to become a number. In recent versions of Excel, the N() function performs an explicit conversion to a number and works in many circumstances (although arithmetic coercion works more broadly). For completeness there is also the similar VALUE function which can convert most data types to numbers, but not booleans. When you don't need to use an arithmetic operator in your formula already, but you need to coerce a boolean value, you have to device a neutral expression that includes an arithmetic operator, like --boolean, boolean*1, boolean+0, boolean/1. -- is often favored. Your formula is still clean, the -- form would probably not be used in other circumstances, and it's a fast calculation for Excel. Usually the requirement to utilize boolean values as numbers comes up in array formulas and SUMPRODUCT formulas (similar because
RE: $$Excel-Macros$$ search via macro like excel
-Original message- From: Prajakt Pande Sent: 23/02/2012, 10:30 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ search via macro like excel Dear MARIES, Thank you very much. On Tue, Feb 21, 2012 at 8:44 PM, Maries talk2mar...@gmail.com wrote: Hi Prajakt, Please find the attached file.I have used below codes in user form. Private Sub CommandButton1_Click() Dim rng1 As Range Dim lll As Integer Sheets(Sheet2).Select Cells.Select Selection.ClearContents lll = Len(TextBox1.Value) Set rng1 = Range(Sheet1!A2:A500) For i = 1 To 500 With rng1 If Left(.Cells(i, 1).Value, lll) = TextBox1.Value Then Sheets(Sheet2).Cells(500, 1).End(xlUp).Offset(1, 0).Value = .Cells(i, 1).Value Sheets(Sheet2).Cells(500, 1).End(xlUp).Offset(0, 1).Value = .Cells(i, 2).Value Sheets(Sheet2).Cells(500, 1).End(xlUp).Offset(0, 2).Value = .Cells(i, 3).Value Sheets(Sheet2).Cells(500, 1).End(xlUp).Offset(0, 3).Value = .Cells(i, 4).Value End If End With Next i TextBox1.Value = Sheets(Sheet2).Cells(2, 1).Value TextBox3.Value = Sheets(Sheet2).Cells(2, 2).Value TextBox4.Value = Sheets(Sheet2).Cells(2, 3).Value TextBox5.Value = Sheets(Sheet2).Cells(2, 4).Value Sheets(Sheet1).Select End Sub Private Sub CommandButton2_Click() Dim rng As Range Set rng = Range(Sheet2!A2:A500) For i = 1 To 500 With rng If TextBox1.Value = Trim(.Cells(i, 1).Value) And .Cells(i + 1, 1).Value Then TextBox1.Value = .Cells(i + 1, 1).Value TextBox3.Value = .Cells(i + 1, 2).Value TextBox4.Value = .Cells(i + 1, 3).Value TextBox5.Value = .Cells(i + 1, 4).Value Exit For End If End With Next i End Sub Private Sub CommandButton3_Click() Dim rng As Range Set rng = Range(Sheet2!A2:A500) For i = 1 To 500 With rng If TextBox1.Value = Trim(.Cells(i, 1).Value) And .Cells(i - 1, 1).Value Then TextBox1.Value = .Cells(i - 1, 1).Value TextBox3.Value = .Cells(i - 1, 2).Value TextBox4.Value = .Cells(i - 1, 3).Value TextBox5.Value = .Cells(i - 1, 4).Value Exit For End If End With Next i End Sub I hope this fulfill your requirements. Regards, MARIES. On Mon, Feb 20, 2012 at 1:59 PM, MAnoj Kumar manoj...@gmail.com wrote: Dear Sir, Please solved my problam. On Mon, Feb 20, 2012 at 2:02 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: Dear Maries, Not like this, it was with user form 01) if i put roll on codes with 4 digits and hit the search button it suppose to be show first match value. For example:- Roll On Code name duty in % Unit's Of measure 12345678 Rabbit 1% y 12345679 House 2% N 12345610 Lion 0% y 12345611 Tiger 0% N In above example there are roll on codes are starts with 1234 with different name, duty in %, unit's of measure My question is, if I put roll on code in test box after that hit the search button it need to show first value in particular field, and if there are more matches with that then by hitting next previous button i can see the name, duty in % units of measure. Just like find function in excel I want to embed with user form. Thanks in advance. file attached for your reference. On Mon, Feb 20, 2012 at 11:36 AM, Maries talk2mar...@gmail.com wrote: On Mon, Feb 20, 2012 at 11:34 AM, Maries talk2mar...@gmail.com wrote: PFA. *Formula - =INDEX(B2:B21,MATCH(TRUE,VALUE(RIGHT(A2:A21,4))=H12,0))* On Sun, Feb 19, 2012 at 12:15 PM, Prajakt Pande prajakt.pa...@gmail.com wrote: Dear all, Roll on codes are maximum 8 digits, I want to search via roll on codes, at least 4 digits, Where ever it matches with sequence, need to update the other information in respective field, with next and previous option, If “Roll on code” is not available then search via NAME. Sheet attached please help. Thanks in advance, Thanks Regards, Prajakt Pande -- 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
$$Excel-Macros$$ Dialing a Phone Number in Excel??
Someone asked me if I knew how to make Excel dial a phone number??? Has anyone ever heard of this? How would I make this happen? Can someone explain the logic and functionality? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ search via macro like excel
-Original message- From: Prajakt Pande Sent: 23/02/2012, 10:30 AM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ search via macro like excel Dear MARIES, Thank you very much. On Tue, Feb 21, 2012 at 8:44 PM, Maries talk2mar...@gmail.com wrote: Hi Prajakt, Please find the attached file.I have used below codes in user form. Private Sub CommandButton1_Click() Dim rng1 As Range Dim lll As Integer Sheets(Sheet2).Select Cells.Select Selection.ClearContents lll = Len(TextBox1.Value) Set rng1 = Range(Sheet1!A2:A500) For i = 1 To 500 With rng1 If Left(.Cells(i, 1).Value, lll) = TextBox1.Value Then Sheets(Sheet2).Cells(500, 1).End(xlUp).Offset(1, 0).Value = .Cells(i, 1).Value Sheets(Sheet2).Cells(500, 1).End(xlUp).Offset(0, 1).Value = .Cells(i, 2).Value Sheets(Sheet2).Cells(500, 1).End(xlUp).Offset(0, 2).Value = .Cells(i, 3).Value Sheets(Sheet2).Cells(500, 1).End(xlUp).Offset(0, 3).Value = .Cells(i, 4).Value End If End With Next i TextBox1.Value = Sheets(Sheet2).Cells(2, 1).Value TextBox3.Value = Sheets(Sheet2).Cells(2, 2).Value TextBox4.Value = Sheets(Sheet2).Cells(2, 3).Value TextBox5.Value = Sheets(Sheet2).Cells(2, 4).Value Sheets(Sheet1).Select End Sub Private Sub CommandButton2_Click() Dim rng As Range Set rng = Range(Sheet2!A2:A500) For i = 1 To 500 With rng If TextBox1.Value = Trim(.Cells(i, 1).Value) And .Cells(i + 1, 1).Value Then TextBox1.Value = .Cells(i + 1, 1).Value TextBox3.Value = .Cells(i + 1, 2).Value TextBox4.Value = .Cells(i + 1, 3).Value TextBox5.Value = .Cells(i + 1, 4).Value Exit For End If End With Next i End Sub Private Sub CommandButton3_Click() Dim rng As Range Set rng = Range(Sheet2!A2:A500) For i = 1 To 500 With rng If TextBox1.Value = Trim(.Cells(i, 1).Value) And .Cells(i - 1, 1).Value Then TextBox1.Value = .Cells(i - 1, 1).Value TextBox3.Value = .Cells(i - 1, 2).Value TextBox4.Value = .Cells(i - 1, 3).Value TextBox5.Value = .Cells(i - 1, 4).Value Exit For End If End With Next i End Sub I hope this fulfill your requirements. Regards, MARIES. On Mon, Feb 20, 2012 at 1:59 PM, MAnoj Kumar manoj...@gmail.com wrote: Dear Sir, Please solved my problam. On Mon, Feb 20, 2012 at 2:02 PM, Prajakt Pande prajakt.pa...@gmail.comwrote: Dear Maries, Not like this, it was with user form 01) if i put roll on codes with 4 digits and hit the search button it suppose to be show first match value. For example:- Roll On Code name duty in % Unit's Of measure 12345678 Rabbit 1% y 12345679 House 2% N 12345610 Lion 0% y 12345611 Tiger 0% N In above example there are roll on codes are starts with 1234 with different name, duty in %, unit's of measure My question is, if I put roll on code in test box after that hit the search button it need to show first value in particular field, and if there are more matches with that then by hitting next previous button i can see the name, duty in % units of measure. Just like find function in excel I want to embed with user form. Thanks in advance. file attached for your reference. On Mon, Feb 20, 2012 at 11:36 AM, Maries talk2mar...@gmail.com wrote: On Mon, Feb 20, 2012 at 11:34 AM, Maries talk2mar...@gmail.com wrote: PFA. *Formula - =INDEX(B2:B21,MATCH(TRUE,VALUE(RIGHT(A2:A21,4))=H12,0))* On Sun, Feb 19, 2012 at 12:15 PM, Prajakt Pande prajakt.pa...@gmail.com wrote: Dear all, Roll on codes are maximum 8 digits, I want to search via roll on codes, at least 4 digits, Where ever it matches with sequence, need to update the other information in respective field, with next and previous option, If “Roll on code” is not available then search via NAME. Sheet attached please help. Thanks in advance, Thanks Regards, Prajakt Pande -- 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
$$Excel-Macros$$ how can i convert nomber to test
Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees Mail sent via way2sms. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Dont post a question in the thread of another member. 3) Dont 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 : Dont 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$$ Let me know the idea
Good challenge to every one. I have one file that contain more then 25 column with 1 column is unique values. In that file have more then 1000 of record, i have to split that file to 6 file as *.csv format. In each file have some selected number of column likewise 7, 7, 2, 5, 2 and 2. The question is 6 file are automatically generate and store that column exact record when i click control button on source document by using VBA with Macros. Let me know your idea. Thanks in advance. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ remove a certain text from every sentence
Using: [image: image.png] would be a great and dynamic way. Shekhar Sharma 9910010060 On Thu, Nov 10, 2011 at 8:45 PM, Mukesh Kumar Jha mukeshconsci...@gmail.com wrote: ** Hi Smitha, Try below formula =RIGHT(A1,LEN(A1)-FIND(:,A1)) Thanks Mukesh - Original Message - *From:* smitha.kumari smitha.kum...@speridian.com *To:* excel-macros@googlegroups.com *Sent:* Thursday, November 10, 2011 11:32 AM *Subject:* RE: $$Excel-Macros$$ remove a certain text from every sentence The result should be david and not Technology company ** ** Regards Smitha/ Senior Finance Executive [image: Speridian%20Logo] World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 smitha.kum...@speridian.com ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *jmothilal *Sent:* Thursday, November 10, 2011 11:17 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ remove a certain text from every sentence* *** ** ** Use This command ** ** [image: image.png] Thanks with ** ** Mothilal.J -- FORUM RULES (925+ 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 (925+ 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 -- Shekhar Sharma 9910010060 Life consists not in holding good cards but in playing those you hold well Before you judge another, think of your own last mistake. -- 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 image.pngimage001.jpgimage002.png
Re: $$Excel-Macros$$ water fall chart
Dear Noorain This chart is very helpful but i am not yet sure how to make this chart. If you can help with the steps it will be of great help. Thanks in advance Sumit kumar On Fri, Feb 24, 2012 at 11:09 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mansoor, Please find Example of Water Fall Chart as attachment. -- Thanks regards, Noorain Ansari ** http://excelmacroworld.blogspot.com/*http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Fri, Feb 24, 2012 at 1:05 AM, danial mansoor danial_...@hotmail.comwrote: hi experts, can any one send me working on water fall chart with connector lines?i need template with formulas i just need to put values and it automatically made chart with connector using given data. note: data should be composed on intail and final values and in between these 4 values. -- From: amit.de...@merucabs.com To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ macro to sort excel data email to party Date: Thu, 23 Feb 2012 17:08:26 +0530 Sure point taken... Best Regards, Amit *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *chhajersand...@gmail.com *Sent:* 23 February 2012 10:43 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ macro to sort excel data email to party Dear Amit, Its mean that when ever you send your mail next time set your email priority to normal rather than urgent. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -- *From: *Amit Desai (MERU) amit.de...@merucabs.com *Sender: *excel-macros@googlegroups.com *Date: *Thu, 23 Feb 2012 07:01:40 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *RE: $$Excel-Macros$$ macro to sort excel data email to party Dear All, I am not sure what are the rules to define “high priority”. I am not sure why this was taken other way round. Best Regards, Amit *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *dguillett1 *Sent:* 22 February 2012 18:57 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ macro to sort excel data email to party Why is YOUR request more HIGH PRIORITY than others. Some of us take this differently than you might desire. DELETE. Don Guillett SalesAid Software dguille...@gmail.com *From:* Amit Desai (MERU) amit.de...@merucabs.com *Sent:* Tuesday, February 21, 2012 11:46 PM *To:* excel-macros@googlegroups.com *Subject:* FW: $$Excel-Macros$$ macro to sort excel data email to party Dear All, Please find attached sample file. Following things needs to be done; 1) In first sheet there are data that needs to be sorted work shop wise. 2) In the second sheet email ids are mentioned where we need to send those sorted data per workshop. Please let me know if we have macro for that. Best Regards, Amit *From:* Amit Desai (MERU) [mailto:amit.de...@merucabs.com] *Sent:* 20 February 2012 21:31 *To:* 'excel-macros@googlegroups.com' *Subject:* RE: $$Excel-Macros$$ macro tort excel data email to party Dear All, Please find attached sample file. In first sheet there are data that needs to be sorted work shop wise. In the second sheet email ids are mentioned where we need to send those sorted data per workshop. Please let me know if we have macro for that. Best Regards, Amit *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Maries *Sent:* 20 February 2012 21:05 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ macro for excel data to email *Check these links...* http://www.excelvbamacros.com/2010/07/vba-code-to-send-email-through-excel.html http://www.excelvbamacros.com/2011/06/send-emails-and-attach-filtered-data.html On Mon, Feb 20, 2012 at 7:30 PM, Amit Desai (MERU) amit.de...@merucabs.com wrote: Dear Friends, Is there any macro for sending excel data to emails of different vendors? Best Regards, Amit -- Disclaimer: This message and its attachments contain confidential information and may also contain legally privileged information. This message is intended solely for the named addressee. If you are not the addressee indicated in this message (or authorized to receive for addressee), you may not copy or deliver any part of this message or its attachments to anyone or use any part of this message or its attachments. Rather, you should permanently delete this message and its attachments (and all copies) from your system and kindly notify the sender by reply e-mail. Any content of this message and its attachments that does not relate to the official business of Meru Cab Company Pvt. Ltd. must be taken not to have been sent or
$$Excel-Macros$$ Time capture (NOW)
Dear Excel Gurus, I need help with a formula.. All I need is to do I capture current time, and freeze the same... For eg: if I need to enter the time as 10.01 am using 'NOW' Excel should capture the time as 10.01 and not refresh it, as soon as the system time changes... I know there are alternate options like shift + ; but I need the formula for the same using 'now'... Kindly help if possible.. Thank for your continuous support! Krishnan Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Time capture (NOW)
Change sheet calculation to manual! Sam Mathai Chacko On Fri, Feb 24, 2012 at 11:45 PM, krishnanm2...@gmail.com wrote: Dear Excel Gurus, I need help with a formula.. All I need is to do I capture current time, and freeze the same... For eg: if I need to enter the time as 10.01 am using 'NOW' Excel should capture the time as 10.01 and not refresh it, as soon as the system time changes... I know there are alternate options like shift + ; but I need the formula for the same using 'now'... Kindly help if possible.. Thank for your continuous support! Krishnan Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ how can i convert nomber to test
Hi Jitendraky, Please find the below link for number to text convert macro coding http://www.ozgrid.com/VBA/ValueToWords.htm *Hi Group, it is my suggestion that, before sending any query request you to kindly try to Google it self. * On Thu, Feb 23, 2012 at 9:06 AM, jitendr...@gmail.com wrote: Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees Mail sent via way2sms. http://www.way2sms.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Dialing a Phone Number in Excel??
Hi Joy, please check below link.. http://www.mrexcel.com/archive/VBA/28261.html On Fri, Feb 24, 2012 at 10:38 PM, Ms. Joy joypue...@gmail.com wrote: Someone asked me if I knew how to make Excel dial a phone number??? Has anyone ever heard of this? How would I make this happen? Can someone explain the logic and functionality? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ count group wise
you can use pivot table. On Fri, Feb 24, 2012 at 4:58 PM, raghunandan rallapalli raghunandan.rallapa...@gmail.com wrote: Sir, I mean, its a group wise, counting from FRA+STN wise ,, like in sql (SELECT FRA,STN,COUNT(1) FROM COUNT GROUP BY FRA,STN THANKS WITH REGARDS. RRN On Fri, Feb 24, 2012 at 2:13 PM, Maries talk2mar...@gmail.com wrote: *Explain More... * On Fri, Feb 24, 2012 at 12:15 PM, raghunandan rallapalli raghunandan.rallapa...@gmail.com wrote: Hello Sir, please give me a formula for the attached sheet, FRA AND STN WISE THANKS WITH REGARDS. RAGHU NANDAN R -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Copy of COUNT.xls Description: MS-Excel spreadsheet
$$Excel-Macros$$ Formula for bucket
Dear group, I want to make bucket of age like 0-2,2-4,4-6 etc. However I can do this by if formula. But that is very lanthy formula and also excel 2003 dose not support nested if greater then 7. So can anyone pls help me with any shortest way to do it pls. Regards Pankaj k pandey -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Formula for bucket
Hi Pankaj, You can use Lookup function. please find the example sheet. On Sat, Feb 25, 2012 at 12:57 AM, Secret Shot secrets...@gmail.com wrote: Dear group, I want to make bucket of age like 0-2,2-4,4-6 etc. However I can do this by if formula. But that is very lanthy formula and also excel 2003 dose not support nested if greater then 7. So can anyone pls help me with any shortest way to do it pls. Regards Pankaj k pandey -- 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 lookup.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users
Excellent! I was looking into the belly of the beast to see if I could do that. Another lesson learned. Thank you Don. John On Fri, Feb 24, 2012 at 2:53 PM, dguillett1 dguille...@gmail.com wrote: Thanks for the kind words. I made a bit of improvement to not show a quarter if no values. Don Guillett SalesAid Software dguille...@gmail.com *From:* John A. Smith johnasmit...@gmail.com *Sent:* Friday, February 24, 2012 10:02 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users Don, I spent hours going through that spreadsheet and learned a lot. Thank you for your help and teaching. John On Thu, Feb 23, 2012 at 12:16 PM, dguillett1 dguille...@gmail.com wrote: That’s because the defined name was not referenced in the chart sources. series=smith.xls!definedname Don Guillett SalesAid Software dguille...@gmail.com *From:* John A. Smith johnasmit...@gmail.com *Sent:* Thursday, February 23, 2012 9:25 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Chart Template Dynamic for Different Users Xlstime, I saw that but when I added another product it didn't show up on the chart. John On Thu, Feb 23, 2012 at 10:20 AM, xlstime xlst...@gmail.com wrote: in Name Manager, press alt+i+n+d On Thu, Feb 23, 2012 at 8:47 PM, John A. Smith johnasmit...@gmail.comwrote: Xlstime, Where do I put that formula? John On Thu, Feb 23, 2012 at 10:10 AM, xlstime xlst...@gmail.com wrote: Dear John, Please find the attachment use formula =OFFSET($A$2,0,0,COUNTA($A$2:$A$10),COUNTA($A$2:$F$2)) On Thu, Feb 23, 2012 at 8:13 PM, John A. Smith johnasmit...@gmail.com wrote: I would like to create a template whereby users could add any varialbe of items to track and the chart work for the 5 item user as well as the 9 item user. Please see the attached example. Thank you again for your dedicated help. John -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post
Re: $$Excel-Macros$$ If data is on list sheet move row to correct zone
You mention “paste” sheet which indicates that this is something you copy and paste from ?, it may be better to have an additional column with the zone there and simply filter. More explanation___? What you want can be done using FINDNEXT. Don Guillett SalesAid Software dguille...@gmail.com From: Jason Henke Sent: Thursday, February 23, 2012 6:51 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ If data is on list sheet move row to correct zone Attached is a sample bit of data I'm trying to automatically move rows based on their location in column A on the 'Paste Sheet'. If it matches a Zone list on the 'Location' sheet I'd like it to move there. Also in the location sheet I have a Delete column, I have the macro together to delete matches that works great (also included) This is a bit of sample data and not the full list of locations we have, just hoping to save myself a bit of time when running the report by moving the data where I need it. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Time capture (NOW)
Or, you could use a double click event macro to do a time stamp target=time Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: krishnanm2...@gmail.com Sent: Friday, February 24, 2012 12:15 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Time capture (NOW) Dear Excel Gurus, I need help with a formula.. All I need is to do I capture current time, and freeze the same... For eg: if I need to enter the time as 10.01 am using 'NOW' Excel should capture the time as 10.01 and not refresh it, as soon as the system time changes... I know there are alternate options like shift + ; but I need the formula for the same using 'now'... Kindly help if possible.. Thank for your continuous support! Krishnan Sent on my BlackBerryŽ from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function
what about : {=LARGE(- -($E$1:$E$122=$G1)*$F$1:$F$122,COUNTIF($G$1:$G1,$G1))} ? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function
Hi Johann, That is another example usage of a boolean expression as a criterion. In your example you could actually omit the -- since you are multiplying the expression already. The multiplication will also coerce the boolean to 0 or 1: { =LARGE(($E$1:$E$122=$G1)*$F$1:$F$122,COUNTIF($G$1:$G1,$G1)) } The formula builds an array of 122 elements (the size of the ranges e1:e122 / f1:f122). Each element equals [0 or (1 if E=(thisrow's G))] * [F]. That resolves to an array of 0's and values from column G. That array is then sorted from largest to smallest. Then the CountIf is calculated: The CountIf expression counts the number of occurences of [this row's G] in [this and prior row's G values] let's call that count n. Finally, Excel returns the nth value from the sorted array. _EFG formula evaluation _ 2 100 1 large({0,0,150,0,0,180,0,0,50},1) = large({180,150,50,..},1) = 180 4 200 4 large({0,200,0,0,220,0,0,130,0},1) = large({220,200,130,..},1) = 220 1 150 2 large({100,0,0,250,0,0,75,0,0},1) = large({250,100,75,..},1) = 250 2 250 4 large({0,200,0,0,220,0,0,130,0},2) = large({220,200,130,..},2) = 200 4 220 1 large({0,0,150,0,0,180,0,0,50},2) = large({180,150,50,..},2) = 150 1 180 2 large({100,0,0,250,0,0,75,0,0},2) = large({250,100,75,..},2) = 100 275 1 large({0,0,150,0,0,180,0,0,50},3) = large({180,150,50,..},3) = 50 4 130 4 large({0,200,0,0,220,0,0,130,0},3) = large({220,200,130,..},3) = 130 150 1 large({0,0,150,0,0,180,0,0,50},4) = large({180,150,50,0,..},4) = 0 ... My brain is kind of tired and I'm not sure exactly sure what the overall function of your formula is at the moment though :) Asa -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of johann Sent: Friday, February 24, 2012 12:49 PM To: MS EXCEL AND VBA MACROS Subject: Re: $$Excel-Macros$$ Meaning of minus minus or -- in an Excel function what about : {=LARGE(- -($E$1:$E$122=$G1)*$F$1:$F$122,COUNTIF($G$1:$G1,$G1))} ? -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to mailto:excel-macros@googlegroups.com excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
$$Excel-Macros$$ Toolbar
Hi Xl2000 I want to add some macros to the existing'Tools' toolbar. Have looked at several on the net. JKP, Contextures, Vbax, etc. They seem to use mainly a floating toolbar. I just want to run a macro that says - Add this macro (from a list showing in current workbook) onto the 'Tools' toolbar, and maybe a 'Delete' from tools toolbar. Anyone know of a suitable code online. Thanks and regards Charlie Harris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Time capture (NOW)
Sorry to come back on this I cannot use a macro for this one I need a formula Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: dguillett1 dguille...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 24 Feb 2012 14:25:31 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Time capture (NOW) Or, you could use a double click event macro to do a time stamp target=time Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: krishnanm2...@gmail.com Sent: Friday, February 24, 2012 12:15 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Time capture (NOW) Dear Excel Gurus, I need help with a formula.. All I need is to do I capture current time, and freeze the same... For eg: if I need to enter the time as 10.01 am using 'NOW' Excel should capture the time as 10.01 and not refresh it, as soon as the system time changes... I know there are alternate options like shift + ; but I need the formula for the same using 'now'... Kindly help if possible.. Thank for your continuous support! Krishnan Sent on my BlackBerryŽ from Vodafone -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Formula for bucket
Hi, Try it.. *=VLOOKUP(A1,{0,0-2;3,2-4;5,4-6;7,6+},2,TRUE)* ** *=LOOKUP(A1,{0;3;5;7},{0-2;2-4;4-6;6+})* Regards, MARIES. On Fri, Feb 24, 2012 at 11:31 PM, xlstime xlst...@gmail.com wrote: Hi Pankaj, You can use Lookup function. please find the example sheet. On Sat, Feb 25, 2012 at 12:57 AM, Secret Shot secrets...@gmail.comwrote: Dear group, I want to make bucket of age like 0-2,2-4,4-6 etc. However I can do this by if formula. But that is very lanthy formula and also excel 2003 dose not support nested if greater then 7. So can anyone pls help me with any shortest way to do it pls. Regards Pankaj k pandey -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- . -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ how can i convert nomber to test
On Thu, Feb 23, 2012 at 9:06 AM, jitendr...@gmail.com wrote: Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees Mail sent via way2sms. http://www.way2sms.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 currency to word.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ plz check and help on the attached sheet the Call Macro to combine the macros is not working...
Hi You need to make the names of the macros in the call routine the same as the name in the Tools/Macro list. That is Fill1, Fill2 etc and not Macro1, Macro2 etc On Sat, Feb 25, 2012 at 8:00 PM, Mohammed Muneer mmun...@ccc.com.qa wrote: ** -- 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