Re: $$Excel-Macros$$ Re: date format

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 al

Re: $$Excel-Macros$$ Find Distance and Time between two cities using Google Map In excel

Nice one.. On Sat, Feb 25, 2012 at 6:42 PM, Maries wrote: > *Great!!! Thanks Ashish...* > > > On Sat, Feb 25, 2012 at 5:01 PM, ashish koul wrote: > >> Hi Group >> >> Try this udf it will help you in finding the time and distance between >> two cities using Google Map >> >> >> >> -- >> *Regar

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Validate text and number in PAN

Thanks Sam, Maries & Haseeb. All three solutions are working fine.thanks again. Regards, Vijayendra 2012/2/27 Haseeb Avarakkan > 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, > > T

Re: $$Excel-Macros$$ date format

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 wrote: > Hi , > > Try This, > > > *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* > > *Best Reg

Re: $$Excel-Macros$$ ifError not woking with excel 2003 version

Dear Chandra, Please try it..in excel 2003 version =IF(ISERROR(INDEX(Data!$A$3:$A$640,SMALL(IF(IF(ISERROR(SEARCH($E$1,Data!$E$3:$E$640,1)),0,SEARCH($E$1,Data!$E$3:$E$640,1))>0,ROW(Data!$E$3:$E$640)-2,""),ROW()-4))),"",INDEX(Data!$A$3:$A$640,SMALL(IF(IF(ISERROR(SEARCH($E$1,Data!$E$3:$E$640,1)),0,S

Re: $$Excel-Macros$$ List Box Like Tally Software

Dear all this file not working with excel2003 iserror function regards chandru On Mon, Feb 20, 2012 at 8:28 PM, Maries wrote: > Hi, > > I got your logic. Check the attachment. > > Type your text in cell D1 & Enter. It will give answer. > > Regards, > > MARIES. > > > On Mon, Feb 20, 2012 a

Re: $$Excel-Macros$$ ifError not woking with excel 2003 version

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 Sender: excel-macros@googlegroups.com Date: Mon, 27 Feb 2012 10:24:13 To: Reply-To: excel-macros@googlegroups.c

Re: $$Excel-Macros$$ Pivot table

Hi, This is the third time, you posting the same question. Already issue rectified . *Please check this link:* https://groups.google.com/forum/?fromgroups#!searchin/excel-macros/$20the$20file,$20Where$20i$20am$20using$20recording$20macro..$20and$20get$20the$20pivot$20table$20but$20every$20date$2

$$Excel-Macros$$ Excude some sheets in macro

Hi See attachedI workbook. XL2000 Refer to summary sheet I am wanting to extract data from some sheets into summary sheet. I can exclude 1 sheet ok, but when I try to exclude others I get syntax error. The line of code with problem is: If Worksheets(k).Name = "summary", "forms", "admin" Then

Re: $$Excel-Macros$$ $$Excel-Ma​cros$$ Validate text and number in PAN

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";"

$$Excel-Macros$$ Re: date format

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 Pr

Re: $$Excel-Macros$$ date format

Hi , Try This, *=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))* *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Mon, Feb 27, 2012 at 1:45 AM, Sara Lee wrote: > i have date in this format-- 20011012... yrmmdd.. i want to extract

Re: $$Excel-Macros$$ Pivot uncheck All

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: exc

Re: $$Excel-Macros$$ Pivot uncheck All

Thanks a lot. Will update you tomorrow on this.. Thanks, Kiran On Sun, Feb 26, 2012 at 11:57 PM, xlstime wrote: > you can use ActiveSheet.PivotTables("PivotTable1").ClearAllFilters > > > > > > At the top of the window, on the Ribbon, click the *Options* tab under > *PivotTable > Tools*. In th

Re: $$Excel-Macros$$ Pivot uncheck All

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 se

$$Excel-Macros$$ Pivot uncheck All

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("Fe

Re: $$Excel-Macros$$ help needed??

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 Cell

Re: $$Excel-Macros$$ Extract last digit number

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 wrote: > My Try: > > =MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1) > > > On Sat, Feb 25, 2012 at 8:31 PM, Lokesh Loki wrote: > >> Hi Sam, >> >> Thank you ver

Re: $$Excel-Macros$$ help needed??

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 wrote: > please find the attachment > > On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote: > >> Dear sir, >>plz dow

Re: $$Excel-Macros$$ help needed??

Instead of using the CONCATENATE function with multiple if conditions, better to use a simple helper column with a small formula like this J2=IF(C2="Y",IF(I2<>"",I2&",","")&C$1,TEXT(I2,"")) And H2=LOOKUP("ZZ",J2:N2) Regards, Sam Mathai Chacko On Sun, Feb 26, 2012 at 9:33 PM, xlstime w

Re: $$Excel-Macros$$ help needed??

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, F

Re: $$Excel-Macros$$ help needed??

please find the attachment On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra wrote: > 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, like Please > He

Re: $$Excel-Macros$$ Need a small MACRO to SPLIT Double Looping

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 Cons

Re: $$Excel-Macros$$ Avg. Revisit in number of days

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 o

RE: $$Excel-Macros$$ Avg. Revisit in number of days

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 hel

Re: $$Excel-Macros$$ inventory sheet

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 wrote: > Hi > > I have opened the file fo