RE: $$Excel-Macros$$ Don't want GETPIVOTDATA formula

Amazing Daniel... You saved my lot of time... thanks once again Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Daniel Sent: Saturday, March 26, 2011 4:10 PM To: excel-macros@googlegroups.co

RE: $$Excel-Macros$$ Number to Text ?

Hi, This is very helpful function can I get steps to use this as I am unable to get on this . Regards, Vikram From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of siti Vi Sent: Sunday, March 27, 2011 7:12 AM To: excel-macros@googlegroups.com Subjec

Re: $$Excel-Macros$$ Edit Data In Embedded Excel Charts Within Powerpoint Using VBA

can you attach the source data as well On Sun, Mar 27, 2011 at 9:58 AM, Deepak Pal Singh wrote: > Hi Guy's, > > I'm still waiting for your help... > > -- Forwarded message -- > From: Deepak Pal Singh > Date: Sat, Mar 26, 2011 at 7:55 PM > Subject: $$Excel-Macros$$ Edit Data In

RE: $$Excel-Macros$$ Sum If

Thanks Ashish, this is exactly what in was looking for. I understand that a "$" sign will freeze the range, what is the technical function of the "&"? From: ashish koul [mailto:koul.ash...@gmail.com] Sent: Saturday, March 26, 2011 9:21 PM To: excel-macros@googlegroups.com Subject: Re: $$Exce

Re: $$Excel-Macros$$ Sum If

FOR EXAMPLE CE5 is having date =SUMIF($F$5:$BM$5,"="&CE5,$F7:$BM7) On Sun, Mar 27, 2011 at 6:29 AM, Pehrson, Dave wrote: > In the sumif function shown below, I’m referencing a date: ,"=04/25/2011" > > =SUMIF($F$5:$BM$5,"=04/25/2011",$F7:$BM7) > > The Date is in cell “F5” > > Is there a way to

Re: $$Excel-Macros$$ Re: Identify the room status by color code

please find attached and see if it helps best regards siti Vi On Sat, Mar 26, 2011 at 9:15 PM, Rajesh K R wrote: > On 3/26/11, Rajesh K R wrote: > > Hi Experts > > > > How to understand the room status, by color code.pls check the > attachment. > > > > Regards > > > > Rajesh Kainikkara > > >

Re: $$Excel-Macros$$ Pivot Table Help

Dear Mr. John, =SUM(NOT(B2=""),NOT(D2=""),NOT(F2="")) The above formula will help you for finding out the Total Deliveries *With warm regards* *Viswanathan M* DE(Tech) RGM TTC Chennai-600027 *Vande* *Mataram* On Sat, Mar 26, 2011 at 9:57 PM, John A. Smith wrote: > I have an excel database

Re: $$Excel-Macros$$ Identify the room status by color code

no attachments in your mail/posting just for info Color Index can be detected by *(1) making and UDF (user Definded Function)* Public Function ColorIndex(Rng as range) as long ColorIndex = Rng.Interior.ColorIndex End Function in worksheet you just use this NEW FUNCTION =ColorIndex(B5)

Re: $$Excel-Macros$$ Select numbers date wise using a formula

please visit : http://www.cpearson.com/excel/ArrayFormulas.aspx http://office.microsoft.com/en-us/excel-help/introducing-array-formulas-in-excel-HA001087290.aspx

Re: $$Excel-Macros$$ discussexcel : Formula : Extract email address from sentence in cell

Dear Mr. Ayush Please try =TRIM(RIGHT(SUBSTITUTE(LEFT(A2,FIND(" ",A2&" ",FIND("@",A2))-1)," ",REPT(" ",99)),99)) or (Array Formula:) =MID(LEFT(A2,FIND(" ",A2&" ",FIND("@",A2))),COUNT(SEARCH(" *@",A2,ROW($1:$103)))+1,99) thank you and best regards siti Vi On Sat, Mar 26, 2011 at 9:52 PM, Ayu

$$Excel-Macros$$ Pivot Table Help

I have an excel database where each line represents an entity and it's data over about 70 columns. There are multiple occurrences of delivery information in these columns that I need to summarize in a pivot table. Some lines may have only one occurrence of this delivery while some others may have

Re: $$Excel-Macros$$ Identify the room status by color code

attachment is added now On 3/26/11, vijayajith VA wrote: > Hai > attachment is missing > thanks > > On Sat, Mar 26, 2011 at 7:43 PM, Rajesh K R > wrote: > >> Hi Experts >> >> How to understand the room status, by color code.pls check the >> attachment. >> >> Regards >> >> Rajesh Kainikkara >> >>

Re: $$Excel-Macros$$ Identify the room status by color code

Hai attachment is missing thanks On Sat, Mar 26, 2011 at 7:43 PM, Rajesh K R wrote: > Hi Experts > > How to understand the room status, by color code.pls check the attachment. > > Regards > > Rajesh Kainikkara > > -- > > ---

$$Excel-Macros$$ discussexcel : Formula : Extract email address from sentence in cell

