$$Excel-Macros$$ Copy row values to columns

2010-12-02 Thread 0 1
In Sheet1, I have a dynamic range ("MyRange") that spans several rows in one column. I'd like to copy the values in each row into columns in Sheet4. For example, in Sheet1 MyRange has these values: A -- 2 4 7 10 In Sheet4, I'd like to return: A B C D -- -- -- -- 2 4 7 10 I suspect ei

Re: $$Excel-Macros$$ IFERROR function from XL 2003 to 2007

2010-12-02 Thread TerryP
Paul, that does the trick, thanks ! On Dec 2, 12:23 pm, Paul Schreiner wrote: > If "touching" the cell works, then simply do a find/replace > and replace iferror with iferror. > > they all should recalculate then. > > Paul -- -

RE: $$Excel-Macros$$ Own Formule in Pivot Table

2010-12-02 Thread Dave Bonallack
Hi, Harmet, your formula is using relative values for the SUM(B2:B8) section, and as a result, has created errors while copying down. Formula in D2 should look like this: =B2/SUM($B$2:$B$8) Then copy down. Regards - Dave. From: harmeet.hew...@gmail.com Date: Fri, 3 Dec 2010 11:36:59 +1100 Sub

Re: $$Excel-Macros$$ Own Formule in Pivot Table

2010-12-02 Thread Harmeet Singh
here you go Warm Regards, Harmeet Singh IT Analyst McKinsey & Company http://www.facebook.com/Harmeeet On Thu, Dec 2, 2010 at 11:43 PM, Ramkesh Maurya wrote: > Hi All, > > Please tell me how i can insert my own formule in Excel. e.g 2 is 5.71% of > 35 the Grand Total, in next column I want to

Re: $$Excel-Macros$$ IFERROR function from XL 2003 to 2007

2010-12-02 Thread Paul Schreiner
If "touching" the cell works, then simply do a find/replace and replace iferror with iferror. they all should recalculate then. Paul - Original Message > From: TerryP > To: MS EXCEL AND VBA MACROS > Sent: Thu, December 2, 2010 11:34:27 AM > Subject: $$Excel-Macros$$ IFERROR function

$$Excel-Macros$$ IFERROR function from XL 2003 to 2007

2010-12-02 Thread TerryP
File was created in XL2003, I had an "IFERROR(x,y)" VBA function referenced in cell formula, see: http://min.us/mvj137H Now in XL2007, I removed the VBA "IFERROR" so as to use the built-in IFERROR. The problem is as you see in the picture, XL2007 is NOT automatically using the built-in. (F9

$$Excel-Macros$$ Re: 'Automatic' change to Line Chart from XY Scatter Chart

2010-12-02 Thread Daniel
After further experimentation, I seem to have found a reliable work- around, in case someone else encounters this bug. The bug pops up when I create a chart using a user-defined custom chart type (which is an xy scatter chart). However, if I instead create the chart using the Excel XY-scatter typ

$$Excel-Macros$$ Ctrl + Tilde

2010-12-02 Thread Shreedar Pandurangaiah
Hi Group, While I am able to use the Ctrl + Tilde, to see the hidden formulas in the spreadsheet. My colleague is not able to do that...I mean to say can't use the Ctrl + Tilde. What should I do to enable that? Thank You, Shreedar -- -

$$Excel-Macros$$ Own Formule in Pivot Table

2010-12-02 Thread Ramkesh Maurya
Hi All, Please tell me how i can insert my own formule in Excel. e.g 2 is 5.71% of 35 the Grand Total, in next column I want to sum the percentage of 2( i.ee5.71) + percentage of 3 (i.e. How much 3 is fraction of 35 ?) *Item* *Quantity* *Cumuletive Sum* A 2 5.71% B 3 C 4 D 5 E 6 F 7

Re: $$Excel-Macros$$ Query

2010-12-02 Thread anil panchal
Dear Nikhil, Please find the attached file. There is duplicate name if name is Unique ?? On Thu, Dec 2, 2010 at 5:20 PM, Daniel wrote: > Is it possible that the names list were sorted ? > > Then you may use : > > =OFFSET($I$3,MATCH($E$3,$I$4:$I$17,0),1,COUNTIF($I$4:$I$17,$E$3)) > > as the

Re: $$Excel-Macros$$ Query

2010-12-02 Thread Nikhil Shah
Dear Daniel Thanks for FormulaYou have solve my problem.. Regards Nikhil Shah On Thu, Dec 2, 2010 at 5:20 PM, Daniel wrote: > Is it possible that the names list were sorted ? > > Then you may use : > > =OFFSET($I$3,MATCH($E$3,$I$4:$I$17,0),1,COUNTIF($I$4:$I$17,$E$3)) > > as the source dat

Re: $$Excel-Macros$$ Query

2010-12-02 Thread vidyut more
On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah wrote: > Dear All Members, > > Here I am postin excel sheet.. > > *I used vlookup formula plz see attchmt > * > > -- > > -- > Some important links for excel users: > 1. Fol

Re: $$Excel-Macros$$ Query

2010-12-02 Thread mukesh kumar
Hi Nikhil, Please find attached solved sheet. Thanks & Regards Mukesh On Thu, Dec 2, 2010 at 12:53 PM, Nikhil Shah wrote: > Dear All Members, > > Here I am postin excel sheet.. > > *Problem : > * > *when I select the "NAME" I want the "POLICY NOS." of that perticular > "NAME" only in the Dr

RE: $$Excel-Macros$$ Query

2010-12-02 Thread Daniel
Is it possible that the names list were sorted ? Then you may use : =OFFSET($I$3,MATCH($E$3,$I$4:$I$17,0),1,COUNTIF($I$4:$I$17,$E$3)) as the source data. Best regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De la part de Nikhil Shah Envoyé : jeudi

$$Excel-Macros$$ Query

2010-12-02 Thread Nikhil Shah
Dear All Members, Here I am postin excel sheet.. *Problem : * *when I select the "NAME" I want the "POLICY NOS." of that perticular "NAME" only in the Drop List menu.* For Ex. If I selet the name as Nikhil then all the policy Nos. of NIKHIL only. Pl help me out to solve my problem..I DO Not