$$Excel-Macros$$ how to draw a graph with two variables on y axis

2010-12-29 Thread Kenil Gala
Hi, i want to a graph which is a combination of two graphs. eg: x axis: date. y axis:rainfall : 800mm,900mm,750mm,925mm,825mm.etc. change with respect to sea lvl: 5mm,8mm,9mm,8.5mmetc. could anyone help me on this? Thanks Regards, Kenil Gala

$$Excel-Macros$$ skewness Kertosis

2011-01-03 Thread Kenil Gala
Hoping for reply. Thanks Regards, Kenil Gala -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group

$$Excel-Macros$$ charts

2011-01-08 Thread Kenil Gala
, but there is no as such option in excel2007, Can any one help me with this problem? Thanks Regards, Kenil Gala -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com

Re: $$Excel-Macros$$ Formula of the week - share your best formula

2011-01-11 Thread Kenil Gala
Hi group, My formulas for the week is 1. normdist = to find the normal distribution of random numbers. 2. FV = To find the future value of the cash flows. 3. stdev = to find the standard deviation of the distribution. Thanks Regards, Kenil Gala From: Ayush

$$Excel-Macros$$ Help required for a formula

2011-11-25 Thread Kenil Gala
Hi group,   I have a small doubt for writing a formula and require for help for it. i have mentioned my doubt as a comment in the attached file.     Thanks Regards   -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like

Re: $$Excel-Macros$$ Help required for a formula

2011-11-25 Thread Kenil Gala
.  Regards, Seema On Fri, Nov 25, 2011 at 7:02 PM, Kenil Gala keni...@yahoo.com wrote: Hi group,   I have a small doubt for writing a formula and require for help for it. i have mentioned my doubt as a comment in the attached file.     Thanks Regards   -- FORUM RULES (934+ members already

Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel

2011-11-28 Thread Kenil Gala
Rename the file. 2003 format :  .xls 2007 format :   .xlsx --- On Mon, 11/28/11, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: From: Sanjib Chatterjee chatterjee.kolk...@gmail.com Subject: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel To: excel-macros

$$Excel-Macros$$ pls help me solve my query.

2012-08-03 Thread Kenil Gala
hi folks,i am having a query in getting external data,pls help me for the same.i have written my query in the excel sheet. Thanks in adv, Regards, -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent,

Re: $$Excel-Macros$$ query for finding maximum and minimum values

2012-08-14 Thread Kenil Gala
, Kenil Gala keni...@yahoo.com wrote: hi all,   i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query.     Thanks and Regards,   -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel

Re: $$Excel-Macros$$ query for finding maximum and minimum values

2012-08-14 Thread Kenil Gala
PM Should do it   Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com   From: Kenil Gala Sent: Tuesday, August 14, 2012 10:45 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values   Hello sir , i have

$$Excel-Macros$$ Small Query

2012-11-26 Thread Kenil Gala
Hi, Pls help me solve my small doubt. I have written it in the file attached. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

Re: $$Excel-Macros$$ Small Query

2012-11-26 Thread Kenil Gala
at 10:18 PM, Kenil Gala keni...@yahoo.com wrote: Hi, Pls help me solve my small doubt. I have written it in the file attached. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel   FORUM RULES   1) Use concise, accurate thread titles. Poor thread titles, like

$$Excel-Macros$$ Small Date Query

2012-11-27 Thread Kenil Gala
Pls help me solve my query.   I have mentioned my query in the file attached.   Thanks Regards, Kenil Gala -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent

Re: $$Excel-Macros$$ Small Date Query

2012-11-27 Thread Kenil Gala
if it helps On Tue, Nov 27, 2012 at 11:14 PM, Kenil Gala keni...@yahoo.com wrote: Pls help me solve my query.   I have mentioned my query in the file attached.   Thanks Regards, Kenil Gala -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel   FORUM RULES   1

$$Excel-Macros$$ a date query

2012-12-04 Thread Kenil Gala
Hi, Pls help me solve my query.   Pls find the file attached.   Thanks, Kenil -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem,

