Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

2011-07-25 Thread Venkat CV
Hi haseeb&XLS, Thank u... *Best Regards,* *Venkat* *Chennai* On Tue, Jul 26, 2011 at 1:26 AM, Haseeb Avarakkan < haseeb.avarak...@gmail.com> wrote: > Hello Venkat, > > Use a separate sheet to get the unique offices. You can hide this sheet, if > you don't want to show. Also use dynamic range

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

2011-07-25 Thread XLS S
please find the link http://www.get-digital-help.com/2010/07/17/create-dependent-drop-down-lists-containing-unique-distinct-values-in-excel/ On Sun, Jul 24, 2011 at 3:49 PM, Venkatesan c wrote: > Dear All, > > I have attached sheet contains my query on Data Validation - Create a drop > down lis

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

2011-07-25 Thread Haseeb Avarakkan
Hello Venkat, Use a separate sheet to get the unique offices. You can hide this sheet, if you don't want to show. Also use dynamic range name, so it will update automatically when add/delete entries. Assume there are no blank cells in Data Col_A Offices. If there is blank change the formula in

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

2011-07-24 Thread Venkat CV
Hi Kaushik, Yes We can remove duplicates I want in Formula that's the reason... already got it.. Thanks for your suggestion * * *Best Regards,* *Venkat* * * On Mon, Jul 25, 2011 at 6:09 AM, KAUSHIK SAVLA wrote: > u can use removw duplicate option in excel. Data then available can bw > used as da

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

2011-07-24 Thread KAUSHIK SAVLA
u can use removw duplicate option in excel. Data then available can bw used as data validation range. On 7/24/11, Venkatesan c wrote: > Dear All, > > I have attached sheet contains my query on Data Validation - Create a drop > down list containing only unique > > > -- > *Best Regards,* > *Venkat*

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

2011-07-24 Thread Venkat CV
Hi Dilip, ThanksWorking... *Best Regards,* *Venkat* * * * * On Sun, Jul 24, 2011 at 11:47 PM, Dilip Pandey wrote: > Hi Venkat, > > I have managed to solve your query using defined Names in Excel. > > Let me know if this works. > > Regards, > DILIPandey > > On 7/24/11, Venkatesan c wrote:

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

2011-07-24 Thread Dilip Pandey
Hi Venkat, I have managed to solve your query using defined Names in Excel. Let me know if this works. Regards, DILIPandey On 7/24/11, Venkatesan c wrote: > Dear All, > > I have attached sheet contains my query on Data Validation - Create a drop > down list containing only unique > > > -- > *B

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

2011-07-24 Thread Venkat CV
macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > *De la part de* Venkatesan c > *Envoyé :* dimanche 24 juillet 2011 12:19 > *À :* Google > *Objet :* $$Excel-Macros$$ Data Validation - Create a drop down list > containing only unique > > ** ** > > Dear

Re: $$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

2011-07-24 Thread Venkat CV
half Of *Venkatesan c > *Sent:* Sunday, July 24, 2011 3:49 PM > *To:* Google > *Subject:* $$Excel-Macros$$ Data Validation - Create a drop down list > containing only unique > > ** ** > > Dear All, > > ** ** > > I have attached sheet contains my query on D

$$Excel-Macros$$ Data Validation - Create a drop down list containing only unique

2011-07-24 Thread Venkatesan c
Dear All, I have attached sheet contains my query on Data Validation - Create a drop down list containing only unique -- *Best Regards,* *Venkat* * * * * -- -- Some important links for excel users: 1. Follow us on