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

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:

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

Hi Ashish, I'd attached the PPT in my last mail you can find the charts source data in the embedded excel file. You need to right click on the chart then click on edit option.. Thanks.. On Sun, Mar 27, 2011 at 11:21 AM, ashish koul koul.ash...@gmail.com wrote: can you attach the source data

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

Hi, let me re-iterate your problem. You are trying to copy data from excel sheet and put it into a linked excel sheet in the PPT to create graphs right? This can be done in VBA using OLE objects but unfortunately we cannot do it in Excel 2007 as this feature has been taken off. Having said that

$$Excel-Macros$$ Any tally groups

helllo, I want to learn tally so can you tell me is there any tally groups like excel groups so their i can learn tally so plz tell me and sugges me i m waiting for your response. Regards Manoj -- -- Some

RE: $$Excel-Macros$$ combining averageif with time into one formula

Thanks Umesh! Yes the formula below works great! Super J Excellent From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Umesh Dev Sent: Sunday, March 20, 2011 8:00 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ combining averageif with

$$Excel-Macros$$ How to convert a (blood pressure number 120/80) to a format that will allow averaging of total amount of blood pressure numbers

Hi experts! I have a project to do given to me by a doctor that has a series of blood pressure results (numbers) from various patients. And would like me to give him the average blood pressure result. How can I get Excel 2007 to convert the 120/80 into a format that will allow me to find

RE: $$Excel-Macros$$ Help on a simple question

You could try Power Pivot to merge and sort your various files into one pivot table or chart. ~Susan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: Thursday, March 10, 2011 5:02 AM To: excel-macros@googlegroups.com Subject:

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

Thank you Ashish and Viswanathan very much. Problem solved. John On Sun, Mar 27, 2011 at 2:28 AM, ashish koul koul.ash...@gmail.com wrote: check the attachment see if it helps On Sun, Mar 27, 2011 at 11:18 AM, ashish koul koul.ash...@gmail.comwrote: On Sun, Mar 27, 2011 at 5:51 AM,

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

On 27 Mar, 03:27, siti Vi villager.g...@gmail.com wrote: Dear Mr. Ayush Please try =TRIM(RIGHT(SUBSTITUTE(LEFT(A2,FIND( ,A2 ,FIND(@,A2))-1), ,REPT( ,99)),99)) great Vi! if you want to consider any punctuation ... (Array Formula:)

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

ops ... set_c as definited name: =ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789.-_ the array romula not with name is: =IF(ISERROR(SEARCH(@,A2)),,MID( LEFT(A2,SEARCH(@,A2)),MAX(IF(ISERROR(SEARCH(MID(

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

Can you explain how to crack password in VBThanks amp; RegardsRaveendra -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ How to convert a (blood pressure number 120/80) to a format that will allow averaging of total amount of blood pressure numbers

see if it helps On Sun, Mar 27, 2011 at 10:58 PM, Susan sunni...@gmail.com wrote: Hi experts! I have a project to do given to me by a doctor that has a series of blood pressure results (numbers) from various patients. And would like me to give him the average blood pressure result.

Re: $$Excel-Macros$$ How to convert a (blood pressure number 120/80) to a format that will allow averaging of total amount of blood pressure numbers

please try this Array formula =ROUND(AVERAGE(--LEFT(A1:A3,3)),0)/ROUND(AVERAGE(--RIGHT(A1:A3,2)),0) Array Formula needs to be entered with 3 keys : Ctrl + Shift, Enter ! On Mon, Mar 28, 2011 at 12:28 AM, Susan sunni...@gmail.com wrote: Hi experts! I have a project to do given to me by a

RE: $$Excel-Macros$$ How to convert a (blood pressure number 120/80) to a format that will allow averaging of total amount of blood pressure numbers

Yes that works great! ~S From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Sunday, March 27, 2011 6:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to convert a (blood pressure number 120/80) to a format that

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

note: before you start slide show run StartEvents macro in ppt On Mon, Mar 28, 2011 at 11:18 AM, ashish koul koul.ash...@gmail.com wrote: hi deepak try this method see if it helps you select the month from combo box in ppt it will update the chart in ppt as well as in excel open ppt