Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.

2009-12-23 Thread Mahesh
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

Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.

2009-12-23 Thread ankur
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(

RE: $$Excel-Macros$$ Re: Please solve my prob.with validation.

2009-12-23 Thread Dave Bonallack
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

Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.

2009-12-22 Thread Mahesh
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

Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.

2009-11-25 Thread Dilip Pandey
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..!!

Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.

2009-11-24 Thread Hemant Hegde
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: >> >>

Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.

2009-11-24 Thread Dilip Pandey
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

Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.

2009-11-23 Thread Umed Singh
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

Re: $$Excel-Macros$$ Re: Please solve my prob.with validation.

2009-11-19 Thread Dilip Pandey
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. >