See if it helps
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Karan Singh
Sent: 01 June 2012 11:04
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Graph Query
Dear All,
I want
Use the following Code :
Sub Compile()
On Error GoTo Err_Clear:
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Dim Fso As New Scripting.FileSystemObject
Dim Path As String
Application.FileDialog(msoFileDialogFolderPicker).Title = Select Folder to
Pick
To unsubscribe, send a blank email to
excel-macros+unsubscr...@googlegroups.com
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of prashant pawle
Sent: 03 June 2012 11:19
To: Excel Helper
Subject:
Hi
What do you mean by this Login time : 879:55:64 is it 879 Hour 55 Minute
and 64 Seconds??
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 02 June 2012 12:39
To:
@ASA, thanks a lot. :)
On Sun, Jun 3, 2012 at 7:45 AM, Asa Rossoff a...@lovetour.info wrote:
Hi Indrajit,
You could try searching @ Office.com; for example:
http://office.microsoft.com/en-us/templates/results.aspx?qu=businessex=1av=zpp
Asa
** **
*From:*
Dear All,
Please resolved below query.
Being accounts credited as per bill no: 45586, dt: 7.8.11, GR No: 785,
dt: 6.8.11, by NTU.
Being accounts credited as per GR No: 100486 dt: 5.9.11, Bill no 889,
dt: 4.9.11 by Fedex.
Bill No: 97849, dt: 10.8.11 and gr no 56478789, dt:1.8.11 through
Nalagarh
check the attachment see if it helps
On Sun, Jun 3, 2012 at 1:53 PM, SUDHIR VERMA newinex...@gmail.com wrote:
Dear All,
Please resolved below query.
Being accounts credited as per bill no: 45586, dt: 7.8.11, GR No: 785,
dt: 6.8.11, by NTU.
Being accounts credited as per GR No: 100486 dt:
Dear Ashish,
Thank you so much and Please can u explain this for understanding me.
thanking you
On 03/06/2012, ashish koul koul.ash...@gmail.com wrote:
check the attachment see if it helps
On Sun, Jun 3, 2012 at 1:53 PM, SUDHIR VERMA newinex...@gmail.com wrote:
Dear All,
Please resolved
Hi Hilary,
INDEX(NamesRange,1) returns the first row of the range (which is a single
cell since the range is only one column wide).
Put that inside a ROW() function and you get the first row number.
Equally effective would be specifying the first cell in NamesRange instead:
Thanks Raj. Will try this as well
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Rajan_Verma rajanverma1...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sun, 3 Jun 2012 12:33:08
To: excel-macros@googlegroups.com
Reply-To:
Dear sir,
i am using index/match formula. in my problem i am getting the
1st occurrence result only.
Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS I 2
#NUM! #NUM! 3 #NUM! #NUM! 4 #NUM! #NUM! 5 #NUM!
#NUM! 6 #NUM! #NUM!
Hi,
Use Vlookup formula, I think it should help you.
Rgds
On Sun, Jun 3, 2012 at 1:08 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
Dear sir,
i am using index/match formula. in my problem i am getting the
1st occurrence result only.
Sr. No. Subject Code Subject/Paper
Hi
I want help to create a macro where in the first sheet A1 cell we specify
the number for which the multiplication table should be generated (i.e., 5
means 5 multiplication ) and in the 2nd sheet A1 specify the range ( 10
i.e, 5*1 till 5*10) and in the 3rd sheet display the table.
Kindly help.
check the attachment see if it helps
On Sun, Jun 3, 2012 at 3:57 PM, Aruna jayaram aruna2...@gmail.com wrote:
Hi
I want help to create a macro where in the first sheet A1 cell we specify
the number for which the multiplication table should be generated (i.e., 5
means 5 multiplication ) and
Thanks for the explanation. What I like abt this formula is it actually picks
not only the 2nd occurance but the last occurance which I think might be useful
going forward. Thanks again
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Asa Rossoff
*check the attachment see if it helps *
On Sun, Jun 3, 2012 at 2:09 PM, SUDHIR VERMA newinex...@gmail.com wrote:
Dear Ashish,
Thank you so much and Please can u explain this for understanding me.
thanking you
On 03/06/2012, ashish koul koul.ash...@gmail.com wrote:
check the attachment
And you could combine into ONE formula
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: ashish koul
Sent: Sunday, June 03, 2012 6:25 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to find paritcular word from sentence
check the attachment
How about a nice macro? Change your formatting and use in macro enabled workbook
Sub filtercopy()
With Sheets(COURSES).UsedRange
.AutoFilter Field:=1 'criteria IF needed
.AutoFilter Field:=2
.AutoFilter Field:=3, Criteria1:=Sheets(form).Range(n1)
.Offset(1, 3).Resize(,
Dear Members
I have a number of excel workbooks in a folder. I need to be able to have Excel
check for the existance of Excel workbooks in the folder. Then using vba, write
an automatic link formula from the contents of cells C1 to C20 in the files.
The link formula will appear in a master
Thanks.
But it is showing Yes for Blanks also.
I wish to show Blank for Blanks.
On Saturday, June 2, 2012 12:12:39 PM UTC+4, vijayajith VA wrote:
Hi Rashid
As you requested.. Please find ...attached file...Thanks
On Sat, Jun 2, 2012 at 1:14 PM, Rashid Khan prkha...@gmail.com wrote:
Hello
thanks for help.
plz provide index/atch solution also
On Sun, Jun 3, 2012 at 6:35 PM, dguillett1 dguille...@gmail.com wrote:
How about a nice macro? Change your formatting and use in macro enabled
workbook
Sub filtercopy()
With Sheets(COURSES).UsedRange
.AutoFilter Field:=1 'criteria
I like my solution.
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sourabh Salgotra
Sent: Sunday, June 03, 2012 12:53 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Records found but unable to get proper result.
thanks for help.
plz provide
Dear all,
Dear Rajan Verma congratulation being a 'Most Helpful Member' for the month
of May'2012 and also thanks to all members like Noorain sir, Don sir, Asa
sir, Maries sir, etc...
Also special thanks to Ayushji for being a most helping to new learners.
Thanks Regards,
Prajakt Pande
Hello Brother,
Again one more time you rocking the 'Most Helpful Member for the month of
May 2012, Congratulation brother.
Hip Hip Hurry !
All the best for your future.Have a great day ahead.
Regards
Lokesh.M
On Sun, Jun 3, 2012 at 11:28 PM, Prajakt Pande
Congratulation Rajan Verma, thanks for support.
Regards,
Pawel
From: Prajakt Pande prajakt.pa...@gmail.com
To: excel-macros@googlegroups.com
Cc: NOORAIN ANSARI noorain.ans...@gmail.com; jainayus...@gmail.com; Don
Guillett dguille...@gmail.com; Marieswaran
Congratulation Raj. Proud of you. Lunch for you tommorrow.
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Sun, 3 Jun 2012 23:12:31
To: excel-macrosexcel-macros@googlegroups.com
Hi Excel Experts,
Need a help on the macro for automated email reminders. below is the
requirements. Attached is sheet for your reference
Need a macro based on the given date and time in 1st, 2nd Final reminder
columns to all the email ID Subject mail should be content of cell text in
the
This yields 27
=SUMPRODUCT((RIGHT(B3:B17,1)=e)*(C3:H170))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: pawel lupinski
Sent: Sunday, June 03, 2012 1:41 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ counting E in the column
Dear All,
I need
I also like your solution :)
Thanks a lot working great.
Regards,
Pawel
From: dguillett1 dguille...@gmail.com
To: excel-macros@googlegroups.com
Sent: Sunday, June 3, 2012 7:56 PM
Subject: Re: $$Excel-Macros$$ counting E in the column
This yields 27
Congratulations again Cheeteh great going.
Regards,
Sam Mathai Chacko
On Mon, Jun 4, 2012 at 12:17 AM, resp...@gmail.com wrote:
**
Congratulation Raj. Proud of you. Lunch for you tommorrow.
Sent from my BlackBerry® smartphone from Airtel Ghana
--
*From: *
Ditto from Texas
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Sam Mathai Chacko
Sent: Sunday, June 03, 2012 3:48 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)
Congratulations again Cheeteh
Congratulations Rajan!
Outstanding work.
Asa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ayush Jain
Sent: Sunday, June 03, 2012 10:43 AM
To: excel-macros
Subject: $$Excel-Macros$$ Rajan Verma - Most helpful Member(May'12)
Hello Everyone,
Ah, I didn't realize what you had done in the sample file. You looked up
the last occurrence.. Yes. My formula could be reduced to
INDEX(what,SMALL(matching ROW,occurrence#)). but if you want the last
occurrence, it's better to use INDEX(what,MAX(matching ROW)) .. maybe Rajan
posted that
Hello Hugo,
Please post your current macro and we can most easily give you your desired
update to it.
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of hugo.ph...@gmail.com
Sent: Sunday, June 03, 2012 2:24 AM
To:
Congratulations Rajan
On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
May'2012
He has posted 147 posts in May 2012 and helped many people through his
expertise.
I truly
Congratulation Rajanonce again you rock...
Regards,
Lalit Mohan
On Sunday, 3 June 2012 23:12:31 UTC+5:30, Ayush Jain wrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
May'2012
He has posted 147 posts in May 2012 and helped many people
Congratulations Rajan , Awesome Job
Thanks Regards,
*Deba Ranjan P*
On Mon, Jun 4, 2012 at 8:03 AM, xlstime xlst...@gmail.com wrote:
Congratulations Rajan
On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has been
Congratulation Rajan..
On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain jainayus...@gmail.com wrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member' for the month of
May'2012
He has posted 147 posts in May 2012 and helped many people through his
expertise.
I
Yes...exactly.
Thanks Regards,
*Deba Ranjan P*
On Sun, Jun 3, 2012 at 1:28 PM, Rajan_Verma rajanverma1...@gmail.comwrote:
Hi
What do you mean by this Login time : “879:55:64” is it 879 Hour 55
Minute and 64 Seconds??
** **
* *
*Regards*
*Rajan verma*
*+91
Please have a look on this Dear Experts.
Thanks Regards,
*Deba Ranjan P*
On Mon, Jun 4, 2012 at 9:27 AM, Deba Ranjan drdeva...@gmail.com wrote:
Yes...exactly.
Thanks Regards,
*Deba Ranjan P*
On Sun, Jun 3, 2012 at 1:28 PM, Rajan_Verma
congrats Mr Rajan.
Gawli Anil
On Mon, Jun 4, 2012 at 9:23 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Congratulation Rajan..
On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain jainayus...@gmail.comwrote:
Hello Everyone,
Rajan Verma has been selected as 'Most Helpful Member'
*Congrats Brother.*
On Sun, Jun 3, 2012 at 9:36 PM, Anil Gawli gawlianil8...@gmail.com wrote:
congrats Mr Rajan.
Gawli Anil
On Mon, Jun 4, 2012 at 9:23 AM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Congratulation Rajan..
On Sun, Jun 3, 2012 at 11:12 PM, Ayush Jain
Congratulation Rajan
Nikhil Shah
On Mon, Jun 4, 2012 at 11:02 AM, Maries talk2mar...@gmail.com wrote:
*Congrats Brother.*
On Sun, Jun 3, 2012 at 9:36 PM, Anil Gawli gawlianil8...@gmail.comwrote:
congrats Mr Rajan.
Gawli Anil
On Mon, Jun 4, 2012 at 9:23 AM, NOORAIN ANSARI
43 matches
Mail list logo