Re: $$Excel-Macros$$ Best thing?
Good question Rajan!! Expecting quite a lot of creative answers for this one ! Sent on my BlackBerry® from Vodafone -Original Message- From: Rajan_Verma rajanverma1...@gmail.com Sender: excel-macros@googlegroups.com Date: Sat, 13 Oct 2012 00:21:15 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Best thing? What is the best thing you do/Can do with Excel? Regards Rajan verma +91 7838100659 [IM-Gtalk] -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Fun with Chart
Excellent piece of work ! Hats off to our gurus Noorian and Rajan ;) Happy learning! Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 10 Oct 2012 23:42:58 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fun with Chart One more addition...in Rajan's series See attachment it is also more funny.. On Wed, Oct 10, 2012 at 10:05 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Awesome !!! Aisa bhi hota hai Excel mein ...??? Surprise !!! On 10/10/12, Ahmed Honest ahmedhon...@gmail.com wrote: Dear Rajan, Salute for your Support and Talent. Will it not be better to enlight us with your skills by having a list of topic to educate the group from that list one by one, so that we become more productive in our daily life work. For sure, I believe you too believe that Sharing Knowledge always expands and teaches you looot of experience... (My understanding is that someone like you should come up and do this initiative so that people expand and think beyond imagination to improve and for learners it will be a DAMN think out of box support). Think of this initiative if you can help us... Anyways, thanks again for your Support and Talent. Best Regars Ahmed Bawazir On Wed, Oct 10, 2012 at 7:16 PM, Rajan_Verma rajanverma1...@gmail.comwrote: * * *Just sharing fun with charts.* * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Ahmed Bawazir *احمد باوزير* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You
$$Excel-Macros$$ Formulas for predictive analysis and forecasting
Dear Excel Gurus ! Hope you guys are doing well... I required some formulas/ functions that can be used for predictive/ forecasting models... Currently I am using slope (linest) and intercept.. But require another formula which can make my analysis more perfect... Thanks in advance ! Krishnan Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com.
Re: $$Excel-Macros$$ Formulas for predictive analysis and forecasting
David, first of all thank you for taking time in writing this wonderful explanation. It does help a lot! The motive behind using the expression make my analysis more perfect can be better explained in the following example.. Let's consider a weekly volume trend and just as an example let's assume that the volumes trends down every alternate week Now if we see the predictive model, for the coming weeks the volume should trend the same way i.e downward every alternate week.. However its showing the other way round,which is possible but not 100% accurate. Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: David Grugeon da...@grugeon.com.au Sender: excel-macros@googlegroups.com Date: Wed, 26 Sep 2012 09:34:10 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Formulas for predictive analysis and forecasting This is not my area of expertise but I will give you a few pointers. There are probably statisticians in the group who can improve, or may disagree with what I am saying. It depends what you are predicting. You need to understand the data and the theatre in which you are observing them. If possible you need to understand what the drivers are and model the impact the drivers have on the output. Sometimes you are dealing with a complex system such as a perfect market which has a substantial quantity of independent and , in themselves unpredictable, drivers. Stock and currency markets are good examples of such a theatre. In this case there may be some characteristic patterns which are the result, not of the external drivers, but of the behaviour of the players (human or computer) in the market. These can be observed and modelled but random events can result in different activity. There are many books about this and some people claim to make money using purely charts and ignoring the fundamentals. Other statistical predictions such as life expectancy, business profits, etc are more closely associated with the relevant drivers and a modelling approach may be more useful than a purely statistical approach. You are using linefitting which assumes a linear trend.It may be appropriate but your data may be trending more closely to a non-lineal curve. For example inflation has over the long term remained at around 3.5%. While this can be shown by a straight line on a chart of year-on-year inflation rates, plotting prices results in an exponential curve. To calculate and predict this you either model the rate of change and incorporate this into output(price) calculations or you use a function such as Logest on the price data. You use the expression make my analysis more perfect. I would say that there are very few situations in real life when a statistical prediction can be perfect. The best you can expect is that you will get nearer to predicting actual outcomes. If you do a search on Google for Excel statistical predictions you will find there are also many more advanced statistical packages which can be used with excel. The drawback is that most of them cost $$. Sorry - a lot of waffle - hope it helps. Regards David Grugeon On 26 September 2012 03:09, krishnanm2...@gmail.com wrote: Dear Excel Gurus ! Hope you guys are doing well... I required some formulas/ functions that can be used for predictive/ forecasting models... Currently I am using slope (linest) and intercept.. But require another formula which can make my analysis more perfect... Thanks in advance ! Krishnan Sent on my BlackBerry® from Vodafone -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,
Re: $$Excel-Macros$$ Business analyst
The babok guide that Amit has given is quite helpful! Sent on my BlackBerry® from Vodafone -Original Message- From: Mangesh Vimay mangesh.da...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 22 Aug 2012 19:28:20 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Business analyst Hi Friends, Can you provide me same kind of Books on Data Analysis by using Excel 2007/2010. Thanks On Sun, Aug 19, 2012 at 2:50 PM, Amit Desai (MERU) amit.de...@merucabs.comwrote: Check the below link, the same covers latest book BABOK version 2 (Business Analyst Body of Knowledge) by IIBA. ** ** http://www.babokonline.org/ ** ** Best Regards, Amit ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *xlstime *Sent:* 18 August 2012 09:08 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Business analyst ** ** Dear All, Good morning to all !!! Can you send me the Business analyst tools or helping book/material for learn about Business analyst Thanks in advance Regards, XLS S -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- 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 endorsed by any of them. Email communications are not private and no warranty is made that e-mail communications are timely, secure or free from computer virus or other defect. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the
Re: $$Excel-Macros$$ Is there a way of running macros in Macintosh?
Thank you Noorian sir ! Very helpful, as always !! Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Tue, 26 Jun 2012 13:32:38 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Is there a way of running macros in Macintosh? Dear Krishnan, Please check below link, hope it will help to you. http://excelsemipro.com/2010/11/excel-2011-for-mac-installation-preferences-and-vba/ -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 26, 2012 at 10:49 AM, krishnanm2...@gmail.com wrote: Dear excel gurus, quick question for you. I need to run excel macros in a macintosh system, as far as I know libra is the default productivity software in mac and it supports open office as well. Is there a way to run vba macros in libra and/ or open office? Pls advise. Best Regards, 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Is there a way of running macros in Macintosh?
Dear excel gurus, quick question for you. I need to run excel macros in a macintosh system, as far as I know libra is the default productivity software in mac and it supports open office as well. Is there a way to run vba macros in libra and/ or open office? Pls advise. Best Regards, 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Query (Remove duplicate)
Go to data- remove duplicates Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: Karan Singh karan1...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 19 Mar 2012 13:07:52 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query (Remove duplicate) Dear All, I need you assistance, I want to remove duplicate value from column A to B. I'v attached the test file. Kindly help me in this. Kaяan http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237 https://plus.google.com/43524614789164919/posts -- 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$$ 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)
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$$ Most Helpful Member Jan'12 - Noorain Ansari
Congrats Noorian !! Keep the flag flying !! Regards, Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 16:48:37 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARInoorain.ans...@gmail.com Subject: Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari Congrats NOORAIN ANSARI Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: xlstime xlst...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 1 Feb 2012 22:17:19 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARInoorain.ans...@gmail.com Subject: Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari Congratulation Brother !! On Wed, Feb 1, 2012 at 10:11 PM, Ayush Jain jainayus...@gmail.com wrote: Hello Everyone, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Jan'12 He has posted 175 posts in Jan'12 and helped many people through his expertise. He has been consistent contributor to this excel forum but has acheived this recognition for first time. *About Noorain Ansari :* [image: noorain.jpg] Noorain is a great poet and keep sharing his thoughts on different topics throgh cool poems. Professionally, he is a Excel aficionado and presently working as senior business analyst in One97 Communication Ltd. He is a MS excel - vba expert and keep sharing his thoughts with this forum. You can follow his blogs for Excel knowledge and cool poems : www.excel-macro.blogspot.com www.noorain-ansari.blogspot.com *Noorain, Many thanks for all your great support to group. Keep it up* *Thanks to Rajan Verma, Sam, Don Guillett, Kris, Bheema, Venkat, Chandru , Priyanka, Lokesh and other folks for helping excel enthusiasts voluntarily !! Keep it up !! ** *Keep posting. Regards Ayush Jain Group Manager Microsoft MVP -- 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
$$Excel-Macros$$ Link to download xlecius full version (with key)
Dear Excel Gurus, Does anyone have the link/torrent to download xlecius full + free version? I checked various sites, but all are providing xlecius paid version. Any help with this is greatly appreciated! Thanks, Krishnan Sent on my BlackBerry® from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles
Dear experts, any news on this? Warm regards Sent on my BlackBerry® from Vodafone -Original Message- From: krishnanm2...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 30 Nov 2011 05:51:49 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Link for complex excel 2007 puzzles Dear Excel Gurus, Does any one have links for sites/blogs which have challenging puzzles/ quiz related to excel 2007... I searched google, all the existing sites have simple excel puzzles.. Appreciate if you can provide the link at your earliest.. Thanks in advance. Krishnan Sent on my BlackBerry® from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles
Dear all, still waiting for an update... Sent on my BlackBerry® from Vodafone -Original Message- From: krishnanm2...@gmail.com Date: Wed, 30 Nov 2011 16:10:13 To: excel-macros@googlegroups.com Reply-To: krishnanm2...@gmail.com Subject: Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles Dear experts, any news on this? Warm regards Sent on my BlackBerry® from Vodafone -Original Message- From: krishnanm2...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 30 Nov 2011 05:51:49 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Link for complex excel 2007 puzzles Dear Excel Gurus, Does any one have links for sites/blogs which have challenging puzzles/ quiz related to excel 2007... I searched google, all the existing sites have simple excel puzzles.. Appreciate if you can provide the link at your earliest.. Thanks in advance. Krishnan Sent on my BlackBerry® from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles
This is exactly what I needed... Thanks a ton Noorian.. :) Warm regards! Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 1 Dec 2011 10:59:27 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles Dear Krishnan, Please use below link for excel Puzzle. http://www.skills-assessment.net/test/frmTestQuestions.aspx?q=1lk=GBOST-GFAIB-GTQWT-KQHMI-AWWLX -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ Thu, Dec 1, 2011 at 10:53 AM, krishnanm2...@gmail.com wrote: Dear all, still waiting for an update... Sent on my BlackBerry® from Vodafone -Original Message- From: krishnanm2...@gmail.com Date: Wed, 30 Nov 2011 16:10:13 To: excel-macros@googlegroups.com Reply-To: krishnanm2...@gmail.com Subject: Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles Dear experts, any news on this? Warm regards Sent on my BlackBerry® from Vodafone -Original Message- From: krishnanm2...@gmail.com Sender: excel-macros@googlegroups.com Date: Wed, 30 Nov 2011 05:51:49 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Link for complex excel 2007 puzzles Dear Excel Gurus, Does any one have links for sites/blogs which have challenging puzzles/ quiz related to excel 2007... I searched google, all the existing sites have simple excel puzzles.. Appreciate if you can provide the link at your earliest.. Thanks in advance. Krishnan Sent on my BlackBerry® from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or
$$Excel-Macros$$ Link for complex excel 2007 puzzles
Dear Excel Gurus, Does any one have links for sites/blogs which have challenging puzzles/ quiz related to excel 2007... I searched google, all the existing sites have simple excel puzzles.. Appreciate if you can provide the link at your earliest.. Thanks in advance. Krishnan Sent on my BlackBerry® from Vodafone -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel learning Institute
Andheri east Sent on my BlackBerry® from Vodafone -Original Message- From: mangesh bavalekar bavalek...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 24 Nov 2011 14:16:44 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel learning Institute where I can learn advance excel.im mumbai ? Mangesh V. B. -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel learning Institute
Hi Noorian- appreciate if you can send it to the entire group... It will be very helpful.. Thanks in advance Warm Regards! Sent on my BlackBerry® from Vodafone -Original Message- From: smitha.kumari smitha.kum...@speridian.com Sender: excel-macros@googlegroups.com Date: Fri, 25 Nov 2011 10:58:29 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Excel learning Institute Hi Noorain, Expecting the Training material at the earliest. Regards Smitha From: smitha.kumari [mailto:smitha.kum...@speridian.com] Sent: Thursday, November 24, 2011 1:32 PM To: 'NOORAIN ANSARI' Subject: RE: $$Excel-Macros$$ Excel learning Institute Thanks a lot Noorain. My mail ID is smitha...@gmail.com or smitha.kum...@speridian.com Regards Smitha/ Senior Finance Executive Speridian%20Logo World Class Solutions to Power Global Businesses Office: 0471-2527525/2700526 smitha.kum...@speridian.com From: NOORAIN ANSARI [mailto:noorain.ans...@gmail.com] Sent: Thursday, November 24, 2011 1:25 PM To: smitha.kumari Subject: Re: $$Excel-Macros$$ Excel learning Institute Sorry, Smitha, I am not giving training online. but I will send you some training material thourgh Email. It will help you to learn Advance excel.. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ http://noorain-ansari.blogspot.com/ On Thu, Nov 24, 2011 at 1:15 PM, smitha.kumari smitha.kum...@speridian.com wrote: I am in Trivandrum. Me too in search of the same. Please suggest me one possible way? Is Noorain giving any online training? Regards Smitha/ Senior Finance Executive 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 seraj.ala...@gmail.com Sent: Thursday, November 24, 2011 12:39 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel learning Institute Hey buddy u can contact to Noorain Ansari the member of this group he is giving training of Excel, VBA, Access on saturdy n sunday in Noida sec- 2 Contact no - 9911176564 Thanks - seraj Sent from BlackBerryR on Airtel _ From: garwads...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 24 Nov 2011 07:00:14 + To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel learning Institute Guys, Any info in Bangalore ? Cheers Rahul. Sent from BlackBerryR on Airtel _ From: krishnanm2...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 24 Nov 2011 06:59:28 + To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel learning Institute Sorry buddy... I know tutors in Mumbai.. Sent on my BlackBerryR from Vodafone _ From: Ankit Agrawal ankit.agrawal...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 24 Nov 2011 12:20:15 +0530 To: excel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel learning Institute I am in Delhi(Near Laxmi Nagar Noida) On Thu, Nov 24, 2011 at 12:22 PM, krishnanm2...@gmail.com wrote: Where are you located?? Sent on my BlackBerryR from Vodafone _ From: Ankit Agrawal ankit.agrawal...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 24 Nov 2011 12:16:11 +0530 To: excel-macrosexcel-macros@googlegroups.com ReplyTo: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel learning Institute Dear All, Plz tell me any good institute for excel where I can learn advance excel. Regards, Ankit -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question
$$Excel-Macros$$ Convert text to date using formula...
All, Is there a formula which converts text to date? PFA the sample file which I am trying to convert.. Thanks in advance Best regards! -- 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 text to date.xls Description: Binary data
Re: $$Excel-Macros$$ Convert text to date using formula...
Awesome... Thanks buddy :) Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 25 Nov 2011 11:21:04 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert text to date using formula... Dear Krishnann, Press Ctrl+shift+# or use =TEXT(VLOOKUP(A6,A1:B4,2,0),dd/mm/) On Fri, Nov 25, 2011 at 11:18 AM, krishnanm2...@gmail.com wrote: All, Is there a formula which converts text to date? PFA the sample file which I am trying to convert.. Thanks in advance Best regards! -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.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 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Convert text to date using formula...
Sundarvelan thanks for your response.. As per my question I need a FORMULA that converts text to date.. Sent on my BlackBerry® from Vodafone -Original Message- From: Sundarvelan N nsund...@gmail.com Sender: excel-macros@googlegroups.com Date: Fri, 25 Nov 2011 11:21:27 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert text to date using formula... Hi, Just convert the cell to date format Thanks N.Sundarvelan 9600160150 On Fri, Nov 25, 2011 at 11:18 AM, krishnanm2...@gmail.com wrote: All, Is there a formula which converts text to date? PFA the sample file which I am trying to convert.. Thanks in advance Best regards! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel learning Institute
Where are you located?? Sent on my BlackBerry® from Vodafone -Original Message- From: Ankit Agrawal ankit.agrawal...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 24 Nov 2011 12:16:11 To: excel-macrosexcel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel learning Institute Dear All, Plz tell me any good institute for excel where I can learn advance excel. Regards, Ankit -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Excel learning Institute
Sorry buddy... I know tutors in Mumbai.. Sent on my BlackBerry® from Vodafone -Original Message- From: Ankit Agrawal ankit.agrawal...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 24 Nov 2011 12:20:15 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel learning Institute I am in Delhi(Near Laxmi Nagar Noida) On Thu, Nov 24, 2011 at 12:22 PM, krishnanm2...@gmail.com wrote: ** Where are you located?? Sent on my BlackBerry® from Vodafone -- *From: * Ankit Agrawal ankit.agrawal...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Thu, 24 Nov 2011 12:16:11 +0530 *To: *excel-macrosexcel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *$$Excel-Macros$$ Excel learning Institute Dear All, Plz tell me any good institute for excel where I can learn advance excel. Regards, Ankit -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Lookup for a cell between a range of values
Awesome... Thanks Noorian Best Regards! Sent on my BlackBerryŽ from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 21 Nov 2011 12:35:25 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup for a cell between a range of values Dear Krishnan, I hope your query will be solve by =LOOKUP(G3,B3:D11) On Mon, Nov 21, 2011 at 12:22 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Krishnan, Don SAM's solutions are excellent. apart of this you can also use =LOOKUP(2,(1/($B$3:$B$11=G3)),$D$3:$D$11) =INDEX($D$3:$D$11,MATCH(G3,$B$3:$B$11,0)) =OFFSET(D2,MATCH(G3,$B$3:$B$11,0),0) -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Sun, Nov 20, 2011 at 11:13 PM, Krishnan Moorthy krishnanm2...@gmail.com wrote: Dear Excel Gurus, Need your help with a lookup formula. I have some min and max numbers and next to it i have some values (see attached).. Now in column G3 if I enter any number for eg: 650 it should lookup for this value in my range (B3:D11) and it should populate *G *in cell *H3*because 650 comes 601-700 range and the corresponding value for this is *G* I can understand this is very dynamic.. but any help with this is greatly appreciated Thanks in advance.. -- 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 ** http://noorain-ansari.blogspot.com/ -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.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 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Re: Need help with screen tip
All sorry to be a pain... But is there some way that this can be done?? Thanks for all your help. Sent on my BlackBerry® from Vodafone -Original Message- From: krishnanm2...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 7 Nov 2011 03:32:14 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Need help with screen tip All is there a resolution for this?? Krishnan Sent on my BlackBerryŽ from Vodafone -Original Message- From: krishnanm2...@gmail.com Date: Sun, 6 Nov 2011 18:21:31 To: excel-macros@googlegroups.com Reply-To: krishnanm2...@gmail.com Subject: Need help with screen tip All - I need some help with screen tips... Basically I have a jpg image in excel and all I want to do is to display some numbers at specific places with my mouse movement... And I do not want a macro for this Is there any way to get it done? Thanks in advance.. Krishnan Sent on my BlackBerryŽ from Vodafone -- 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
$$Excel-Macros$$ Need help with screen tip
All - I need some help with screen tips... Basically I have a jpg image in excel and all I want to do is to display some numbers at specific places with my mouse movement... And I do not want a macro for this Is there any way to get it done? Thanks in advance.. Krishnan Sent on my BlackBerryŽ from Vodafone -- 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
$$Excel-Macros$$ Re: Need help with screen tip
All is there a resolution for this?? Krishnan Sent on my BlackBerryŽ from Vodafone -Original Message- From: krishnanm2...@gmail.com Date: Sun, 6 Nov 2011 18:21:31 To: excel-macros@googlegroups.com Reply-To: krishnanm2...@gmail.com Subject: Need help with screen tip All - I need some help with screen tips... Basically I have a jpg image in excel and all I want to do is to display some numbers at specific places with my mouse movement... And I do not want a macro for this Is there any way to get it done? Thanks in advance.. Krishnan Sent on my BlackBerryŽ from Vodafone -- 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
Re: $$Excel-Macros$$ formula for diff. in string
To make it more simple try A1=B1 Sent on my BlackBerryŽ from Vodafone -Original Message- From: NOORAIN ANSARI noorain.ans...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 3 Nov 2011 20:50:01 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ formula for diff. in string Dear Ankit, For exact match you can use =EXACT(A1,B1) -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Thu, Nov 3, 2011 at 12:15 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Hi Expert, Plz give me any formula for diff in string example- If cell A1 contain Ashish B1 contain Ashish we want to diff in A1 B1 then how we can formulate it Thanks Regards, Ankit -- 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 (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