Hi,
I don't know which version your are using. It is working in XL
2003,2007,2010.
It is provide as DEMO version by website. That's why it is fully protected.
I hope this clarify clear.
Regards,
MARIES.
On Sun, Feb 26, 2012 at 11:03 AM, Cab Boose swch...@gmail.com wrote:
Hi
I have
Can some one please help?
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 24 February 2012 10:12
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Avg. Revisit in number of days
Dear All,
With the
Perhaps a full explanation and examples would help.
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Amit Desai (MERU)
Sent: Thursday, February 23, 2012 10:42 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Avg. Revisit in number of days
Dear All,
With the help of
Hi,
Try this macro.
Sub kTest()
'Kris @ ExcelFox.com
Dim i As Long, j As Long
Dim n As Long, m As Long
Dim r As Range
Dim wbkAAs Workbook
Dim wbkNAs Workbook
Dim wksNAs Worksheet
Dim CopyRng As Range
Dim MTHs, SUBs
please find the attachment
On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
Dear sir,
plz download the attachment and help me...
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles,
My Try,
=IF(AND(C2=Y,COUNTIF(D2:G2,Y)),$C$1,,IF((C2)=Y,$C$1,))IF(AND(D2=Y,COUNTIF(E2:G2,Y)),$D$1,,IF((D2)=Y,$D$1,))IF(AND(E2=Y,COUNTIF(F2:G2,Y)),$E$1,,IF((E2)=Y,$E$1,))IF(AND(F2=Y,COUNTIF(G2:G2,Y)),$F$1,,IF((F2)=Y,$F$1,))IF(G2=Y,$G$1,)
On Sun, Feb 26, 2012 at 8:03 PM, xlstime xlst...@gmail.com
thanks for help sir
i am already done with if statement. chk attachment.
and provide other solution vlookup/index-match
On Sun, Feb 26, 2012 at 9:33 PM, xlstime xlst...@gmail.com wrote:
please find the attachment
On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote:
Hi Maries,
Thanks for sending the valuable formula. Thanks a lot maries.
Regards
Lokesh.M
On Sat, Feb 25, 2012 at 10:04 PM, Maries talk2mar...@gmail.com wrote:
My Try:
=MID(A1,FIND((,A1)+1,FIND(),A1)-FIND((,A1)-1)
On Sat, Feb 25, 2012 at 8:31 PM, Lokesh Loki lokeshsmg2...@gmail.comwrote:
How about a macro solution. Change “I” to “H”
Sub gettitlesSAS()
Dim r As Long
Dim c As Long
Dim ms As String
For r = 2 To Cells(Rows.Count, 1).End(xlUp).Row
ms =
For c = 3 To Cells(1, Columns.Count).End(xlToLeft).Column
If UCase(Cells(r, c)) = Y Then ms = ms , Cells(1, c)
Next c
Cells(r, I)
Hi All,
Below is the Macro I have recorded for unchecking the Pivot Table.
ActiveSheet.PivotTables(PivotTable2).PivotFields(Month).CurrentPage
= (All)
With ActiveSheet.PivotTables(PivotTable2).PivotFields(Month)
.PivotItems(Jan).Visible = False
.PivotItems(Feb).Visible =
you can use ActiveSheet.PivotTables(PivotTable1).ClearAllFilters
or
At the top of the window, on the Ribbon, click the *Options* tab under
*PivotTable
Tools*. In the *Actions* group, click *Clear*, and then click *Clear Filters
*. Be sure you really want to do this before you undo all your
Thanks a lot.
Will update you tomorrow on this..
Thanks,
Kiran
On Sun, Feb 26, 2012 at 11:57 PM, xlstime xlst...@gmail.com wrote:
you can use ActiveSheet.PivotTables(PivotTable1).ClearAllFilters
At the top of the window, on the Ribbon, click the *Options* tab under
*PivotTable
http://www.contextures.com/xlPivot05.html
http://www.ozgrid.com/VBA/pivot-table-fields.htm
or this idea
For Each pf In pt.DataFields
pf.Orientation = xlHidden
Next pf
Don Guillett
SalesAid Software
dguille...@gmail.com
From: Kiran Kancharla
Sent: Sunday, February 26, 2012 12:15 PM
To:
Hi ,
Try This,
*=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))*
*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71*
On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee lee.sar...@gmail.com wrote:
i have date in this format-- 20011012... yrmmdd..
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 already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula
Hi Sam,
I think this part ISNUMBER(--MID(A3,6,4)) will allow entry with 3 spaces
before the fourth digit :-) , like
ABCDE 1D
Hi Vijayendra,
This is my try. Firstly define 3 names to avoid INDIRECT function.
Name: *Alpha*
On refers to:
={A;B;C;D;E;F;G;H;I;J;K;L;M;N;O;P;Q;R;S;T;U;V;W;X;Y;Z}
Try by using as below
=if(iserror(formula),on error,formula)
Thanks and Regards,
Somnath C Pardeshi
Sent from BlackBerry® on Airtel
-Original Message-
From: chandra sekaran duraichan...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 27 Feb 2012 10:24:13
To:
Dear Chandra,
Please try it..in excel 2003 version
Hi Sara,
Addition in Venkat Formula :
For weeknum
=WEEKNUM(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)))
For Month
=MONTH(DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2)))
On Mon, Feb 27, 2012 at 7:52 AM, Venkat CV venkat1@gmail.com wrote:
Hi ,
Try This,
Thanks Sam, Maries Haseeb.
All three solutions are working fine.thanks again.
Regards,
Vijayendra
2012/2/27 Haseeb Avarakkan haseeb.avarak...@gmail.com
Hi Sam,
I think this part ISNUMBER(--MID(A3,6,4)) will allow entry with 3 spaces
before the fourth digit :-) , like
ABCDE 1D
Hi
Nice one..
On Sat, Feb 25, 2012 at 6:42 PM, Maries talk2mar...@gmail.com wrote:
*Great!!! Thanks Ashish...*
On Sat, Feb 25, 2012 at 5:01 PM, ashish koul koul.ash...@gmail.comwrote:
Hi Group
Try this udf it will help you in finding the time and distance between
two cities using
Great... Powerful Logic.
On Mon, Feb 27, 2012 at 6:49 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 already BANNED for
22 matches
Mail list logo
