Re: $$Excel-Macros$$ Conditional Count with Conditions on Raws & Columns

Dear Amit, first of all it is an array formula, you can check formula, using Evaluate Formula command, under Formula Tab. It is difficult to explain on mail that how is this formula working. Sorry, But evaluate formula can explain. try it. Regards, Waseem Saifi On Fri, Oct 11, 2013 at 8:51 PM,

$$Excel-Macros$$ Re: Assemble open files in numerical order

Ooops I have found the answer. There is no need to respond...but thanks for reading On Saturday, 12 October 2013 13:32:35 UTC+11, Gavin Scott wrote: > > I run an export process from a webpage that creates a series of CSV files > whose names look like this: >CSVData >CSVData(1) >CSV

$$Excel-Macros$$ Assemble open files in numerical order

I run an export process from a webpage that creates a series of CSV files whose names look like this: CSVData CSVData(1) CSVData(2) and so on. . What I want to do is write some code that will; With Open CSV worksheets Add all worksheets to the worksheet that has the lowest number

$$Excel-Macros$$ Re: Add worksheets in creation date order

Hang on, I have just discovered that I do not think CreationDate lists the answer to the second, only the minute. Therefore this approach won't work. I will post in a separate thread another approach.. On Saturday, 12 October 2013 12:49:43 UTC+11, Gavin Scott wrote: > > I run a an export from a

$$Excel-Macros$$ Add worksheets in creation date order

I run a an export from a web page that creates a number of CSV files. What I would like to do is create some code that will; With all of the displayed exported CSV files open in excel; Using Creation Date Determine oldest file first (they are all created within 20 seconds of one anoth

Re: $$Excel-Macros$$ Help required in a small formula.....

This formula have 6 part *=1-(**(B3/D2)^2**+**(B4/D2)^2**+**(B5/D2)^2**+**(B5/D2)^2**+**(B6/D2)^2**+**(B7/D2)^2**)* And this Only 5 Part, Purple part was missing *=1-(**(1/5)^2**+**(1/5)^2**+**(1/5)^2**+**(1/5)^2**+**(1/5)^2**)* On 12-10-2013 3:52, Indrajit $nai wrote: Hello Experts, Kindly fi

$$Excel-Macros$$ Help required in a small formula.....

Hello Experts, Kindly find attached the file, and can anyone please explain me why the results are comming different by using the same kind of formula in the column no. E2 and E4? Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confident

$$Excel-Macros$$ how to see the source code in this excel5 .xla file

I want to know how to open the source code VBA of this file. It is a .xla file and it was created in Excel 5. Perhaps there is a password to open it. But i don't know the password. https://www.hightail.com/dl?phi_acti...w&smtNoRedir=1

Re: $$Excel-Macros$$ Error while opening file

Use file extension finder (Software).. . Enjoy Team XLS On Fri, Oct 11, 2013 at 9:24 AM, Rajan sharma wrote: > > Dear Experts, > >I am unable to open the excel file. i am getting like the attached > file. please provide me a solution. > > > > With warm regards, > R

$$Excel-Macros$$ Re: Need some help modifying a copy and paste routine

I guess what I am asking is way more complex than I thought, I can't seem to get a push in the right direction anywhere. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discu

RE: $$Excel-Macros$$ Conditional Count with Conditions on Raws & Columns

Thanks a lot.. Can you please also explain me how this works?s Regards, Amit Desai - MIS Manager M: +91 9867232534 [cid:image001.jpg@01CEC6C3.A9D00DF0] [cid:image002.jpg@01CEC6C3.A9D00DF0][cid:image003.jpg@01CEC6C3.A9D00DF0] From: excel-macros@googlegroups.com [

Re: $$Excel-Macros$$ Conditional Count with Conditions on Raws & Columns

Dear Amit, PFA result as you desire Regards, Waseem Saifi On Fri, Oct 11, 2013 at 6:01 PM, Amit Desai (MERU) wrote: > Dear Friends, > > ** ** > > Please help me with the conditional count formula. Conditions needs to be > applied on both Columns & Raws…Please see attached sample file.***

$$Excel-Macros$$ Conditional Count with Conditions on Raws & Columns

Dear Friends, Please help me with the conditional count formula. Conditions needs to be applied on both Columns & Raws...Please see attached sample file. Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may al

$$Excel-Macros$$ urgent Requirement

This is Divaker from Nine Dimensions Infotech Pvt ltd.. I would like to inform you that my company has vacancy for a Software Engineer having skill on Excel, VBA and Basic SQL. Please forward me your resume as soon as possible if you are interested. by providing Rating in below brackets Basic E

Re: $$Excel-Macros$$ Urgent Requirement

Location?? On Fri, Oct 11, 2013 at 4:35 PM, Divaker Pandey wrote: > This is Divaker from Nine Dimensions Infotech Pvt ltd.. I > would like to inform you that my company has vacancy for a Software > Engineer > > having skill on Excel, VBA and Basic SQL. > > Please forward me your resume as soon

$$Excel-Macros$$ Urgent Requirement

This is Divaker from Nine Dimensions Infotech Pvt ltd.. I would like to inform you that my company has vacancy for a Software Engineer having skill on Excel, VBA and Basic SQL. Please forward me your resume as soon as possible if you are interested. by providing Rating in below brackets Basic E

Re: $$Excel-Macros$$

Dear Raj Kumar, Pls find attached herewith. Warm Regards, Gawli Anil Thanks & Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd On Fri, Oct 11, 2013 at 3:48 PM, Raj Kumar wrote: > Hi Guru, > > We have to calculate based on id of "Raj" & "Mohan" through Sumifs fo

$$Excel-Macros$$

Hi Guru, We have to calculate based on id of* "Raj" & "Mohan"* through Sumifs formula in sheet1. i.e total Qty should be reflect 150 in id 1. so kindly help. Regards Raj -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook

Re: $$Excel-Macros$$ Autofill while typing in a cell

Respected Pavan, Excel 2013 does provide the function of auto-fill which may be suitable for your requirements. Regards, Vijaykumar On Fri, Oct 11, 2013 at 10:08 AM, Eugene Bernard wrote: > Dear Anil, > > I get an error "Can't find the project or library" , at the second line > "Dim Myconnec

Re: $$Excel-Macros$$ Display Vlookup dialog box with vba code

Respected Douglous, I don't know how to open or do vlookup by VBA using dialog box,but if you are using excel 2007 then you can have lookup wizard. Click the Microsoft Office Button , click Excel Options, and then click the Add-ins category. In the Manage box, click Excel Add-ins, and then cli