$$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Pravin Gunjal
Hi, The sample file is attached , in which I want the serial numbers to come automatically based on the Invoice Numbers changes. Thanks, Pravin Gunjal. -- 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 @

Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Abhishek Jain
Please see. On Thu, May 2, 2013 at 1:13 PM, Pravin Gunjal isk1...@gmail.com wrote: Hi, The sample file is attached , in which I want the serial numbers to come automatically based on the Invoice Numbers changes. Thanks, Pravin Gunjal. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel?

Fwd: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Pravin Gunjal
*Thanks Abhishek.* -- Forwarded message -- From: Abhishek Jain abhishek@gmail.com Date: Thu, May 2, 2013 at 2:01 PM Subject: Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry To: excel-macros@googlegroups.com Please see. On Thu, May 2, 2013 at 1:13 PM

Fwd: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Pravin Gunjal
-Macros$$ Serial numbers to come based on the changed entry To: excel-macros@googlegroups.com *Thanks Abhishek.* -- Forwarded message -- From: Abhishek Jain abhishek@gmail.com Date: Thu, May 2, 2013 at 2:01 PM Subject: Re: $$Excel-Macros$$ Serial numbers to come based

Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Abhishek Jain
Subject: Fwd: $$Excel-Macros$$ Serial numbers to come based on the changed entry To: excel-macros@googlegroups.com *Thanks Abhishek.* -- Forwarded message -- From: Abhishek Jain abhishek@gmail.com Date: Thu, May 2, 2013 at 2:01 PM Subject: Re: $$Excel-Macros$$ Serial

Fwd: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Pravin Gunjal
Subject: Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry To: excel-macros@googlegroups.com Dear Pravin, Do not compare both formulas as in your file Column C was blank, I tried something there but it didn't pan out but I forgot to remove it. The actual formula is in Column F

Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Abhishek Jain
. -- Forwarded message -- From: Abhishek Jain abhishek@gmail.com Date: Thu, May 2, 2013 at 4:04 PM Subject: Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry To: excel-macros@googlegroups.com Dear Pravin, Do not compare both formulas as in your

Fwd: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Pravin Gunjal
*Very kind of you.. Thanks Abhishek.* -- Forwarded message -- From: Abhishek Jain abhishek@gmail.com Date: Thu, May 2, 2013 at 5:23 PM Subject: Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry To: Pravin Gunjal isk1...@gmail.com Cc: excel-macros

Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry

2013-05-02 Thread Abhishek Jain
Date: Thu, May 2, 2013 at 5:23 PM Subject: Re: $$Excel-Macros$$ Serial numbers to come based on the changed entry To: Pravin Gunjal isk1...@gmail.com Cc: excel-macros@googlegroups.com =IF(C6=,,IF(C6=C5,D5,D5+1)) Drag Down. On Thu, May 2, 2013 at 5:18 PM, Pravin Gunjal isk1...@gmail.com