Re: $$Excel-Macros$$ urgent query on dropdown list

very very thanks sir. i want the list in dropdown list in sorted order. On Thu, Dec 15, 2011 at 9:17 AM, NOORAIN ANSARI wrote: > Dear Sourabh, > > Please see attached sheet.. > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ urgent query on dropdown list

thanks to all of you for help but in this sol name are repeating and not in sorted order On Thu, Dec 15, 2011 at 12:25 AM, Maries wrote: > Find the attachment... > > > On Wed, Dec 14, 2011 at 10:00 PM, Haseeb Avarakkan < > haseeb.avarak...@gmail.com> wrote: > >> Hi Sourabh, >> >> Used a dif

Re: $$Excel-Macros$$ urgent query on dropdown list

> > i have done everything with these fourmulas > =INDEX(sname,MATCH(0,COUNTIF($C$1:$C1,sname),0)) > =INDEX(eroll,MATCH(0,COUNTIF($B$1:$B1,eroll)+(sname<>image!$A$14),0)) > > > but the list is not in sorted order. > > plz explain the following fourmula > > *in the following formula plz explain t

Re: $$Excel-Macros$$ urgent query on dropdown list

thanks for help plz explain the following fourmula i have done everything with these fourmulas =INDEX(sname,MATCH(0,COUNTIF($C$1:$C1,sname),0)) =INDEX(eroll,MATCH(0,COUNTIF($B$1:$B1,eroll)+(sname<>image!$A$14),0)) but the list is not in sorted order. On Wed, Dec 14, 2011 at 5:26 AM, Sourabh Sa

Re: $$Excel-Macros$$ urgent query on dropdown list

*in the following formula plz explain the marked section how it become * {11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1 * * *Convert text to numbers* =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1:B1, List))*(*COUNTIF(List, ">"&List)+1*))=(COUNTIF(List, ">"&List)+1), 0, 1), 0)) COUNTIF(range,criteria) coun

Re: $$Excel-Macros$$ urgent query on dropdown list

through 2nd dropdown i want the extract the information of that student whose name & enroll no is selected. On Tue, Dec 13, 2011 at 11:35 PM, dguillett1 wrote: > You don’t say what you are to do with the SECOND drop down. Seems that > it should not be a drop down. > Anyway, a macro can: > 1.

Re: $$Excel-Macros$$ urgent query on dropdown list

Dear Saurabh Please visit below url. A similar case is neatly explained there. http://www.get-digital-help.com/2010/07/17/create-dependent-drop-down-lists-containing-unique-distinct-values-in-excel/ Regards Yahya On Tue, Dec 13, 2011 at 9:05 PM, dguillett1 wrote: > You don’t say what

Re: $$Excel-Macros$$ urgent query on dropdown list

You don’t say what you are to do with the SECOND drop down. Seems that it should not be a drop down. Anyway, a macro can: 1. make a list from your existing full list 2. As each name is selected, remove it from the created list. Or, if no longer needed, the original list. etc Don Guillett SalesA