Hi Chandru,
In a cell eg: A1 use this formula to count total count, where E1 contains
in Data!E3:E640
=SUMPRODUCT(ISNUMBER(SEARCH(E1,Data!E3:E640))*(E1<>""))
Then in A3 with CTRL+SHIFT+ENTER, rather than just ENTER
=IF(ROWS(A$3:A3)<=A$1,INDEX(Data!E:E,SMALL(IF(ISNUMBER(SEARCH(E$1,Data!E$3:E$64
---
Deba Ranjan wants to stay in better touch using some of Google's coolest new
products.
If you already have Gmail or Google Talk, visit:
http://mail.google.com/mail/b-b026c2abc4-b877a6f567-qMCITnhVNZc-CktHu40-cW6TN3U
You'll ne
Hi Dear experts
Can somebody help me to convert amount in word instead of dollars & rupees
I need some other currency like Dirham's, Riyals & Pounds etc
Kindly help in this regard
Gulam Hameed
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of NOOR
Hello Arpita,
A little confusion in the part "=><1/-1"
If you want to SUM all >0 values, you can use
*
=SUMIF(A1:A16,">0",A1:A16)*
If you are looking to SUM between >=-1 to 1 (minus 1 to positive 1), use
*
=SUM(SUMIF(A1:A16,{">=**-**1",">1"},A1:A16)*{1,-1})*
HTH
Haseeb
On Monday, February 27,
Hi Asa,
That's a pretty cool explanaion from you.
And as you said I am having Macro Editor option in my terminal emulation
software. It is in Java script - Reflection for the web.
Do you have any idea on that?
Thanks for your excellent contribution.:-):-):-)
Thanks,
Hariharan T
*Try below code:*
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
ActiveSheet.Range("E1").Select
End Sub
Regards,
MARIES.
On Tue, Feb 28, 2012 at 8:49 AM, NOORAIN ANSARI wrote:
> Dear Ashish,
>
> Select particular cell and press Alt+V+V and add Sheet name
> When and where you required t
Vic Kumar,
Please see the attachent
On Sat, Feb 25, 2012 at 10:53 PM, Vic Kumar wrote:
> Hi,
>
> Please advice i need this same macro for converting figures in words
> for Rupees as this macro is working for Dollars only.
>
> Kindly help in this regard.
>
> Regards,
>
> Vikram
>
>
> On 2/23/1
Dear Vikram,
Please use attached excel sheet for Rupees Format.
Use *=SpellCurr(D5) UDF*
On Sat, Feb 25, 2012 at 10:53 PM, Vic Kumar wrote:
> Hi,
>
> Please advice i need this same macro for converting figures in words
> for Rupees as this macro is working for Dollars only.
>
> Kindly help in t
Hi Arpita,
You can also use..
SUMPRODUCT((A1:A16>0)*(A1:A16))
On Mon, Feb 27, 2012 at 6:02 PM, Arpita kapoor wrote:
> Hi,
>
> Can anyone please help me with a simple formula for the below data set.
> All I need is to a sum of all the figures (+/-) except for those which are
> =><1/-1
>
>0.
Hi,
*Use Macro Recording option.*
With help of recorded macro codes, We will come to know File path, File
Name & File Version... etc.
Then, you share that code to us for modification.
I hope this clarify clear.
Regards,
MARIES.
On Mon, Feb 27, 2012 at 12:49 PM, aryan rajesh wrote:
> HI Exper
Hello Mohammed,
Not without using VBA.
Several people have asked similar questions recently. It is possible to do
this using VBA macros, but I would suggest using the CTRL-; keyboard
shortcut to enter the current date instead.
A simple formula using DATE() will not work because it will
Hi,
Try below codes in sheet1.
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target.Cells.Count = 1 Then
Dim rng As Range
Set rng = Range("Sheet1!A1:A50")
For i = 1 To 50
With rng
If .Cells(i, 2).Value = "Y" Then
.Cells(i, 1).Value = Date
End If
End With
Next i
End If
Hi,
Try below formula with Ctrl+Shift+Enter.
=SUM(IF(A1:A16>0,A1:A16,0))
Find the attached file.
Regards,
MARIES.
On Mon, Feb 27, 2012 at 4:32 PM, Arpita kapoor wrote:
> =><
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titl
Dear Ashish,
Select particular cell and press Alt+V+V and add Sheet name
When and where you required to go selected cell press again Alt+VV and
select sheet Name
You can go on selected cell.
Hope this is your requirment.
On Tue, Feb 28, 2012 at 10:03 AM, Ashish Bhalara
wrote:
> Dear expert,
>
>
--
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
Please try this
=IF(B1="Y",TODAY(),"")
On Mon, Feb 27, 2012 at 7:55 PM, Mohammed Muneer wrote:
> Dear Friends have a nice day,
>
> ** **
>
> I have a small question.
>
> ** **
>
> For example, I have two cols A and B as shown below one is for date & the
> other have letter “Y”.**
Dear Friends have a nice day,
I have a small question.
For example, I have two cols A and B as shown below one is for date &
the other have letter "Y".
A B
28-feb-2012 Y
Can I do it like this? If I input letter "Y" in the column B I can
Aww :) thank you for your swtness too =)
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of BHAKTI PRABHAKAR
Sent: Friday, February 24, 2012 11:01 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Meaning of minus min
thank you
On Mon, Feb 27, 2012 at 5:57 PM, NOORAIN ANSARI wrote:
> http://www.mrexcel.com/forum/showthread.php?t=354
>
> On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema wrote:
>
>> is it possible to save a particular worksheet of a workbook with a save
>> command button on an userform ?
>>
>> --
Hi Chandra,
I think the "iserror" formula from Sam was not completely converted for
Excel 2003. It still contained "IFERROR" in parts.
This should work. Enter it at cell A5 on the MyOutput sheet and copy to all
the formula cells there. I modified the formula slightly so it will work
unchan
Hi,
Please advice i need this same macro for converting figures in words
for Rupees as this macro is working for Dollars only.
Kindly help in this regard.
Regards,
Vikram
On 2/23/12, jitendr...@gmail.com wrote:
> Hi Team, pl help Ex :- 301 Ans :- Three hundread one rupees
>
>
> Mail sent via
Hi,
Can anyone please help me with a simple formula for the below data set. All I
need is to a sum of all the figures (+/-) except for those which are =><1/-1
0.47
0.40
0.26
1.05
0.21
2.50
0.05
-0.03
-0.07
-0.08
-0.31
-0.48
-0.65
-0.66
-0.80
-11.26
I don't seem to get it, I am s
HI Experts,
I have an opened excel sheet from where I need to run a Macro. I need
this macro to copy data from another excel (which is closed) to a
sheet in the already opened excel. Can some one give me the code for
the same?
Any help will be greatly appreciated.
Thanks in advance..
--
FORUM
please unsubscribe the posts
From: Maries
To: excel-macros@googlegroups.com
Sent: Saturday, February 25, 2012 10:04 PM
Subject: Re: $$Excel-Macros$$ Extract last digit number
My Try:
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
On Sat, Feb 25, 2012
swt asa,
thnxx 4 providing us wid sch clear xplanatns n xmplss..:)
Bhakti
On 2/25/12, Asa Rossoff wrote:
> Hi Johann,
>
> That is another example usage of a boolean expression as a criterion. In
> your example you could actually omit the -- since you are multiplying the
> expression already.
Hi All,
I have a table and one column is entered date.
Example: B1:B500
I want to check all the dates are entered correctly and if there is any
illogical dates within it.
Default date format is mm/dd/..
Please help me... with excel macro to solve this as easier way to find..
Please le
Sam
Awesome as always! Thanks again
On Feb 27, 2012, at 10:30 AM, Sam Mathai Chacko wrote:
> No it isn't, it's just that it's a safe practice Maries
>
> On Mon, Feb 27, 2012 at 8:29 PM, Maries wrote:
> Hi Sam,
>
> Is "Double Minus" required?
>
>
> On Mon, Feb 27, 2012 at 5:47 PM, Sam M
OK Thanks SAM.
On Mon, Feb 27, 2012 at 7:30 PM, Sam Mathai Chacko wrote:
> No it isn't, it's just that it's a safe practice Maries
>
>
> On Mon, Feb 27, 2012 at 8:29 PM, Maries wrote:
>
>> Hi Sam,
>>
>> Is "*Double Minus" *required?
>>
>>
>> On Mon, Feb 27, 2012 at 5:47 PM, Sam Mathai Chacko
No it isn't, it's just that it's a safe practice Maries
On Mon, Feb 27, 2012 at 8:29 PM, Maries wrote:
> Hi Sam,
>
> Is "*Double Minus" *required?
>
>
> On Mon, Feb 27, 2012 at 5:47 PM, Sam Mathai Chacko wrote:
>
>> Hi Lee,
>>
>> =WEEKNUM(--TEXT(A1,"\/00\/00"))
>>
>>
>> http://www.excelfox.c
Another solution
=AND(NOT(SUM(--ISNUMBER(VALUE(MID(A1,ROW(INDIRECT("1:5")),1),SUM(--ISNUMBER(INT(MID(A1,ROW(INDIRECT("6:9")),1=4,NOT(--ISNUMBER(RIGHT(A1,1))),LEN(A1)=10)
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Sam Mathai
Hi Sam,
Is "*Double Minus" *required?
On Mon, Feb 27, 2012 at 5:47 PM, Sam Mathai Chacko wrote:
> Hi Lee,
>
> =WEEKNUM(--TEXT(A1,"\/00\/00"))
>
>
> http://www.excelfox.com/forum/f13/convert-text-mmdd-format-date-format-74/
>
> In your case, I'd use
>
> *
> =TEXT(--TEXT(A1,"\/00\/00"
Ah! Quote Haseeb {I think this part ISNUMBER(--MID(A3,6,4)) will allow
entry with 3 spaces before the fourth digit :-) , like}
I think that's a very good catch Haseeb. :)
I think adding an IFERROR(FIND(" ",Range)) will solve the problem.
Regards,
Sam Mathai Chacko
On Mon, Feb 27, 2012 at 12
Hi Lee,
=WEEKNUM(--TEXT(A1,"\/00\/00"))
http://www.excelfox.com/forum/f13/convert-text-mmdd-format-date-format-74/
In your case, I'd use
*
=TEXT(--TEXT(A1,"\/00\/00"),"mmm")&"-W"&WEEKNUM(--TEXT(A1,"\/00\/00"))
* to give *Oct-W41*
Regards,
Sam Mathai Chacko
On Mon, Feb 27, 201
For the position, use
Private Sub UserForm_Activate()
Me.Top = 150
Me.Left = 250
End Sub
adjust it based on your requirement... to make it dynamic for any excel
application or screen size, you'll have to use API
For ISERROR problem in Excel 2003, use
=IF(ISERR(INDEX(Data!$A$3:$A$640,SMA
You have been doing this awhile and should know better. Anyway.
Sub copycorrectsheets()
Dim ws As Worksheet
For Each ws In Worksheets
If ws.Name <> "Summary" _
And ws.Name <> "forms" _
And ws.Name <> "admin" Then
ws.Range("G7").CurrentRegion.Copy _
Worksheets("summary").Cells(Rows.Count, "G").End(x
http://www.mrexcel.com/forum/showthread.php?t=354
On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema wrote:
> is it possible to save a particular worksheet of a workbook with a save
> command button on an userform ?
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise
For workbook -
ActiveWorkbook.Save
For active sheet only -
ActiveSheet.Select
ActiveSheet.Copy
ActiveSheet.SaveAs Filename:="YOUR DIR" & YOUR FILENAME & ".xls"
HTH
Abhishek
On Mon, Feb 27, 2012 at 5:00 PM, Shankar Bheema wrote:
> is it possible to save a particular worksheet of a workbook w
is it possible to save a particular worksheet of a workbook with a save
command button on an userform ?
--
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
Dear Deba,
Please send your query in seprate mail instead of Thread mail.
On Mon, Feb 27, 2012 at 4:21 PM, Deba Ranjan wrote:
> *Hi Expert,
>
> Please create a automatic pivot table by help of marcos in urgent basis.
> Please .
> *
>
>
>
>
> *Regards*
>
> *Deba Ranjan P**
> *
> *[image:
You can download xlfdic from google
On 2/27/12, Manoj Kumar wrote:
> thanks to all its very usefull for me..
>
> On 1/17/12, NOORAIN ANSARI wrote:
>> Most Welcome Darwin..
>>
>> On Tue, Jan 17, 2012 at 9:59 AM, Darwin Chan
>> wrote:
>>
>>> Thanks for Noorain reading notes, some tricks i even
thanks to all its very usefull for me..
On 1/17/12, NOORAIN ANSARI wrote:
> Most Welcome Darwin..
>
> On Tue, Jan 17, 2012 at 9:59 AM, Darwin Chan
> wrote:
>
>> Thanks for Noorain reading notes, some tricks i even dun know.
>>
>>
>> 2012/1/17 NOORAIN ANSARI
>>
>>> Dear Manoj,
>>>
>>> Please
Dear Muneer
Explain your problem in the body of the mail instead of subject
and kindly also let us know one output example for your requirement
On Mon, Feb 27, 2012 at 3:28 PM, Mohammed Muneer wrote:
> **
>
>
>
> Regards,
> Muneer,
> CC
>
> --
> FORUM RULES (986+ members already BANNED fo
Awesom Logic Haseeb...
On Mon, Feb 27, 2012 at 8:19 AM, Haseeb Avarakkan <
haseeb.avarak...@gmail.com> wrote:
> Hi Lee, try
>
> For the Week,
>
> =WEEKNUM(TEXT(A1,"\-00\-00"))
>
> For the month,
>
> =TEXT(TEXT(A1,"\-00\-00"),"")
>
> HTH
> Haseeb
>
> --
> FORUM RULES (986+ members
http://www.phonedialerpro.com/#Excel
On Fri, Feb 24, 2012 at 10:38 PM, Ms. Joy wrote:
> Someone asked me if I knew how to make Excel dial a phone number???
> Has anyone ever heard of this? How would I make this happen? Can
> someone explain the logic and functionality?
>
> --
> FORUM RULES (986+
44 matches
Mail list logo
