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 @
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?
*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
-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
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
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
.
-- 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
*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
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