Thanks a lot
Regards
Jafna
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not be answered.
2) Don't
Thanks .
Thanks & Regards,
*Deba Ranjan P*
On Wed, May 23, 2012 at 5:05 PM, NOORAIN ANSARI wrote:
> *=IF(B3<>"","LD000"&SUBTOTAL(3,$B$3:B3),"")*
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help
Dear Deba,
Please try it..
*=IF(B3<>"","LD000"&SUBTOTAL(3,$B$3:B3),"")*
It will work on filtered data also.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 22, 2012 at 12:32 PM, Deba Ranjan wrote:
> *Dear Experts and Sir,
>
>
> *While o
Hello Deba,
FYI:
If you use "LD000" as constant this will add with each number, means when
gets 10-99, this will become, LD00010, when gets 100-999 will become
LD000100.
If you want to keep the format, "LD", 1-9 - LD0001, 10-99 - LD0010,
100-999 - LD0100, 1000- - LD1000, here is on
*Dear Anil and Experts,
The formula you have given was absolutely correct. Thanks once again for
the same. Thank you very very much.*
Thanks & Regards,
Deba Ranjan P
On Tue, May 22, 2012 at 3:53 PM, hilary lomotey wrote:
> Just add =if(b3<>"","LD000","")&if(b3<>"",counta(b$3:b3),"")
Just add =if(b3<>"","LD000","")&if(b3<>"",counta(b$3:b3),"")
On Tue, May 22, 2012 at 10:10 AM, Deba Ranjan wrote:
> *
> *Hi Anil Sir,
>
> Thats fine working, but i need in this look:- LD0001, LD0002,
> LD0003so on. Can you please do on this !! actually your attached file
> is fine working
*
*Hi Anil Sir,
Thats fine working, but i need in this look:- LD0001, LD0002,
LD0003so on. Can you please do on this !! actually your attached file
is fine working in serial numbers. Please i want the serial in LD0001,
LD0002so on. Please and thanks Anil sir, and other experts.
Thanks
