Dear Sir,
If possible can you please send me the example of the formula.
On Wed, Oct 10, 2012 at 11:17 AM, Prince wrote:
> Hi Ashish,
>
> Please use sumifs formula for getting total GROSS and TDS amount for each
> vendor.
>
> Regards
> Prince
>
> On Tuesday, October 9, 2012 1:16:22 PM UTC+5:30,
Dear Vignesh,
Please try it.
Sub send_range_as_table()
'' tools -> refrence -> Microsoft outlook
Dim olApp As Outlook.Application
Dim olMail As MailItem
Dim mailbody As String
mailbody = "" & _
"Rep Name " & _
"Zone " & _
"Location " & _
"Sales
Hi all,
thank you all for your help and time that you spend to solve this problem!
I am very happy with the solution that Ashish attached.
This solution works perfect and I am very happy with it - thank you!
Unfortunately, I forgot to mention something important yesterday ...
I need this fu
Hi Team,
I am looking for macro to compare and highlight,i have given the example
below
two words has been compared
hello and hella
i need" o "and" a" to be higlighted in red
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members alre
Pls see the attachment it is in Sheet 1 and sheet 2 one is for gmail and
second is for yahoo.
On Mon, Oct 8, 2012 at 11:28 PM, Sam Mathai Chacko wrote:
> This is a link by Lalit Mohan, one of the members of this forum
>
>
> http://powerofexcel.wordpress.com/2012/09/12/google-login-automation-thro
Hi,
Pls find attached excel.
Check if it is ok with you.
Regards,
Swapnil.
On Wed, Oct 10, 2012 at 1:41 PM, Henning Deschka wrote:
> Hi all,
>
> thank you all for your help and time that you spend to solve this problem!
> I am very happy with the solution that Ashish attached.
>
> This solut
Dear Excel Guru,
Any formula for removing special character ex (!, -, &,~,?,_,;,',). Please
Help me.
Thanks & Regards,
Sriram G (chennai)
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use conci
attached
On Wed, Oct 10, 2012 at 3:19 PM, अनिल नारायण गवली
wrote:
> Pls see the attachment it is in Sheet 1 and sheet 2 one is for gmail and
> second is for yahoo.
>
>
> On Mon, Oct 8, 2012 at 11:28 PM, Sam Mathai Chacko wrote:
>
>> This is a link by Lalit Mohan, one of the members of this forum
Hello,
Maybe this UDF would be useful for you.
Function RemoveSpChars(s As String) As String
Dim re As Object
'List all allowed characters, but start with the negation "^"
Const sPat As String = "[^A-Z0-9 ]"
'List all characters to be removed, "-" must
' be listed first or last
'Const sPat As S
Hi,
Here is another solution without inserting exta column "Column D".
Don't ask me to explain this formula, because I also don't know how it
works. [?] I get this formula from net and just modified it.
Following is the link from where I get it.
http://www.excelforum.com/excel-formulas-and-funct
Hi Sriram,
Please use the below mentioned formula to remove special charactors.
=SUBSTITUTE(F4,{"#","$","%","&","!","~","_",";",'""},"") With
ctrl+shift+Enter
Note F4 is containing your text.
Regards
Prince
On Wednesday, October 10, 2012 4:02:24 PM UTC+5:30, sriram ji wrote:
>
> Dear Excel
Dear All
Is it possible to use Vlookup with multple conditio. i e.
Can I get the value From Column E if All the column a,b,c,d matches.
Thanks in advance
--
Shrini
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED
Hi Shrini,
Please share a sample worksheet.
Regards,
Kuldeep Singh
On Wed, Oct 10, 2012 at 5:53 PM, Shrinivas Shevde wrote:
> Dear All
>
> Is it possible to use Vlookup with multple conditio. i e.
> Can I get the value From Column E if All the column a,b,c,d matches.
>
> Thanks in advance
>
> -
Hi Team,
Can any one help me on this
On Wednesday, October 10, 2012, pavan Kumar wrote:
> Hi Team,
>
> I am looking for macro to compare and highlight,i have given the example
below
>
> two words has been compared
>
> hello and hella
>
> i need" o "and" a" to be higlighted in red
>
> --
> Join of
Sub test()
Call compare_strings(Range("a1"), Range("b1"), Range("c1"))
End Sub
Sub compare_strings(rng1 As Range, rng2 As Range, rng3 As Range)
Dim i As Long
If Len(rng1.Value) <> Len(rng2.Value) Then
rng3.Value = "Length Mismatch "
Else
For i = 1 To Len(rng1.Value)
Just sharing fun with charts.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like
Dear Rajan,
Salute for your Support and Talent. Will it not be better to enlight us
with your skills by having a list of topic to educate the group from that
list one by one, so that we become more productive in our daily life work.
For sure, I believe you too believe that Sharing Knowledge alway
Hi Sriram,
Use this =SUBSTITUTE(A1,"!","") and you are change to the
special character.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Oct 10, 2012 at 4:02 PM, sriram ji wrote:
> Dear Excel Guru,
>
> Any formula for removing special character ex (!, -, &,~,?,_,;,',). Please
>
Awesome !!!
Aisa bhi hota hai Excel mein ...???
Surprise !!!
On 10/10/12, Ahmed Honest wrote:
> Dear Rajan,
>
> Salute for your Support and Talent. Will it not be better to enlight us
> with your skills by having a list of topic to educate the group from that
> list one by one, so that we becom
Hi experts
I want to learn automation in excel first of all tell me. What is
automation. how I use in excel. Please give any notes and suggestions to
learn. Waiting for reply.
Thanks
Manoj
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+
Hi Shrini,
Find the Attachment.
--
*Regards,*
*
*
*Excel Beginner*
*
*
On Wed, Oct 10, 2012 at 5:53 PM, Shrinivas Shevde wrote:
> Dear All
>
> Is it possible to use Vlookup with multple conditio. i e.
> Can I get the value From Column E if All the column a,b,c,d matches.
>
> Thanks
I have a macro that runs well to update a workbook every month. There are
25 workbooks, so we need to open every one and run the macro. I would like
to have a macro that would open them one-by-one and nun my macro. My macro
could be embedded or launched by this new macro. I know the various
Hi Srinivas,
Please use this.
=SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
Regards,
Kuldeep Singh
On Wed, Oct 10, 2012 at 10:55 PM, >>Excel Beginner<< <
excelbegin...@gmail.com> wrote:
> Hi Shrini,
>
>Find the Attachment.
>
>
> --
> *Regards,*
> *
> *
> *Excel Beginner*
>
Thanks Noorain.
It is very informative and useful. I am trying to learn macro from this.
May i as k to help me in the following scenarion;
1. I have excel work sheet which enlist customer having outstanding dues .
I need to send e mail to these customer on this list twice a day daily .
Attac
Just a quick Example :
1) You are an analyst in Vodafone, you daily receive lot of Customer
application form on your mail in Excel Sheet, and you want to know -
a. how many are from Gurgaon, Delhi,Noida ??
b. How many are Corporate Connection ?
c. Count of different Pla
Actually I don't know about the coding in vba where I can learn coding for
vba. I know only record macro. I want to do coding in my way. What I want
I get it from my data.
Thanks
Manoj
On Oct 10, 2012 11:20 PM, "Rajan_Verma" wrote:
> *Just a quick Example :*
>
> * *
>
> ***1) You are
Here is the first one to help and elighten us
Actually I don't know about the coding in vba where I can learn coding for
vba. I know only record macro. I want to do coding in my way. What I want
I get it from my data.
Thanks
Manoj
On Oct 10, 2012 11:20 PM, "Rajan_Verma" wrote:
> *Just a q
May i ask to help me in the following scenario;
1. I have excel work sheet which enlist customer having outstanding dues .
I need to send e mail to these customer on this list twice a day daily .
Attached excel have sample of records.
Is it possible to do it through macro . That is to Send ma
Thanks to all
Great Help
Thanks once again
Regards
Shrinivas
On Wed, Oct 10, 2012 at 11:13 PM, Kuldeep Singh wrote:
>
> Hi Srinivas,
>
> Please use this.
>
> =SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
>
> Regards,
> Kuldeep Singh
>
>
> On Wed, Oct 10, 2012 at 10:55 PM, >>Excel Beginn
Dear Noorain/Rajan,
This too was really nice
Can you or someone create a Meditation Chakra? That could be use for Meditation
on Full screen!
I am this will not be difficult for you masters...Also please share how did you
prepared this Owe some creative graphics..
Best Regards,
Amit
From:
Dear Shrinivas,
You can try it..
With Additional column it is possible through vlookup
=VLOOKUP(CONCATENATE(H3,I3,J3,K3),$A$2:$F$5,6,0)
Or
=INDEX($E$2:$E$5,MATCH(1,($A$2:$A$5=G3)*($B$2:$B$5=H3)*($C$2:$C$5=I3)*($D$2:$D$5=J3),0))
with cse
or
=LOOKUP(9E+300,1/(($A$2:$A$5=$G$3)*($B$2:$B$5=$H$3)*
Dear Sriram,
Please try it..
Sub NTest()
Dim a$, b$, c$
Dim i%
a$ = Range("A1").Value
For i = 1 To Len(a$)
b$ = Mid(a$, i, 1)
If b$ Like "[A-Z,a-z,0-9 ]" Then
c$ = c$ & b$
End If
Next i
Range("B1").Value = c$
End Sub
On Wed, Oct 10,
In addition to the below post, you cannot use Sumproduct to get the Text
Data as result.
<><><><><><><>
*Ms-Exl-Learner*
<><><><><><><>
On 10-10-2012 11:13 PM, Kuldeep Singh wrote:
Hi Srinivas,
Please use this.
=SUMPRODUCT((A:A=G3)*(B:B=H3)*(C:C=I3)*(D:D=J3)*(E:E))
Regards,
Kuldeep Sing
Hi,
Can you help me write a macro that will type a custom function I created
into a cell? For example, I want the macro to type the following function:
=Switch2(Y2,"B", AH2,"H",NOT(AH2),"O")
inside cell AP2
Thanks in advance for your help.
Greg
--
Join official facebook page of this forum @
Hello everyones,
Could anybody solve my query please.
Ashish
On Sat, Oct 6, 2012 at 4:54 PM, Ashish Bhalara wrote:
> Dear experts,
>
> I need to fill data in downward selected cell from upward cell as mention
> in attached file, is there possible.
>
> Thanks & regards.
>
> Ashish Bhalara
> 9624
Dear Ashish,
It is very simple...
Please follow below step.
Step-1. First select data A2:A60, make a filter (alt+dff)
Step-2. Select only blank option in drop-down list.
Step-3. Go to A3 and type formula =A2 and drag it
Step-4. then remove filter,
Hope it will help you otherwise cal
Dear Noorain/Rajan,
You Guys are awsome.
Thanks for sharing such great work
Regards,
Amol
On Thu, Oct 11, 2012 at 9:15 AM, Amit Desai (MERU)
wrote:
> Dear Noorain/Rajan,
>
> ** **
>
> This too was really nice
>
> ** **
>
> Can you or someone create a Meditation Chakra?
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
Hello experts,
I need help related to following things
1) How to import xml file in excel using VBA
2) how to export xml file using vba
Regards,
Amol J
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violatio
Dear Amol,
You have try through Developer tab..
On Thu, Oct 11, 2012 at 11:36 AM, Amol Jadhav wrote:
> Hello experts,
>
> I need help related to following things
>
> 1) How to import xml file in excel using VBA
> 2) how to export xml file using vba
>
>
> Regards,
> Amol J
>
> --
> Join offic
Yes, I am able import and export it using devloper tab,
Is it posible using VBA??
Thanks
Amol
On Thu, Oct 11, 2012 at 11:42 AM, NOORAIN ANSARI
wrote:
> Dear Amol,
>
> You have try through Developer tab..
>
>
>
>
> On Thu, Oct 11, 2012 at 11:36 AM, Amol Jadhav wrote:
>
>> Hello experts,
>>
>
While you are importing use record macro option
When u are done click on stop button
Press alt +f11 to see the code
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Amol Jadhav
Sender: excel-macros@googlegroups.com
Date: Thu, 11 Oct 2012 11:54:30
To:
Reply-To: excel-macr
Thanks Ashish\Noorain
Regards,
Amol
On Thu, Oct 11, 2012 at 12:01 PM, wrote:
> **
> While you are importing use record macro option
>
> When u are done click on stop button
>
> Press alt +f11 to see the code
> Sent on my BlackBerry® from Vodafone
> --
> *From: *Amol J
--
Thanks & Regards,
Gawli Anil Narayan
Software Developer,
Abacus Software Services Pvt Ltd
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles
Dear Anil,
Now you are subscribe in Excel-Macro group.
On Thu, Oct 11, 2012 at 12:24 PM, अनिल नारायण गवली
wrote:
>
>
> --
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
> --
> Join official facebook page of this forum @
> https://www.facebook.
45 matches
Mail list logo