Hi Dilip, Swapnal, Vidyut, Bala and Satish,
Thanks a million for your reply and solution!!
Regards,
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]on
Behalf Of TERTIUS KOSHY THOMAS
Sent: Monday, June 29, 200
Hi Thomas,
Your query has been solved and attached herewith. Thanks.
Thanks & Regards
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Mon, Jun 29, 2009 at 6:52 AM, TERTIUS KOSHY THOMAS <
tert...@hees.hitach
Hi,
Following formula will solve your problem:
=IF(INT(LEFT(RC[-1], FIND("M", RC[-1])-2))<1000,1,"NA")
I am also attaching file herewith.
Regards,
Swapnil.
On Mon, Jun 29, 2009 at 6:52 AM, TERTIUS KOSHY THOMAS <
tert...@hees.hitachi.com.sg> wrote:
>
> Hi all,
> Can you help me with a small quer
hi,
use this formula : =IF(INT((LEFT(A2,LEN(A2)-1)))<1000,1,"NA")
with regards
BALA
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Vide
Hi,
Please check the attached solution, let me know if it solves your query.
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of TERTIUS KOSHY THOMAS
Sent: 29 June 2009 06:52 am
To: excel-macros@googlegroups.com
Subject: $$