$$Excel-Macros$$ query for getting external data from a website

2012-12-30 Thread Kenil Gala
Hi, I want data of last 3months of a particular stock from a website. i have link of that website but dont know how to import it.i just want if i change just symbol of that particular script i get the data of that particular script i want. pls find the file attached for details.   Pls help

Re: $$Excel-Macros$$ query for getting external data from a website

2012-12-31 Thread Kenil Gala
:46 PM, Kenil Gala keni...@yahoo.com wrote: Hi, I want data of last 3months of a particular stock from a website. i have link of that website but dont know how to import it.i just want if i change just symbol of that particular script i get the data of that particular script i want. pls find

$$Excel-Macros$$ IF Problem

2013-02-08 Thread Kenil Gala
Hi group, I have a small IF related query.   i want an answer for two logical tests at a same time. Pls chk my file attached.   Thanks in adv. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ Problem in conditional formatting

2013-02-13 Thread Kenil Gala
Hi group, I am facing a small problem in conditional formatting. i am not able to set the same rules for the entire coloum. Pls find the file attached.   Thanks in adv. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page

$$Excel-Macros$$ IF Doubt - Query

2013-02-19 Thread Kenil Gala
Hi group, Pls help. I have a small query for solving IF Function.i want the the answer which is in between the two given values. Pls HelpThanks in adv. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this

Fw: Re: $$Excel-Macros$$ IF Doubt - Query

2013-02-19 Thread Kenil Gala
:27 AM Your query is not very clear. Could you be a little more specific? Thanks, On Wed, Feb 20, 2013 at 10:11 AM, Kenil Gala keni...@yahoo.com wrote: Hi group, Pls help. I have a small query for solving IF Function.i want the the answer which is in between the two given values. Pls

$$Excel-Macros$$ Telephone directory template

2013-03-06 Thread Kenil Gala
Hi group,DO ant one have a telephone directory template where i can save my personal and bussiness phone nos. with some other data like e.mail, DOB, Address etc -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of

$$Excel-Macros$$ Query For VBA

2013-03-10 Thread Kenil Gala
Hi group, I have a small query in VBA, Pls check my file for details,Pls Help Thanks In adv. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use

Re: $$Excel-Macros$$ Date doubt

2013-07-26 Thread Kenil Gala
    findFriday = FindDate End Function On 25/07/2013 21:58, Kenil Gala wrote: Hi friends, i have a query for arranging dates in a pattern. Pls help me solve my query. Thanks in adv. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join

$$Excel-Macros$$ combined formula required.

2013-09-08 Thread Kenil Gala
Hi group, I want a combination of IF and AND formula, or any other other suitable formula for inserting some indicators between fixed set of values. Pls find the file attached. Thanks Regards, -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW)

Re: $$Excel-Macros$$ combined formula required.

2013-09-08 Thread Kenil Gala
  . Enjoy Team XLS On Sun, Sep 8, 2013 at 1:48 PM, Kenil Gala keni...@yahoo.com wrote: Hi group, I want a combination of IF and AND formula, or any other other suitable formula for inserting some indicators between fixed set of values. Pls find the file attached. Thanks Regards

Re: $$Excel-Macros$$ combined formula required.

2013-09-09 Thread Kenil Gala
required. still not clear what is a exact condition for RED,BLUE and yellow for example 5000-5500 RED 5500-600 GREEN . Enjoy Team XLS On Sun, Sep 8, 2013 at 5:30 PM, Kenil Gala keni...@yahoo.com wrote: Hope this helps, Thanks in Adv

$$Excel-Macros$$ small doubt of conditional format and vlookup

2013-09-21 Thread Kenil Gala
hi friends, i have a small doubt for conditional formatting to highlight a date... and a small vlookup formula doubt. pls help. Thanks in adv. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @

$$Excel-Macros$$ Need formula for 2 criterias

2018-02-03 Thread Kenil Gala
Hi Pls Find the file attached. I have written my Query in the excel sheet. Please help me find the solution for this query Thanks Kenil -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @