Dear Stii
Thanks for help
Can u please answer my second question?
Can u insert a customised function in Excel ?If yes how?
shrinivas
Date: Fri, 3 Sep 2010 22:11:41 +0700
Subject: Re: $$Excel-Macros$$ sumif kinda formula needed
From: villager.g...@gmail.com
To: excel-macros@googlegroups.c
I have a sheet that has 2 columns of data. The second sheet has those same
columns and another column. I need the max of sheet 2 col C if:
Sheet 2 col A contains sheet 1 cell A2 AND
Sheet 2 col B contains sheet 1 cell B2.
Sheet 1:
Col A Col B Col C
AB1
Hi
I want to insert multiple sheet. Say 10 sheet and I want to rename
those sheet as per my choice.
That is a window will come and I type my choiceable name then the
sheet is created. If there is any macro code for that please help me.
Thanks
Santanu
--
--
*
Dear All,
I LOVE Excel because " Excel LOVES to SOLVE my problems of calculations "*
*
*
*(Note :* *L**O**V**E**S** *& *S**O**L**V**E used above are anagram*!*)*
*
*
*Regards*
*Sachin N Harale
*
> Guyzzz, Let me know why you like excel so muchThe best response
> > will be published on the h
*
Dear All,
I LOVE Excel because " Excel LOVES to SOLVE my problems of calculations "*
*
*
*(Note :* *L**O**V**E**S** *& *S**O**L**V**E used above *are palindrome too!
*)*
*
*
*Regards*
*Sachin N Harale
*
> > Guyzzz, Let me know why you like excel so muchThe best response
> > will be publishe
I love Excel because "She" is very funny
--
--
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 @ http://www.linked
Yes, DATEDIF is a worksheet function available in Excel
please visit to: http://www.cpearson.com/excel/datedif.aspx
"The DATEDIF function computes the difference between two dates in a variety
of different intervals, such as the number of years, months, or days between
the dates. This function is
Thanks Dave.. for all the support...
Regards
Ashish Koul
akoul.blogspot.com
On Fri, Sep 3, 2010 at 3:43 PM, NOORAIN ANSARI wrote:
> Congratulation Dave for your valuable support.
>
> Keep it up...
>
> Thanks,
> Noorain Ansari
>
> On Fri, Sep 3, 2010 at 10:31 AM, Ayush wrote:
>
>> Hi Group,
>>
try this formula
=MID(CELL("address",Sheet1!A1),FIND("]",CELL("address",Sheet1!A1))+1,99)&"
= "&Sheet1!A1
On Fri, Sep 3, 2010 at 6:08 AM, jjsmd wrote:
>
> Hi:
> I am new to excel and I was wondering hiw I would do the following.
> I have an excel worksheet with names of people in a sheet goin
Dear Group,
Excel is the User friendly Application Compare then all Spread sheets &It's
Very much Easy to Handle New user's Too..
Best Regards,
*
Venkat
*
--
--
Some important links for excel users:
1. Fol
Excel is handy when performing calculations-Rajesh Nair
Forwarded conversation
Subject: $$Excel-Macros$$ Re: I love excel because...
From: *Stuart Redmann*
Date: Mon, Aug 30, 2010 at 5:05 PM
To: MS EXCEL AND VBA MACROS
On 28 Aug., Ayush wrote:
> Its a very handy t
I've repeated this rant several times, but always willing to try do it again!
First of all, is your data an actual Excel "time" or a text string that
"looks" like a "time" ??
To find out, try changing the format of the cell.
if you're showing 20:22:16 and you change the cell format to
h:mm:ss AM
try from menu bar command
Windows -> freeze panes
May this be useful.
Regards,
Kishan Reddy, K
On Sep 3, 4:08 am, jjsmd wrote:
> Hi:
>
> I am new to excel and I was wondering hiw I would do the following.
>
> I have an excel worksheet with names of people in a sheet going from
> column A to X
Hai Dave,
Congrats,
Keep the spirit.
Regards,
Kishan Reddy, K
On Sep 3, 10:01 am, Ayush wrote:
> Hi Group,
>
> I am glad to announce that Dave Bonallack has topped in posting for
> the month of Aug'10 with 67 Posts (9% of group posts). He has done it
> repetitively for two months. Thank you ,
Mr Neil,
You need not write any code for this.
Just open the form in VBA, select the text box1 and right click it,
select properties.
In that
Set Autotab = true
set maxlength = 2
do the same thing for text box2.
Regards,
Kishan Reddy, K
On Sep 2, 1:17 pm, neil johnson wrote:
> Hi Everyone,
Dear siti vi/Group Member
Plesae let me know What is the function DATEDIF ?
Is this function available in Excel?
If not How u insert function in Excel.
Thanks in advance
shrinivas
Date: Fri, 3 Sep 2010 09:29:35 +0700
Subject: Re: $$Excel-Macros$$ sumif kinda formula needed
From: v
Dear Experts,
I need a help...How to protect & hide(Both together) a sheet?
In attached file I need to "RSM" sheet will be password protected & hide, if
anybody wants to unhide the sheet it will ask password, then it will open.
Is it possible?
Thanks in advance
Kalyan
--
Hi John,
Could you send a sample set of data.
Regards,
Andy
On Thu, Sep 2, 2010 at 11:41 PM, JohnA wrote:
> I need to determine time increments from postings in Excel in the 24
> hour mode (commonly called military time).
>
> I can't come up with a formula to give me decimal hours from militar
hi
Does not need it to be in one cell. But would there be a easy way to
get them all on the userform?
On Sep 3, 4:50 am, Bruno Bruno wrote:
> Just for curiosity, do you really want to put all the information in the
> same cell?
> For example, instead of putting in the "this month" cell [*A Swan
Congratulation Dave for your valuable support.
Keep it up...
Thanks,
Noorain Ansari
On Fri, Sep 3, 2010 at 10:31 AM, Ayush wrote:
> Hi Group,
>
> I am glad to announce that Dave Bonallack has topped in posting for
> the month of Aug'10 with 67 Posts (9% of group posts). He has done it
> repeti
20 matches
Mail list logo
