Re: $$Excel-Macros$$ Re: Help on Macro

2012-09-30 Thread Shrinivas Shevde
Dear Don, Thanks for reply. Please find details what I want. 1.I have many raw material.Consider I have 50 raw material 2.I want to make a sample with this raw material.While making sample I will use some of the material out of 50 .% of the material wull vary . 3.To do this what I noted down all t

Re: $$Excel-Macros$$ Re: Benford's Laws in excel

2012-09-30 Thread Vabz
Sorry,.. Link Rgds On Monday, October 1, 2012 1:57:12 AM UTC+5:30, David Grugeon wrote: > > Can't see the link?? > > Just google Benford's law excel and you get a heap of good explantions > how to use it. > Regards > David

Re: $$Excel-Macros$$ Re: Benford's Laws in excel

2012-09-30 Thread David Grugeon
Can't see the link?? Just google Benford's law excel and you get a heap of good explantions how to use it. Regards David Grugeon On 30 September 2012 23:40, Vabz wrote: > Hi > > Follow this link.. > > Cheers.. > > Regards//Vabs > > > On Sunday, September 30, 2012 8:52:26 AM UTC+5:30, sandeep ch

Re: $$Excel-Macros$$ Abridged summary of excel-macros@googlegroups.com - 32 Messages in 8 Topics

2012-09-30 Thread Rashid Khan
Hello All, I am using Excel 2010. I have a List of Names in Sheet name “List” I have attached a file with two modules. *Module1* Macro creates separate sheet with the names listed in the sheet name List and copies Sheet Data for each name. *Module2* makes Pivot Table on the Active Sheet. M

$$Excel-Macros$$ Re: Query

2012-09-30 Thread Don Guillett
I LOOKED at the provided file and gave proper answers including the "homework" question about sumproduct. On Friday, September 28, 2012 7:24:58 AM UTC-5, Aamir Shahzad wrote: > > Dear Group, > > When I mannualy enter the "C7" into the following formula, i

$$Excel-Macros$$ Re: WAV FILES DURATION FINDER

2012-09-30 Thread Vabz
Hi Is this of any use? Rgds//Vabs On Friday, September 28, 2012 11:05:30 AM UTC+5:30, Vabz wrote: > > Hi Bhasker & Reshma > > PFA excel file with macro.. > > This macro extracts wav file properties, you can keep the data you want & > discard unwanted.. > > Cheers.. > > Rgds//Vabs > > > On Thurs

$$Excel-Macros$$ Re: Query

2012-09-30 Thread Vabz
Hi You getting error because you are multiplying array with not value of Cell C2 but just text C2. Rgds//Vabs On Friday, September 28, 2012 5:54:58 PM UTC+5:30, Aamir Shahzad wrote: > > Dear Group, > > When I mannualy enter the "C7" into the following formula, it has no > problem, > > =S

$$Excel-Macros$$ Re: Benford's Laws in excel

2012-09-30 Thread Vabz
Hi Follow this link.. Cheers.. Regards//Vabs On Sunday, September 30, 2012 8:52:26 AM UTC+5:30, sandeep chhajer wrote: > > Good morning to all, > > Do any one have macros or aad-in on Benford's law. > > > Sandeep Chhajer. > Sent on my BlackBerry® from Vodafone -- Join official facebook pa