Hello Group, Learn to extract email address from the string in the cell. Visit : http://www.discussexcel.com/functions Feel free to share ideas you might have for the same task. I will appreciate it. Thanks and best regards Ayush Jain -- ---

Re: RE: $$Excel-Macros$$ discussexcel : Macro: Column Number to Alphabetical reference

Thank you Mr. Ayush.. Thank you Mr. Bonallack Best Regards siti On Sat, Mar 26, 2011 at 9:43 PM, Ayush wrote: > Really Awesome formula. > > Thanks Siti Vi. I have published this formula on the same page along with > your name. > > > Regards > Ayush Jain > > -- --

Re: RE: $$Excel-Macros$$ discussexcel : Macro: Column Number to Alphabetical reference

Really Awesome formula. Thanks Siti Vi. I have published this formula on the same page along with your name. Regards Ayush Jain -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks an

Re: $$Excel-Macros$$ Select numbers date wise using a formula

Hi Dev Thank u very much for your quick reply, unfortunately I don't have any idea about array formulas. how can I learn it properly. Regards Rajesh Kainikkara On 3/25/11, STDEV(i) wrote: > 1. > formula HELPER > ( creating list of RowIndex ) > array formula in multi cells > =IF(ISNUMBER($A5),OF

$$Excel-Macros$$ Re: Identify the room status by color code

On 3/26/11, Rajesh K R wrote: > Hi Experts > > How to understand the room status, by color code.pls check the attachment. > > Regards > > Rajesh Kainikkara > -- -- Some important links for excel users: 1. Follow us

$$Excel-Macros$$ Identify the room status by color code

Hi Experts How to understand the room status, by color code.pls check the attachment. Regards Rajesh Kainikkara -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http

$$Excel-Macros$$ How to Import System.Net.Sockets

I have VB program that works in Studio 2005. When I copied same program to Excel, there is compilation error. Here is a program: 1. Imports System.Net.Sockets 2. Imports System.Text 3. Function Client(Request As String) 4.Dim tcpClient As New System.Net.Sockets.TcpClient() 5.tcpClient.C

Re: $$Excel-Macros$$ Number to Text ?

Just found this code somwhere see in attached text file copy paste and run it. ' Make a form with two textboxs with the standard names ' textbox1 and textbox2. ' Textbox1 is the input numbers box. ' Textbox2 displays the words spelled out On Fri, Mar 25, 2011 at 11:21 PM, hanumant shinde wr

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

File search has been removed after 2003 Version..you may use Dir() for same task.. On Fri, Mar 25, 2011 at 2:34 AM, Dave wrote: > Hi Gurus,, > > I have the following macro that has been working fine for ages in > Excel 2003 and now is giving me "run time error 445 Object doesn't > support this

Re: $$Excel-Macros$$ Multi User in Excel file

No Sharing Dows not Work. You have to Create the Database kind of thing you have to get the data and read the data through ODBC or through the get external Data->Synchronise On Fri, Mar 25, 2011 at 10:17 PM, SAJID MEMON wrote: > Dear Dilipji & Thamuji > As per your opinion i had

Re: $$Excel-Macros$$ Excel Password Breaker Code...

let me know how to use the same to break existing password protected sheet. On 24 March 2011 15:35, NOORAIN ANSARI wrote: > Dear Experts., > > Please find & use below VBA code to break password in EXCEL > > Procedure : Press alt+F11 > Insert-Module then Paste below code >

RE: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

Hi, Use the following code : Public f As Object, d As Object, i As Long Sub Main() Dim Fso As Object Set Fso = CreateObject("Scripting.FileSystemObject") 'RootFolder is the main folder Set RootFolder = Fso.getfolder("c:\temp\vba") FolderRead RootFolder End Sub Su

RE: $$Excel-Macros$$ discussexcel : Macro: Column Number to Alphabetical reference

Excellent formula! Dave. From: setiyowati.d...@gmail.com Date: Sat, 26 Mar 2011 16:40:29 +0700 Subject: Re: $$Excel-Macros$$ discussexcel : Macro: Column Number to Alphabetical reference To: excel-macros@googlegroups.com =SUBSTITUTE(ADDRESS(1,A1,4),1,"") =SUBSTITUTE(ADDRESS(1,16384,4

RE: $$Excel-Macros$$ Don't want GETPIVOTDATA formula

Hi, It depends upon which version you are using. Have a look at the page : http://support.microsoft.com/kb/287736/en-us Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Anil Bhang

Re: $$Excel-Macros$$ discussexcel : Macro: Column Number to Alphabetical reference

*=SUBSTITUTE(ADDRESS(1,A1,4),1,"")* * * *=SUBSTITUTE(ADDRESS(1,16384,4),1,"")* On Fri, Mar 25, 2011 at 10:40 PM, Ayush wrote: > Hello everyone, > > Here is the UDF to convert a number into Alphabetical reference. If you > pass 1 to the function, it will Return A. If you pass 26, It will return