quot;"))&IF($A3=$IU$25,"Kolkata",""))
>
> I tried something similar using 'Custom' in the Data Validation dialog box,
> but it wouldn't work.
> However, when I selected 'List' with the same formula, I got a drop-down
> wh
hi umed
check this one also
On 12/23/09, Mahesh wrote:
> Hi All,
>
> I have some problem in validation,(Creating drop down list)
>
> Please check the below mention formula.
>
> =IF($A3=$IU$2,TN,IF($A3=$IU$6,North,IF($A3=$IU$12,South,IF($A3=$IU$15,West,IF($A3=$IU$18,East,""&IF($A3=$IU5,Delhi,IF(
st' with the same formula, I got a drop-down which
did work.
Regards - Dave.
Date: Wed, 23 Dec 2009 09:45:17 +0530
Subject: Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.
From: mahender.bi...@gmail.com
To: excel-macros@googlegroups.com
Hi All,
I have some problem in validat
Hi All,
I have some problem in validation,(Creating drop down list)
Please check the below mention formula.
=IF($A3=$IU$2,TN,IF($A3=$IU$6,North,IF($A3=$IU$12,South,IF($A3=$IU$15,West,IF($A3=$IU$18,East,""&IF($A3=$IU5,Delhi,IF($A3=$IU$24,Mumbai,""))&IF($A3=$IU$25,Kolkata,""))
It working fine
Thanks :)
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Tue, Nov 24, 2009 at 11:50 PM, Hemant Hegde wrote:
> That is cool! Thanks Sir :)
>
> On 24/11/2009, Dilip Pandey wrote:
>
>> you are welcome..!!
That is cool! Thanks Sir :)
On 24/11/2009, Dilip Pandey wrote:
>
> you are welcome..!!
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
> On 11/20/09, Umed Singh wrote:
>>
>>
you are welcome..!!
Best Regards,
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On 11/20/09, Umed Singh wrote:
>
> Thanks.
>
> On 11/19/09, Dilip Pandey wrote:
> > Hi Umed,
> >
> > Please find the solution
Thanks.
On 11/19/09, Dilip Pandey wrote:
> Hi Umed,
>
> Please find the solution attached with this email. Thanks.
> --
> DILIP KUMAR PANDEY
> MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
>
> On Thu, Nov 19, 2009 at 5:5
Hi Umed,
Please find the solution attached with this email. Thanks.
--
DILIP KUMAR PANDEY
MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062
On Thu, Nov 19, 2009 at 5:56 PM, Umed Singh wrote:
> Please attached the correct file here.
>