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 talk2mar...@gmail.com wrote: Find the attachment... On Wed, Dec 14, 2011 at 10:00 PM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Hi Sourabh, Used a different Tab (Unique Tab) for the calculations. Whenever you update your data tab all the unique names will get here.On the drop down, you only can see the unique names it's correspondent Enroll Numbers. You can hide this sheet, if you don't want to visible to others. Hope this helps Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 noorain.ans...@gmail.comwrote: Dear Sourabh, Please see attached sheet.. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Thu, Dec 15, 2011 at 7:52 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote: 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 talk2mar...@gmail.com wrote: Find the attachment... On Wed, Dec 14, 2011 at 10:00 PM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Hi Sourabh, Used a different Tab (Unique Tab) for the calculations. Whenever you update your data tab all the unique names will get here.On the drop down, you only can see the unique names it's correspondent Enroll Numbers. You can hide this sheet, if you don't want to visible to others. Hope this helps Haseeb -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay
$$Excel-Macros$$ urgent query on dropdown list
Dear Sir, plz download the attached file. detail query in file. Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com QUERY.xls Description: MS-Excel spreadsheet
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 SalesAid Software dguille...@gmail.com From: Sourabh Salgotra Sent: Tuesday, December 13, 2011 11:21 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ urgent query on dropdown list Dear Sir, plz download the attached file. detail query in file. Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 dguille...@gmail.com 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. 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 SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Tuesday, December 13, 2011 11:21 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ urgent query on dropdown list Dear Sir, plz download the attached file. detail query in file. Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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 dguille...@gmail.com 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. 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 SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Tuesday, December 13, 2011 11:21 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ urgent query on dropdown list Dear Sir, plz download the attached file. detail query in file. Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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) counts the number of cells within a range that meet the given condition COUNTIF(List, List)+1 becomes COUNTIF({DD;EE;FF;EE;GG;BB;FF;GG;DD;TT;FF;VV;VV;FF}, {DD;EE;FF;EE;GG;BB;FF;GG;DD;TT;FF;VV;VV;FF})+1 becomes {11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1 becomes {12;10;6;10;4;14;6;4;12;3;6;1;1;6} On Wed, Dec 14, 2011 at 4:27 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote: 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 dguille...@gmail.com 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. 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 SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Tuesday, December 13, 2011 11:21 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ urgent query on dropdown list Dear Sir, plz download the attached file. detail query in file. Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
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)+(snameimage!$A$14),0)) but the list is not in sorted order. On Wed, Dec 14, 2011 at 5:26 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote: *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) counts the number of cells within a range that meet the given condition COUNTIF(List, List)+1 becomes COUNTIF({DD;EE;FF;EE;GG;BB;FF;GG;DD;TT;FF;VV;VV;FF}, {DD;EE;FF;EE;GG;BB;FF;GG;DD;TT;FF;VV;VV;FF})+1 becomes {11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1 becomes {12;10;6;10;4;14;6;4;12;3;6;1;1;6} On Wed, Dec 14, 2011 at 4:27 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote: 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 dguille...@gmail.comwrote: 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 SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Tuesday, December 13, 2011 11:21 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ urgent query on dropdown list Dear Sir, plz download the attached file. detail query in file. Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula
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)+(snameimage!$A$14),0)) but the list is not in sorted order. plz explain the following fourmula *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) counts the number of cells within a range that meet the given condition COUNTIF(List, List)+1 becomes COUNTIF({DD;EE;FF;EE;GG;BB;FF;GG;DD;TT;FF;VV;VV;FF}, {DD;EE;FF;EE;GG;BB;FF;GG;DD;TT;FF;VV;VV;FF})+1 becomes {11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1 becomes {12;10;6;10;4;14;6;4;12;3;6;1;1;6} * * On Wed, Dec 14, 2011 at 4:27 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote: 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 dguille...@gmail.comwrote: 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 SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Tuesday, December 13, 2011 11:21 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ urgent query on dropdown list Dear Sir, plz download the attached file. detail query in file. Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy