$$Excel-Macros$$ 4 quadrants graph help required

2014-03-03 Thread rekha siri
Hi Friends, Please need your expert help in building 4 quadrant graph help. Below is data for which 4 quadrant graph is required. Company Spend Risk A 10 5% B 10 30% C 40 60% D 100 5% i am attaching word doc in which i have drawn graph which looks like. Please help in this

$$Excel-Macros$$ Re: 4 quadrants graph help required

2014-03-03 Thread Rajan Verma
see the attached. On Monday, 3 March 2014 01:55:00 UTC-7, rekha siri wrote: Hi Friends, Please need your expert help in building 4 quadrant graph help. Below is data for which 4 quadrant graph is required. Company Spend Risk A 10 5% B 10

$$Excel-Macros$$ Re: Count of 1, 2, 3..... in a range

2014-03-03 Thread Rajan Verma
Put your number like 1,2,3 in B3 and so on and apply this formula with CSE in C3, c4 and so on. =SUM(N(VALUE(TRIM(MID(SUBSTITUTE($B$1:$FP$1,,,REPT( ,LEN($B$1:$FP$1))),((ROW(INDIRECT(1:LEN($B$1:$FP$1)))-1)*LEN($B$1:$FP$1)+1),LEN($B$1:$FP$1=B3)) On Saturday, 1 March 2014 04:30:53 UTC-7,

$$Excel-Macros$$ Re: Array from range

2014-03-03 Thread Rajan Verma
you should give column dimension in this below line BETADEG(s) it should be like BETADEG(s,1) On Friday, 28 February 2014 07:23:35 UTC-7, Gerrit Grundling wrote: Greetings, all What am I doing wrong here? I am trying to create an array from a range, but keep getting the Run-time error

$$Excel-Macros$$ Re: Two-dimensional interpolation

2014-03-03 Thread Rajan Verma
Hi make your array as double data type not Long Thanks Rajan. n Wednesday, 26 February 2014 07:07:45 UTC-7, Gerrit Grundling wrote: Greetings, all I have attached some aerofoil data for a Clark Y foil. This data is also available in my spread sheet. The Reynolds number is given

$$Excel-Macros$$ Attach potentially multiple embedded OLEObjects from excel into an outlook message

2014-03-03 Thread Chip Hansel
I am working on sending an email based on inputs from one of several sheets. In addition to the specific cells i am using as body, a various sheet may have an embedded file (word, pdf, another excel spreadsheet and maybe more). How do I attach and embedded OLEObject or OLEObjects into that

Re: $$Excel-Macros$$ Attach potentially multiple embedded OLEObjects from excel into an outlook message

2014-03-03 Thread Anoop K Sharma
Please share you Excel file On Tue, Mar 4, 2014 at 3:54 AM, Chip Hansel chip.han...@gmail.com wrote: I am working on sending an email based on inputs from one of several sheets. In addition to the specific cells i am using as body, a various sheet may have an embedded file (word, pdf,