Name manager is used to Assign a Name to a Range on worksheets
After define a name you can refer that range by that Name you assigned
1) Press Ctrl+F3
2) Alt+N (New)
3) Fill the Name
4) Select the Scope
5) Select the Range
If Your Define a name rngMyRange
Hi,
By using names, you can make your formulas much easier to understand
and maintain. You can define a name for a cell range, function,
constant, or table. Once you adopt the practice of using names in your
workbook, you can easily update, audit, and manage these names.
Regards,
Lalit Mohan
Homework?
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Saturday, May 12, 2012 12:05 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Name Manager
Hi,
I want to know about Name Manager.. .. what is the use of Name
Dear experts!
the are two names i used and apply this formula using a wild card
=COUNTIF(C20:C21,*a*) its gives me answer 2 instead of 5 because in
the given data there are 5 a instead of 2.
ali a
daniyal a
so any one could explain me why it is given 2 instead of
Dear,
Countif checks only the first instance of the value to be found.
On Sat, May 12, 2012 at 6:35 PM, danial mansoor danial_...@hotmail.comwrote:
Dear experts!
the are two names i used and apply this formula using a wild card
=COUNTIF(C20:C21,*a*) its gives me answer 2 instead of 5
This is very possible with an indirect formula or defined names or with a
macro. Provide a file and your desires.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Shekhar Sharma
Sent: Friday, May 11, 2012 4:59 AM
To: excel-macros@googlegroups.com
Subject:
Formula to count how many times a particular character appear in a cell
is =LEN(A1)-LEN(SUBSTITUTE(A1,a,))
I am trying to find how to find such count for a range.
On Sat, May 12, 2012 at 6:35 PM, danial mansoor danial_...@hotmail.comwrote:
Dear experts!
the are two names i used and apply
Dear,
Enter the following as an Array Formula (you need to press
Ctrl+Shift+Enter, when you enter the formula)
{=SUM(LEN(A1:A2)-LEN(SUBSTITUTE(A1:A2,a,)))/LEN(a)}
Use the formula evaluation tool to check how it works. Otherwise everyone
is here to help you :)
On Sat, May 12, 2012 at 6:35 PM,
Hi Experts.
I am waiting for your reply.
Regards
Lokesh
On Fri, May 11, 2012 at 9:28 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote:
Hi Rajan,
Yes you have sent, but it's not working.If you dont mind can u please send
me with the solution excel file.
So that i would help me a lot.
Hi
PFA
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Sat, May 12, 2012 at 6:57 PM, Lokesh Loki lokeshsmg2...@gmail.com wrote:
Hi Experts.
I am waiting for your reply.
Regards
Lokesh
On Fri, May 11, 2012 at 9:28 PM, Lokesh Loki lokeshsmg2...@gmail.com
wrote:
Hi Aamir,
You can use SUBTOTAL formula accordingly.
for ex.:
Sum of visible cells :- =SUBTOTAL(A1:A100,109)
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Sat, May 12, 2012 at 8:39 PM, Aamir Shahzad aamirshahza...@gmail.com wrote:
Dear Group,
How to pick the
CLTL+G
ALT+S
K
Enter
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Aamir Shahzad
Sent: 12 May 2012 8:40
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ query
Dear Group,
How
Hi Lalit,
Thanks a lot for sending the resolved query. Now i am able to edit the
other cells when text is running mode.
Thank you very much. Have a great future ahead.
Regards
Lokesh.M
On Sat, May 12, 2012 at 8:45 PM, ╰» ℓαℓιт мσαнη mohan.pande...@gmail.comwrote:
Hi
PFA
Regards,
Lalit
pick the values by vlookup or sumif only on visible cells.
On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
CLTL+G
ALT+S
K
Enter
* *
*Regards*
*Rajan verma*
*+91 7838100659 [IM-Gtalk]*
*From:* excel-macros@googlegroups.com [mailto:
Hi Yogananda
I test this file so many times but didn't get this kind of situation,
so please whenever you get this situation then send me the file with
the explanation.
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Fri, May 11, 2012 at 11:06 PM, yogananda muthaiah
Your desire is not clear. Provide a file with a complete explanation and
examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 12, 2012 10:31 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ query
pick the
Example file is attached.
On Sat, May 12, 2012 at 9:04 PM, dguillett1 dguille...@gmail.com wrote:
Your desire is not clear. Provide a file with a complete explanation
and examples.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
*From:* Aamir Shahzad
=SUMPRODUCT(SUBTOTAL(3,OFFSET($H$11:$H$100,ROW($H$11:$H$100)-MIN(ROW($H$11:$H$100)),,1)),--($H$11:$H$100=A2),--($I$11:$I$100))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 12, 2012 12:31 PM
To:
Hi Aamir,
You can use
=SUMPRODUCT(SUBTOTAL(9,OFFSET($I$10,ROW($I$11:$I$100)-ROW($I$10),)),--($A2=$
H$11:$H$100))
in C2 and copy down.
It will work for a filtered list like SUMIF. change the SUBTOTAL type from
9 to 109 to have it ignore rows that are manually hidden as well. Best not
to
Sub Sheet1Multiplecopy()
Dim s1 as worksheet, n as long, c as long
c = worksheets.count
set s1=worksheets(1)
For n = msgbox(How many sheets do you want to add?) to 1 step -1
s1.Copy After:=s1
ActiveSheet.Name = n
Next
s1.select
End Sub
From:
OOps, typos --
Sub Sheet1Multiplecopy()
Dim s1 as worksheet, n as long
set s1=worksheets(1)
For n = msgbox(How many sheets do you want to add?) to 1 step -1
s1.Copy After:=s1
ActiveSheet.Name = n
Next
s1.select
End Sub
From: Asa Rossoff
Sub Sheet1Multiplecopy()
Dim i As Long
For i = 1 To InputBox(howmany)
Sheets(Sheet1).Copy After:=Sheets(i)
ActiveSheet.Name = i
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Aamir Shahzad
Sent: Saturday, May 12, 2012 2:40 PM
To:
Dear Mansoor,
Please use it
=COUNTIF(A1:A2,* a*)
On Sat, May 12, 2012 at 6:35 PM, danial mansoor danial_...@hotmail.comwrote:
Dear experts!
the are two names i used and apply this formula using a wild card
=COUNTIF(C20:C21,*a*) its gives me answer 2 instead of 5 because in the
given data
Dear Aamir
You can use this also..
Sub Sheet1Multiplecopy()
Dim noOfSheet As Long
Dim strTEmp As String
Dim lngLoop As Long
On Error Resume Next
strTEmp = InputBox(Enter no of Sheets:-, Sheet Number)
On Error GoTo 0: On
Dear Sir,
Thanks for your support it working fine.
Once again thank you.
Thanks Regards,
Prajakt Pande
+971551388482
**
On Wed, May 9, 2012 at 10:33 PM, dguillett1 dguille...@gmail.com wrote:
This does each number in col R only ONCE.
Don Guillett
Microsoft MVP Excel
SalesAid
Try this:
Public StartTIme
Public EndTime
Public ResTime As String
Sub StartTimer()
MsgBox Time Start Now
StartTIme = Time
End Sub
Sub EndTimer()
EndTime = Time
ResTime = Format(StartTIme - EndTime, hh:mm:ss)
MsgBox Total
26 matches
Mail list logo