Re: $$Excel-Macros$$ Macro hangs

2010-09-29 Thread Angelo Spinola
Dear Friend, How much time did it take to get the result? Regards, Angelo 2010/9/29 ashish koul > hi > > check the attchment see it it helps you > > you can apply the filter and delte all rows with "d" and then remove the > temp column > > > > > > > On Wed, Sep 29, 2010 at 2:44 PM, Dave Bonall

Re: $$Excel-Macros$$ if iteration

2010-08-14 Thread Angelo Spinola
le. The > more information you give us about your problem, the easier will be to > understand what you really want and help you. > > Regards > > > On Fri, Aug 13, 2010 at 7:48 PM, Angelo Spinola > wrote: > >> Hi, >> >> thanks, yes, is the number of if it

Re: $$Excel-Macros$$ if iteration

2010-08-13 Thread Angelo Spinola
Hi, thanks, yes, is the number of if iteration ilimited? Regards 2010/8/12 Bruno Bruno > See if it's this what you want. > > > On Thu, Aug 12, 2010 at 12:40 PM, Angelo Spinola > wrote: > >> Dear Bruno, >> >> I will send you an attachment, so i can ma

Re: $$Excel-Macros$$ if iteration

2010-08-12 Thread Angelo Spinola
Dear Bruno, I will send you an attachment, so i can make this clear. Result is based on size and code as you can see... i have put some sample data for column that i desire that is result. Regards, Angelo Spinola 2010/8/12 Bruno Bruno > Hi Angelo, > I'm still confused about exact

Re: $$Excel-Macros$$ if iteration

2010-08-11 Thread Angelo Spinola
le > formula? Something like: > > =IF(MOD(CODE(A1);2)=1;A1;REPT(CHAR(CODE(A1)+1);3)) > > Where A1 is the cell with "aaa" > > > On Tue, Aug 10, 2010 at 6:23 PM, Angelo Spinola > wrote: > >> Hello, >> >> >> How can i create and iterat

$$Excel-Macros$$ if iteration

2010-08-10 Thread Angelo Spinola
Hello, How can i create and iteration for: If cell 1 is "aaa" then leave it the same else if cell "bbb" then change it to "ccc" and continue Can you use other type of iteration...like for example switch or for? Regards to all member, Thanks! --

Re: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1

2010-08-05 Thread Angelo Spinola
at it straight away, but if no one else comes up > with anything, I'll have a look later. > > Regards - Dave. > > > > From: spinolaang...@gmail.com > > Date: Mon, 2 Aug 2010 12:54:55 +0100 > > Subject: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1 &g

Re: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1

2010-08-03 Thread Angelo Spinola
ed by 1 > To: excel-macros@googlegroups.com > > > Forgot the attachment, sorry :) > > 2010/8/2 Angelo Spinola > > Hello All, > > I need a formula that > Checks if B,C, D are the sameif equal (could have more than just two > equal) sums the Columns E and F and replace

$$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1

2010-08-02 Thread Angelo Spinola
Forgot the attachment, sorry :) 2010/8/2 Angelo Spinola > Hello All, > > I need a formula that > Checks if B,C, D are the sameif equal (could have more than just two > equal) sums the Columns E and F and replace it for just one Line instead of > having duplicates or tripli

$$Excel-Macros$$ URGENT: Sum of 2 Lines replaced by 1

2010-08-02 Thread Angelo Spinola
Hello All, I need a formula that Checks if B,C, D are the sameif equal (could have more than just two equal) sums the Columns E and F and replace it for just one Line instead of having duplicates or triplicates. How can i create this ? With a Macro ? Regards. -- ---

Re: $$Excel-Macros$$ File Password for Excel

2010-08-01 Thread Angelo Spinola
how is it possible to doi this ? :) Regards 2010/8/1 N.Shivkumar > Dear Kamlesh Jain > Is it possible to send me the file I will find the passwod > > BYe > > N.SHIVKUMAR > Mobile : +919422613567 > Office : +912332301775 > Alternate Email: shiv1...@yahoo.com > > > > On 31 July 2010 21:08, Vikas

Re: $$Excel-Macros$$ Maximum...URGENT!

2010-07-30 Thread Angelo Spinola
Hello, Thanks for the feedback, could you please help me out do a lookup.how can i retrieve the "code" attached to each maximum. The " code" column is on the left and for example ...the first column max 901 is related to code 107, how can i get that code! Regards and thanks! 2010/7

$$Excel-Macros$$ Maximum...URGENT!

2010-07-30 Thread Angelo Spinola
Hello, I urgently need to get the maximum value from Kgs column. But i have specific criteria, they have to have same "Date" and same "Code_number". How can i do this? Thanks for you help and regards -- -- Some im

$$Excel-Macros$$ 3 Criteria, Problem finding Maximum

2010-07-30 Thread Angelo Spinola
> > Hello All, > > I have a collumn called problem, in that collum i recieved a mapped value > but it is doing it wrong. > > > I need the formula to get the highest value in "*Kgs*" Column (criteria > same *date*, same *code_number)*. > > > Based on the *Kgs *Maximum value, it has to get the "*code

$$Excel-Macros$$ Maximum With Criteria...NEWBIE

2010-07-29 Thread Angelo Spinola
Hello All, I have a collumn called problem, in that collum i recieved a mapped value but it is doing it wrong. I need the formula to get the highest value in "*Kgs*" Column (criteria same *date*, same *code_number)*. Based on the *Kgs *Maximum value, it has to get the "*code*" on the left side