Thank you so much* Mr. Ashish koul.* This is what i exactly looking for. I
appreciate your generous support.
With Regards,
Haris
na.har...@gmail.com
On 1 July 2012 09:53, ashish koul koul.ash...@gmail.com wrote:
=INDEX($C$1:$F$1,MATCH(SMALL(C2:F2,COUNTIF(C2:F2,0)+1),C2:F2,0))
On Sun, Jul
*guys does anyone has any opinion on this problem???
*
On Fri, Jun 29, 2012 at 9:19 PM, ashwani agnihotri
ashwani.agniho...@gmail.com wrote:
Hi,
I have a query..suppose i put some thing in column B and i have mail id in
column C i want to sent the mail on that ID.
In the example given
Dear Ashish,
If 2 or 3 gave the same rate then how it will index/display. for eg: if
the price of rate a and rate b is same it will index rate a only. so is
there any way to index rate a and rate b
With Regards,
Haris
na.har...@gmail.com
On 1 July 2012 11:13, Haris na.har...@gmail.com wrote:
See forum rule 2
On 1 July 2012 17:58, ashwani agnihotri ashwani.agniho...@gmail.com wrote:
*guys does anyone has any opinion on this problem???
*
On Fri, Jun 29, 2012 at 9:19 PM, ashwani agnihotri
ashwani.agniho...@gmail.com wrote:
Hi,
I have a query..suppose i put some thing in
Put in a macro enabled workbook
Sub sumifNOTbold()
dim I as long
dim ii as long
For i = 3 To 7
ms = 0
For ii = 5 To 9
If Cells(ii, 2).Font.Bold =False Then ms = ms + Cells(ii, i)
Next ii
MsgBox ms
Cells(16, i) = ms
Next i
end sub
Don Guillett
Microsoft Excel Developer
SalesAid Software
Hi Neeraj,
Try this:
Sub FindFormula()
Dim rngDtRange As Range
Const strDataRange As String = B1:B1000
With ThisWorkbook.Worksheets(Sheet1).Range(strDataRange)
For Each rngDtRange In .Range(strDataRange)
If
Hi Lokesh,
We are always happy to help you.
Regards,
Lalit Mohan
www.excelfox.com/forum
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Lokesh Loki
Sent: Saturday, June 30, 2012 8:36 PM
To: excel-macros@googlegroups.com
Subject: Re: FW:
Hi Lalit,
Thank you so much for your help.
I wish you have a great future ahead. Once again thanks for all to helping
me.
Regards
Lokesh.M
On Sun, Jul 1, 2012 at 8:38 PM, Lalit Mohan mohan.pande...@gmail.comwrote:
Hi Lokesh,
** **
We are always happy to help you.
** **
Hi,
I have a query..suppose i put some thing in column B and i have mail id in
column C i want to send the mail on that ID.
In the example given below if i enter done in column B a mail should be
send on address entered in column C
ABC
ram
sham
Congrats both of you .. J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: 01 July 2012 9:55
To: excel-macros
Cc: Dilip Pandey; ashish koul
Subject: $$Excel-Macros$$ MVP
What do you want to send in mail??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of ashwani agnihotri
Sent: 01 July 2012 9:49
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query on Email
Congaratulation Ashish and Dilip
Regards,
Lalit Mohan
www.excelfox.com/forum
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Rajan_Verma
Sent: Sunday, July 01, 2012 9:56 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ MVP
i just want to send a mail with a subject plz check to the email address in
column C for the rows in column B which i mark as done.
On Sun, Jul 1, 2012 at 10:02 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
What do you want to send in mail??b
** **
* *
*Regards*
*Rajan verma*
Many Many My heartiest congratulations to Both of You.
--
Thanks regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Sun, Jul 1, 2012 at 9:54 PM, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
I am extremely happy to inform you that two members of the
Hi All,
Please help me to fine the VBA PDF books link need.
Thanks,
Venkatesh.
--
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
And, Don Guillett was not re selected.
Don Guillett
Microsoft Excel Developer
SalesAid Software
dguille...@gmail.com
From: Ayush Jain
Sent: Sunday, July 01, 2012 11:24 AM
To: excel-macros
Cc: Dilip Pandey ; ashish koul
Subject: $$Excel-Macros$$ MVP AwardCongratulations Ashish Koul and
Don,
You are valuable to this forum and a star performer.
We really admire you and appreciate your great contribution to this forum.
Regards
Ayush Jain
On Sun, Jul 1, 2012 at 10:34 PM, dguillett1 dguille...@gmail.com wrote:
And, Don Guillett was not re selected.
Don Guillett
Microsoft
Dear Venkatesh,
Hi Venkatesh,
Download EXCEL-VBA Ebook..
http://search.4shared.com/q/CCAD/1/excel+vba
http://pdftop.net/excel+vba+tutorial-pdf/
http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20With%20VBA.
Download Excel-VBA
Ebookhttp://www.excelmacroworld.blogspot.in/2012/02/download-excel-vba-ebook.html
Download EXCEL-VBA Ebook..
http://search.4shared.com/q/CCAD/1/excel+vba
http://pdftop.net/excel+vba+tutorial-pdf/
On Sun, Jul 1, 2012 at 10:32 PM, Venkatesh Narla nvenki...@gmail.comwrote:
Hi
Yes Don ayush is correct I use your ideas to solve many problems at many other
forum n sites.
This is great forum for newbies n expert.
You all are stars n made this forum unique.
Thanks to all.
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender:
Thanks Ayush..!!
Thanks to all the members of this group for giving us many chances to
learn by sharing their queries. ;)
It is a great group.. . Thanks once again.
Regards,
DILIPandey
On 7/1/12, Ayush Jain jainayus...@gmail.com wrote:
Dear members,
I am extremely happy to inform you that
Hello Everyone,
I would appreciate some assistance in creating a macro to export the
content in the file input to the file output. The spacing, tabs and
apostrophe should remain the same way as it is in the output file.
Thank you everyone.
Ojemeni Uzoma
--
FORUM RULES (986+ members already
can you plz send me attached work book with screen shoots,because when ever i
open ur attached work book is bold name get disappear from NAME Manager and
when i apply the formula it gives me False in every row n sum all the rows
kindly send me n send me in 2007 format
Date: Sat, 30 Jun
thanx Noorani got the answer
Date: Sat, 30 Jun 2012 23:18:16 +0530
Subject: Re: $$Excel-Macros$$ tricky some question
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Dear Danial,
Please use
=Get.cell(21,indirect(RC[1],) and create Name range.
then use simple
Congratulations to both of you and thanks for being with us
On Sun, Jul 1, 2012 at 11:32 PM, Dilip Pandey dilipan...@gmail.com wrote:
Thanks Ayush..!!
Thanks to all the members of this group for giving us many chances to
learn by sharing their queries. ;)
It is a great group..
Dear All,
Please look at attachment and help me.
thanking u
Regards
Sudhir
--
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
Dear Sudhir
Please find the attachment...
Regard
Manoj
On Mon, Jul 2, 2012 at 10:58 AM, SUDHIR VERMA newinex...@gmail.com wrote:
Dear All,
Please look at attachment and help me.
thanking u
Regards
Sudhir
--
FORUM RULES (986+ members already BANNED for violation)
1) Use
Hi,
I need Vlookup for Last Available Date if the
[cid:image001.png@01CD5845.027B11A0]
This message contains information that may be privileged or confidential and is
the property of PlanetSoft Holdings Inc. It is
intended only for the person to whom it is addressed. If you are not the
Dear Sudhir,
Please use it for unique Name in drop down List..
*=IFERROR(INDEX($A$10:$A$43,MATCH(0,COUNTIF($Q$1:Q1,$A$10:$A$43),0)),)*
for specific record of Party Name
*
=IFERROR(INDEX($C$10:$C$43,SMALL(IF($A$10:$A$43=$I$6,ROW($C$10:$C$43),),ROW(B1))-9),)
*
with ctrl+shfit+enter
see
29 matches
Mail list logo