Re: $$Excel-Macros$$ Best thing?

2012-10-12 Thread krishnanm2006
Good question Rajan!! Expecting quite a lot of creative answers for this one ! Sent on my BlackBerry® from Vodafone -Original Message- From: "Rajan_Verma" Sender: excel-macros@googlegroups.com Date: Sat, 13 Oct 2012 00:21:15 To: Reply-To: excel-macros@googlegroups.com Subject: $$Exce

Re: $$Excel-Macros$$ Fun with Chart

2012-10-10 Thread krishnanm2006
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 Sender: excel-macros@googlegroups.com Date: Wed, 10 Oct 2012 23:42:58 To: Reply-To: excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Formulas for predictive analysis and forecasting

2012-09-25 Thread krishnanm2006
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

$$Excel-Macros$$ Formulas for predictive analysis and forecasting

2012-09-25 Thread krishnanm2006
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 S

Re: $$Excel-Macros$$ Business analyst

2012-08-22 Thread krishnanm2006
The babok guide that Amit has given is quite helpful! Sent on my BlackBerry® from Vodafone -Original Message- From: Mangesh Vimay Sender: excel-macros@googlegroups.com Date: Wed, 22 Aug 2012 19:28:20 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Business an

Re: $$Excel-Macros$$ Is there a way of running macros in Macintosh?

2012-06-30 Thread krishnanm2006
Thank you Noorian sir ! Very helpful, as always !! Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Tue, 26 Jun 2012 13:32:38 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Is t

$$Excel-Macros$$ Is there a way of running macros in Macintosh?

2012-06-25 Thread krishnanm2006
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

Re: $$Excel-Macros$$ Query (Remove duplicate)

2012-03-19 Thread krishnanm2006
Go to data- remove duplicates Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: Karan Singh Sender: excel-macros@googlegroups.com Date: Mon, 19 Mar 2012 13:07:52 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query (Remove duplicate) Dear Al

Re: $$Excel-Macros$$ Time capture (NOW)

2012-02-24 Thread krishnanm2006
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" Sender: excel-macros@googlegroups.com Date: Fri, 24 Feb 2012 14:25:31 To: Reply-To: excel-macros@googlegroups.c

$$Excel-Macros$$ Time capture (NOW)

2012-02-24 Thread krishnanm2006
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 a

Re: $$Excel-Macros$$ Most Helpful Member Jan'12 - Noorain Ansari

2012-02-01 Thread krishnanm2006
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: Reply-To: excel-macros@googlegroups.com Cc: NOORAIN ANSARI Subject: Re

$$Excel-Macros$$ Link to download xlecius full version (with key)

2011-12-09 Thread krishnanm2006
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 alread

Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles

2011-11-30 Thread krishnanm2006
This is exactly what I needed... Thanks a ton Noorian.. :) Warm regards! Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Thu, 1 Dec 2011 10:59:27 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-M

Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles

2011-11-30 Thread krishnanm2006
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: Reply-To: krishnanm2...@gmail.com Subject: Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles Dear experts, any news

Re: $$Excel-Macros$$ Link for complex excel 2007 puzzles

2011-11-30 Thread krishnanm2006
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: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Link for complex

$$Excel-Macros$$ Link for complex excel 2007 puzzles

2011-11-29 Thread krishnanm2006
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 Blac

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread krishnanm2006
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 Sender: excel-macros@googlegroups.com Date: Fri, 25 Nov 2011 11:21:27 To: Reply-To: excel-macros@googleg

Re: $$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread krishnanm2006
Awesome... Thanks buddy :) Sent on my BlackBerry® from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Fri, 25 Nov 2011 11:21:04 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Convert text to date using formula...

$$Excel-Macros$$ Convert text to date using formula...

2011-11-24 Thread krishnanm2006
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 Hel

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread krishnanm2006
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" Sender: excel-macros@googlegroups.com Date: Fri, 25 Nov 2011 10:58:29 To: Reply-To:

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-24 Thread krishnanm2006
Andheri east Sent on my BlackBerry® from Vodafone -Original Message- From: mangesh bavalekar Sender: excel-macros@googlegroups.com Date: Thu, 24 Nov 2011 14:16:44 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel learning Institute where I can learn adv

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-23 Thread krishnanm2006
Sorry buddy... I know tutors in Mumbai.. Sent on my BlackBerry® from Vodafone -Original Message- From: Ankit Agrawal Sender: excel-macros@googlegroups.com Date: Thu, 24 Nov 2011 12:20:15 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Excel learning Institute

Re: $$Excel-Macros$$ Excel learning Institute

2011-11-23 Thread krishnanm2006
Where are you located?? Sent on my BlackBerry® from Vodafone -Original Message- From: Ankit Agrawal Sender: excel-macros@googlegroups.com Date: Thu, 24 Nov 2011 12:16:11 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel learning Institute Dear Al

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

2011-11-20 Thread krishnanm2006
Awesome... Thanks Noorian Best Regards! Sent on my BlackBerryŽ from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Mon, 21 Nov 2011 12:35:25 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Lookup for a cell betwee

Re: $$Excel-Macros$$ Re: Need help with screen tip

2011-11-08 Thread krishnanm2006
Sam thanks so much for the response... Would you pls let me know if I can link screen tips to a particular cell?? In a nutshell what I am trying to say is, my data will change every month and I need something by which my screen tips will change month on month... Kindly let me know.. Thanks for

Re: $$Excel-Macros$$ Re: Need help with screen tip

2011-11-08 Thread krishnanm2006
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: Reply-To: excel-macros@googleg

$$Excel-Macros$$ Re: Need help with screen tip

2011-11-07 Thread krishnanm2006
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: Reply-To: krishnanm2...@gmail.com Subject: Need help with screen tip All - I need some help with screen tips... Basical

$$Excel-Macros$$ Need help with screen tip

2011-11-07 Thread krishnanm2006
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 BlackB

Re: $$Excel-Macros$$ formula for diff. in string

2011-11-03 Thread krishnanm2006
To make it more simple try A1=B1 Sent on my BlackBerryŽ from Vodafone -Original Message- From: NOORAIN ANSARI Sender: excel-macros@googlegroups.com Date: Thu, 3 Nov 2011 20:50:01 To: Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ formula for diff. in string Dea