$$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers
Hi Friends, I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to extract the second biggest number from this list. Note: This list cannot be sorted. I have already found out how to do it from a sorted list. Also I would need this to be done possibly through a formula and not any UDF. -- Warm Regards, Andy -- 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$$ How to Extract the Second Biggest number from a list of numbers
Dear Aindril, Please use this one, =LARGE(A32:A40,2) - 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 1, 2011 at 3:51 PM, Aindril De aind...@gmail.com wrote: Hi Friends, I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to extract the second biggest number from this list. Note: This list cannot be sorted. I have already found out how to do it from a sorted list. Also I would need this to be done possibly through a formula and not any UDF. -- Warm Regards, Andy -- 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$$ How to Extract the Second Biggest number from a list of numbers
Dear Noorain, Thanks for the response. I have already tried this. This does not work. If you use this on the list i have mentioned. It generates 4 and not 2,, which should be the correct answer. Please note. This list has duplicate values. Regards, Andy On Thu, Dec 1, 2011 at 4:10 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Aindril, Please use this one, =LARGE(A32:A40,2) - 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 1, 2011 at 3:51 PM, Aindril De aind...@gmail.com wrote: Hi Friends, I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to extract the second biggest number from this list. Note: This list cannot be sorted. I have already found out how to do it from a sorted list. Also I would need this to be done possibly through a formula and not any UDF. -- Warm Regards, Andy -- 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 -- Warm Regards, Aindril De Ph: 9811300157 -- 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$$ How to Extract the Second Biggest number from a list of numbers
=LARGE(A1:G1,2) Regards jeet On Thu, Dec 1, 2011 at 3:51 PM, Aindril De aind...@gmail.com wrote: Hi Friends, I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to extract the second biggest number from this list. Note: This list cannot be sorted. I have already found out how to do it from a sorted list. Also I would need this to be done possibly through a formula and not any UDF. -- Warm Regards, Andy -- 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$$ How to Extract the Second Biggest number from a list of numbers
Thanks all.. On Thu, Dec 1, 2011 at 3:59 PM, Jitendra singh jeete2...@gmail.com wrote: =LARGE(A1:G1,2) Regards jeet On Thu, Dec 1, 2011 at 3:51 PM, Aindril De aind...@gmail.com wrote: Hi Friends, I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to extract the second biggest number from this list. Note: This list cannot be sorted. I have already found out how to do it from a sorted list. Also I would need this to be done possibly through a formula and not any UDF. -- Warm Regards, Andy -- 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 -- Warm Regards, Aindril De Ph: 9811300157 -- 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$$ How to Extract the Second Biggest number from a list of numbers
try this one, =LARGE(A2:A10,COUNTIF(A2:A10,MAX(A2:A10))+1) On Thu, Dec 1, 2011 at 5:32 PM, Aindril De aind...@gmail.com wrote: Thanks all.. On Thu, Dec 1, 2011 at 3:59 PM, Jitendra singh jeete2...@gmail.comwrote: =LARGE(A1:G1,2) Regards jeet On Thu, Dec 1, 2011 at 3:51 PM, Aindril De aind...@gmail.com wrote: Hi Friends, I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to extract the second biggest number from this list. Note: This list cannot be sorted. I have already found out how to do it from a sorted list. Also I would need this to be done possibly through a formula and not any UDF. -- Warm Regards, Andy -- 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 -- Warm Regards, Aindril De Ph: 9811300157 -- 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$$ How to Extract the Second Biggest number from a list of numbers
I think u r luking for second small value =SMALL(A32:A40,2) On Thu, Dec 1, 2011 at 4:17 PM, Aindril De aind...@gmail.com wrote: Dear Noorain, Thanks for the response. I have already tried this. This does not work. If you use this on the list i have mentioned. It generates 4 and not 2,, which should be the correct answer. Please note. This list has duplicate values. Regards, Andy On Thu, Dec 1, 2011 at 4:10 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Aindril, Please use this one, =LARGE(A32:A40,2) - 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 1, 2011 at 3:51 PM, Aindril De aind...@gmail.com wrote: Hi Friends, I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to extract the second biggest number from this list. Note: This list cannot be sorted. I have already found out how to do it from a sorted list. Also I would need this to be done possibly through a formula and not any UDF. -- Warm Regards, Andy -- 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 -- Warm Regards, Aindril De Ph: 9811300157 -- 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
$$Excel-Macros$$ About Marcros in 2007
Hi,Friends Any body give the refernce of MACRO IN EXECEL 2007, How can create and how do work the with macros Pls give me some example and reference Aivi K -- 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$$ How to Extract the Second Biggest number from a list of numbers
Dear All, Thanks for the help. I tried your solutions: The solutions with Large work with almost all the lists. But If you try this on a list 1,2,2,3,3 =LARGE(A1:A5,2) does not work None except Divaker's formula worked on that. I am wondering why.! Any Guesses? On Thu, Dec 1, 2011 at 5:48 PM, Divaker Pandey divake...@gmail.com wrote: try this one, =LARGE(A2:A10,COUNTIF(A2:A10,MAX(A2:A10))+1) On Thu, Dec 1, 2011 at 5:32 PM, Aindril De aind...@gmail.com wrote: Thanks all.. On Thu, Dec 1, 2011 at 3:59 PM, Jitendra singh jeete2...@gmail.comwrote: =LARGE(A1:G1,2) Regards jeet On Thu, Dec 1, 2011 at 3:51 PM, Aindril De aind...@gmail.com wrote: Hi Friends, I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to extract the second biggest number from this list. Note: This list cannot be sorted. I have already found out how to do it from a sorted list. Also I would need this to be done possibly through a formula and not any UDF. -- Warm Regards, Andy -- 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 -- Warm Regards, Aindril De Ph: 9811300157 -- 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 -- Warm Regards, Aindril De Ph: 9811300157 -- 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
Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers
=LARGE($I$3:$I$23,ROW(A1)) copy down to give 5,4,4,3,3,2 Don Guillett SalesAid Software dguille...@gmail.com From: Aindril De Sent: Thursday, December 01, 2011 4:21 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers Hi Friends, I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to extract the second biggest number from this list. Note: This list cannot be sorted. I have already found out how to do it from a sorted list. Also I would need this to be done possibly through a formula and not any UDF. -- Warm Regards, Andy -- 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$$ How to Extract the Second Biggest number from a list of numbers
2011/12/1 dguillett1 dguille...@gmail.com =LARGE($I$3:$I$23,ROW(A1)) copy down to give 5,4,4,3,3,2 Don Guillett SalesAid Software dguille...@gmail.com *From:* Aindril De aind...@gmail.com *Sent:* Thursday, December 01, 2011 4:21 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers Hi Friends, I have a list of numbers, for e.g. 1,3,2,4,2,3,4,5,2. I would need to extract the second biggest number from this list. Note: This list cannot be sorted. I have already found out how to do it from a sorted list. Also I would need this to be done possibly through a formula and not any UDF. -- Warm Regards, Andy -- 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 01. Find a smallest number in the range A2: A10 I found using this new function like the right result. =SMALL(A32:A40,1) =SMALL(A2:A10,COUNTIF(A2:A10,MAX(A2:A10))+0) 02. Find one of the largest in the range A2: A10 I found using this new function like the right result. =LARGE(A32:A40,1) =LARGE(A3:A11,COUNTIF(A3:A11,MAX(A3:A11))+0) -- 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
$$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs
Hi, Join the Fashion Group and get 1000rs on intial enrollment and get waived off in the initial transaction Fashion Group : A Place with more discounts and less money incurred...join in and believe it Believe it with below link : http://www.fashionandyou.com/fashionandyou-client-http-shop/shop Thanks Surya -- 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$$ Re: Almost all calculator in one sheet
2011/11/30 Silviu Felician feliciansil...@gmail.com Hello, Your file is awesome, but it would be best if you gave us also the password, most sheets in this file are locked and I want to be able to play with the formulas and not just use the file as it is. Thanks! -- 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 I do not understand you mentioned File no water spinach? if it is, Iwill open the Password and upload -- 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$$ Fashion and you -- Get Enrolled and Win 1000 rs
Excel Forums now-a-days being used for marketing activities Ashish On 01/12/2011 20:39, Mr Excellent wrote: Hi, Join the Fashion Group and get 1000rs on intial enrollment and get waived off in the initial transaction Fashion Group : A Place with more discounts and less money incurred...join in and believe it Believe it with below link : http://www.fashionandyou.com/fashionandyou-client-http-shop/shop Thanks Surya -- 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$$ Fashion and you -- Get Enrolled and Win 1000 rs
Be surya in sky ,and don't come here to shine with cheap stuff around. Respect the motive of this forum and I hope Ayush doesn't vanish u with this cheap act, be careful !!! Cheers Rahul. Sent from BlackBerry® on Airtel -Original Message- From: Ashish Pradhan ashlyprad...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 01 Dec 2011 22:16:42 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Fashion and you -- Get Enrolled and Win 1000 rs Excel Forums now-a-days being used for marketing activities Ashish On 01/12/2011 20:39, Mr Excellent wrote: Hi, Join the Fashion Group and get 1000rs on intial enrollment and get waived off in the initial transaction Fashion Group : A Place with more discounts and less money incurred...join in and believe it Believe it with below link : http://www.fashionandyou.com/fashionandyou-client-http-shop/shop Thanks Surya -- 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$$ Excel to Word
Hi Experts, Can somebody please suggest something for the below problem. i am stuck due to this issue. i tried google but in vein. please help me out. From: hanumant shinde arsfan2...@yahoo.co.in To: Excel Group excel-macros@googlegroups.com Sent: Tuesday, 29 November 2011 8:02 PM Subject: $$Excel-Macros$$ Excel to Word Hi, i want to copy paste data from Excel to specific location in microsoft word using Excel macro. i am able to copy paste it at the beginning of word document but not on specific location. below is my requirement. 1. i need to find specific word in microsoft word doc --- Done 2. just 1 place above that word i want to paste some data from Excel. can somebody pls tell me how can do it? Thanks,-- 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$$ Excel to Word
can you attach the sample document and send it to the group On Thu, Dec 1, 2011 at 11:10 PM, hanumant shinde arsfan2...@yahoo.co.inwrote: Hi Experts, Can somebody please suggest something for the below problem. i am stuck due to this issue. i tried google but in vein. please help me out. *From:* hanumant shinde arsfan2...@yahoo.co.in *To:* Excel Group excel-macros@googlegroups.com *Sent:* Tuesday, 29 November 2011 8:02 PM *Subject:* $$Excel-Macros$$ Excel to Word Hi, i want to copy paste data from Excel to specific location in microsoft word using Excel macro. i am able to copy paste it at the beginning of word document but not on specific location. below is my requirement. 1. i need to find specific word in microsoft word doc --- Done 2. just 1 place above that word i want to paste some data from Excel. can somebody pls tell me how can do it? Thanks, -- 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 -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- 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$$ Indirect Function
thanks Noorain / Chethan Kumar. Regards, Aamir Shahzad On Thu, Dec 1, 2011 at 9:03 AM, Dhartikumar Sahu dhartiku...@gmail.comwrote: hi chethan can u explain how u use getphoto in Indirect example 3. Thanks regards Dhartikumar Sahu On Thu, Dec 1, 2011 at 3:07 AM, B.N.Chethan Kumar chetankumar1...@gmail.com wrote: Hope these help. On Wed, Nov 30, 2011 at 11:47 PM, Aamir Shahzad aamirshahza...@gmail.com wrote: Dear Group, Please provide the Indirect Function samples how is it working when we use? Sample files will appreciate. Regards, Aamir Shahzad -- 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 -- B.N Chetan kumar -- 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 -- Regards, Aamir Shahzad -- 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
$$Excel-Macros$$ job
Please send your CV to -tgo...@teksystems.com or Call Tanya Gowda 080-30705491/962040 Dear Candidate There is an urgent requirement from one of th Fortune 100 US Based Client who are looking for Position- System Analyst Requirement Gathering MS Access MS excel Should analyse system issues and provide solutions Generate Ad Hoc reports- Sql Knowledge is required. Exp- 2.4yrs B.E/Btech, M.E/Mtech, Msc, MCA Interviews are happening on saturday, Please send your CV to - tgo...@teksystems.com or Call Tanya Gowda -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- 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
$$Excel-Macros$$ job
*Send your updated resume at anurad...@globali.in * * * * * * * *Experience required for the Job:* 3 - 6 years *Annual Salary of the Job:* 4.0 - 6.0 Lacs *Job Location:* Delhi/NCR *Dear Candidate,* Dear Candidate, I am Anuradha Gusain from Global InnovSource Solutions Pvt. Ltd. We are a Mumbai based HR services organization and provide services like Recruitment, HR Outsourcing and Corporate training to the leading organizations in the country. We have presence in 32 cities across India. Job Title - Data Ops Manager Location - Delhi Exp - 3.5 to 6 yrs Note- DOB of the candidate should not be within 1980. Salary: Depends on experience Job Description * Will be handling a team of around 30 Data Entry Operators. * Will be responsible for content management on the website for BMV Category. * Will have to set up the best processes for Data Operations. * Will have to prepare and share the reports on team productivity and also on work. * Will have to prepare Communication Protocols for coordination with various teams. * Improving Team TATs. * Data quality Management. * Skills Required - Good Team Handling Skills, Process Knowledge, Website Knowledge, Good Aptitude as coordination will be required with Technology team, Grounded as will be working directly with the executives initially, good communication skills. Requisite Skills - * MBA (Preferably Marketing) * Should have a good understanding of computers / electronics * Should have 'exceptional' communication skill * Extremely good in inter-personal skills - ability in striking conversation borne out with examples in prior work experience * Should have a good presentation * Should be an extroverted personality who enjoys being and talking with people, high energy level and a positive approach. * Should be a quick learner and target oriented. Send me your updated resume at anurad...@globali.in with subject as Data Operations Manager - Delhi Or would really appreciate if any suitable reference for the same can be provided .. Regard's, Anuradha Gusain -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- 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
$$Excel-Macros$$ job
Recruiters id Aditi Ghosh Origin Consulting Services E: ad...@originhr.in W: www.originhr.in * * * * *Experience required for the Job:* 2 - 4 years *Job Location:* Gurgaon *Dear Candidate,* Greetings! I am looking to hire Business Analysts to work with our MNC client in Gurgaon. Below are details. Appreciate if you can let me know your interest with updated resume and below details. * Willing to work in 6.00 pm - 3.00 am work hours? * Current Role: * Current Organization: * Current CTC: * Expected CTC: * Notice Period: Experience: 2- 4 years Synopsis of position requirement: * Strong expertise as Business Analyst working with operations and technology teams * Should have worked extensively on SQL Server, Excel, Reporting tools * Able to understand requirements, challenges, define high complexity of business workflows, problem resolutions, understanding of business system development/analysis * Strong analytical, writing, verbal and written communication skills Regards, Aditi Ghosh Origin Consulting Services E: ad...@originhr.in W: www.originhr.in -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- 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
$$Excel-Macros$$ job
*Recruiter id *kavitha.b.aarch...@gmail.com * * * * *Experience required for the Job:* 1 - 9 years *Annual Salary of the Job:* 3.0 - 14.0 Lacs *Dear Candidate,* Kindly Refer your friends, Colleagues having Experience in Retail/marketing Analytics,Collection Analytics, Statistical modeling, Data Modeling, Credit card Analytics, Risk Analytics, Score Card Development, Retail/Marketing Analytics with SAS tool preferred, for across the Role Experience:1.3 yrs to 7+ years of experience, Modeling Techniques, Score Card Development with SAS Education: M.Sc (Stat, Maths),MBA(Finance),BE from top university Location: Bangalore,Gurgaon Write with your updated resume along following details Present CTC, Expected CTC, Notice Period to -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- 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$$ How to Extract the Second Biggest number from a list of numbers
You can also use SMALL function like, =SMALL(A:A,FREQUENCY(A:A,MAX(A:A)-1)) will give the 2nd largest number, even if you have duplicate or not. ___ HTH, 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
Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers
or this copied down =SMALL(I:I,FREQUENCY(I:I,MAX(I:I)-(ROW(A1)-1))) Don Guillett SalesAid Software dguille...@gmail.com From: Haseeb Avarakkan Sent: Thursday, December 01, 2011 1:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers You can also use SMALL function like, =SMALL(A:A,FREQUENCY(A:A,MAX(A:A)-1)) will give the 2nd largest number, even if you have duplicate or not. ___ HTH, 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
$$Excel-Macros$$ Listbox: reset the pointer
I have code that writes a set of names to an array; when that set of names is complete a userform opens and the array populates a listbox. The user double clicks on a name to select it, and the userform hides. This process repeats numerous times. On the first cycle if the user selects the third name in the list, then on the next cycle the third name on the list is highlighted with what I'll call the pointer. How do I reset that pointer so it appears at the top of the list, rather than at the .ListIndex of the last selection? On the double click event I mentioned earlier (which closes the userform) I tried Listbox1.Clear, Listbox1.Listindex = -1, repopulating the listbox from a null array, and a number of other things, all to no avail. This is causing a problem because the listbox list can be fairly long, and when the pointer appears at the previous selection's ListIndex value it causes the user to think the list is a different size than it really is. Any ideas for how to reset the pointer? If it helps my code follows- Thanks, Dave O Private Sub UserForm_Activate() ListBox1.List = arrPropNames TextBox1.Text = FirstLast End Sub Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean) Chosen = ListBox1.Value UserForm1.Hide End Sub -- 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$$ How to Extract the Second Biggest number from a list of numbers
Hi Don, If you mean each row will show the 1st, 2nd, 3rd largest, etc., disregarding duplicates.. doesn't work for me. Tested with this somewhat arbirtary data set: 1 1 1 5 5 8 9 9 11 11 Your formulas return: 11 9 9 8 5 5 5 1 1 1 1 (Even more values than were in the original list) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Thursday, December 01, 2011 11:45 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers or this copied down =SMALL(I:I,FREQUENCY(I:I,MAX(I:I)-(ROW(A1)-1))) Don Guillett SalesAid Software dguille...@gmail.com From: Haseeb Avarakkan mailto:haseeb.avarak...@gmail.com Sent: Thursday, December 01, 2011 1:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers You can also use SMALL function like, =SMALL(A:A,FREQUENCY(A:A,MAX(A:A)-1)) will give the 2nd largest number, even if you have duplicate or not. ___ HTH, 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 -- 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$$ How to Extract the Second Biggest number from a list of numbers
Although the ORIGINAL post said nothing about DUPLICATES Using your sample, In P1 =LARGE(O:O,1) and in P2 =SMALL(O:O,COUNTIF(O:O,=Q1)-ROW(A2)) copied down Don Guillett SalesAid Software dguille...@gmail.com From: Asa Rossoff Sent: Thursday, December 01, 2011 4:29 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers Hi Don, If you mean each row will show the 1st, 2nd, 3rd largest, etc., disregarding duplicates…. doesn't work for me. Tested with this somewhat arbirtary data set: 1 1 1 5 5 8 9 9 11 11 Your formulas return: 11 9 9 8 5 5 5 1 1 1 1 (Even more values than were in the original list) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Thursday, December 01, 2011 11:45 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers or this copied down =SMALL(I:I,FREQUENCY(I:I,MAX(I:I)-(ROW(A1)-1))) Don Guillett SalesAid Software dguille...@gmail.com From: Haseeb Avarakkan Sent: Thursday, December 01, 2011 1:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ How to Extract the Second Biggest number from a list of numbers You can also use SMALL function like, =SMALL(A:A,FREQUENCY(A:A,MAX(A:A)-1)) will give the 2nd largest number, even if you have duplicate or not. ___ HTH, 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 -- 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
$$Excel-Macros$$ Re: Want to hide entire row
Pl.help On Thu, Dec 1, 2011 at 4:41 PM, Abdulgani Shaikh abdulgani.sha...@sarda.co.in wrote: I want to hide entire row if value in column *I* column *L* is greater than or equal to *0*. In other words if value in column i l is less than zero then only such row to be shown otherwise hidden. Pl help Regards -- 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$$ Table nedeed in MS-Access
Hello, You can’t import format to access tables, only data. If you need these “looks” under access I believe only a form or a report can help you. Regards. De: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] Em nome de Sam Mathai Chacko Enviada: terça-feira, 29 de Novembro de 2011 14:08 Para: excel-macros@googlegroups.com Assunto: Re: $$Excel-Macros$$ Table nedeed in MS-Access From what I have seen and heard in MS-Access, there is NO way you can have the same structure as in your attached file (first one). The closest you can get is with the second file,and I have attached that here. The volunteers here will (may) be able to help if you explain or detail the context of your request. To be honest, personally, this is the most weirdest looking layout of data that I have ever seen (probably makes sense to another person, but definitely not me!) Regards, Sam Mathai Chacko 2011/11/29 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ vadnalaki...@gmail.com Dear Experts I would like to request to have attached files in MS-Access Exactly as it is I shall be thankful if anybody can assist me Regards V.Kiran Kumar -- 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 -- Sam Mathai Chacko -- 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
$$Excel-Macros$$ MS Access Help
Hi Experts, I have a excel file which I am trying to link with MS Access for running some queries. The Excel file contains a VLOOKUP, where I have tried to lookup and compare the data from a previous day report. Then I compare that data to see if they are equal or not. I simply use A2=B2 for this, and this returns either TRUE or FALSE. The issue is when I link this file to MS Access, it starts giving me some #N/A, which are not there in the Excel file, to which it is linked. So when I query the linked table, it gives me incorrect results. Is there some thing wrong with my procedure or it is not a good idea to Link-import a Excel sheet with formulas to MS Access. Please guide. Thank you ! Regards, Rohan. -- 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$$ how to open a 2007 excel file in previous version of excel
Hello all, That may work if your file has no formatting whatsoever. J and than again J maybe no. You can open XLSX files in previous versions of excel using a free plugin/addon from Microsoft. Link below. http://www.microsoft.com/download/en/details.aspx?displaylang=enid=3 http://www.microsoft.com/download/en/details.aspx?displaylang=enid=3 Best regards De: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] Em nome de Sam Mathai Chacko Enviada: segunda-feira, 28 de Novembro de 2011 15:32 Para: excel-macros@googlegroups.com Assunto: Re: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel For the sake of readers, and for posterity, you CANNOT just change the file extension (xlsx to xls) and make it compatible with Excel 2003. Regards, Sam On Mon, Nov 28, 2011 at 6:58 PM, Bé Trần Văn betnmtdongna...@gmail.com wrote: 2011/11/28 Kenil Gala keni...@yahoo.com Rename the file. 2003 format : .xls 2007 format : .xlsx --- On Mon, 11/28/11, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: From: Sanjib Chatterjee chatterjee.kolk...@gmail.com Subject: $$Excel-Macros$$ how to open a 2007 excel file in previous version of excel To: excel-macros excel-macros@googlegroups.com Date: Monday, November 28, 2011, 11:23 AM Dear Members, Would you please help regarding How to open a excel file saved on 2007 format in 2003 format Thanking you in Advance Sanjib -- 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 You unzip it and run it FileFormatConverters open File 2007 You download the File under the followingLink: http://www.mediafire.com/?xatxj4f59m4754y -- 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 -- Sam Mathai Chacko -- 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.
Re: $$Excel-Macros$$ Table nedeed in MS-Access
Thanks for the advice On 1 December 2011 23:26, João Mavioso jmavi...@gmail.com wrote: Hello, ** ** You can’t import format to access tables, only data. If you need these “looks” under access I believe only a form or a report can help you. ** ** Regards. ** ** *De:* excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] *Em nome de *Sam Mathai Chacko *Enviada:* terça-feira, 29 de Novembro de 2011 14:08 *Para:* excel-macros@googlegroups.com *Assunto:* Re: $$Excel-Macros$$ Table nedeed in MS-Access ** ** From what I have seen and heard in MS-Access, there is NO way you can have the same structure as in your attached file (first one). The closest you can get is with the second file,and I have attached that here. The volunteers here will (may) be able to help if you explain or detail the context of your request. To be honest, personally, this is the most weirdest looking layout of data that I have ever seen (probably makes sense to another person, but definitely not me!) Regards, Sam Mathai Chacko 2011/11/29 ♥.•:*¨¨*:•.♥.•:V.Kiran Kumar :•.♥.•:*¨¨*:•.♥ vadnalaki...@gmail.com Dear Experts I would like to request to have attached files in MS-Access Exactly as it is I shall be thankful if anybody can assist me Regards V.Kiran Kumar -- 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 -- Sam Mathai Chacko -- 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$$ Re: Want to hide entire row
Sub hide_data() Application.ScreenUpdating = False Application.DisplayAlerts = False Dim i As Long For i = Sheets(1).Range(a1).SpecialCells(xlLastCell).Row To 2 Step -1 If Sheets(1).Range(I i).Value = 0 Or Sheets(1).Range(l i).Value = 0 Then Sheets(1).Rows(i : i).Hidden = True End If Next Application.ScreenUpdating = True Application.DisplayAlerts = True End Sub On Fri, Dec 2, 2011 at 9:15 AM, AbdulGani Shaikh itpabdulg...@gmail.comwrote: Pl.help On Thu, Dec 1, 2011 at 4:41 PM, Abdulgani Shaikh abdulgani.sha...@sarda.co.in wrote: I want to hide entire row if value in column *I* column *L* is greater than or equal to *0*. In other words if value in column i l is less than zero then only such row to be shown otherwise hidden. Pl help Regards -- 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 -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* P Before printing, think about the environment. -- 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$$ Vlookup
Dear SAM, I have created the addin from the above trailing mails. Can u please guide me where am i going wrong or how to use it once the addin is created? Please help On Oct 27, 1:59 am, Aamir Shahzad aamirshahza...@gmail.com wrote: *Done SAM*, wonderful thanks for your cooperation. I think I must have to save this add in file in save location for permanent use of this function is it? second this add in don't show in ribbon no problem but I saw that my friend create the add in and it shows in the ribbon with his multi commands can I use this in the ribbon with button. And can I create further macros solutions in the same add in with multi buttons? Thanks again for your cooperate. Regards, Aamir Shahzad On Thu, Oct 27, 2011 at 1:38 AM, Sam Mathai Chacko samde...@gmail.comwrote: No, do not create an xlsb. Create an xlam. The add it to the add-in list. Sam On Thu, Oct 27, 2011 at 1:51 AM, Aamir Shahzad aamirshahza...@gmail.comwrote: created as xlsb now tell me how to use, I mean how to use now Aamir Shahzad On Thu, Oct 27, 2011 at 1:08 AM, Sam Mathai Chacko samde...@gmail.comwrote: Aamir, I was just checking, and found that I was wrong. You have to save a file as an add-in for this to work. Create a new file, put the code in a new module of that file, and save it as add-in (.xlam). Sam On Thu, Oct 27, 2011 at 1:19 AM, Aamir Shahzad aamirshahza...@gmail.com wrote: I am pasting SAM see attached file may be doing some thing wrong. In your previous mail you instructed to create xlsb file why? On Thu, Oct 27, 2011 at 12:44 AM, Sam Mathai Chacko samde...@gmail.com wrote: Aamir, you have to past the code in the code module, not the workbook/sheet module Sam On Thu, Oct 27, 2011 at 1:12 AM, Aamir Shahzad aamirshahza...@gmail.com wrote: SAM - I am doing your instruction like this: 1) In the blank new work book opening marco by shortkey. 2) selecting personal workbook. Click ok 3) then going to VBE window. In the Personal Macro workbook in the module after pasting your code then save then close. 4) after that in excel typing the required multiresultlookedup formula still not showing what I am doing wrong. Please help. Aamir Shahzad On Tue, Oct 25, 2011 at 1:37 AM, Sam Mathai Chacko samde...@gmail.com wrote: OK. Click on record macro from the developer tab. Short cut key ALT+T+M+R Then in the option to select store macro in, select personal workbook. Then click OK. Then do anything on the spreadsheet, like select a cell, or delete a row or something. The stop the macro recording. You can use the same short cut key as above. Then click ALT+F11. This will take you to the VBE window. There in the project explorer window you will see the personal macro workbook. In that you will find a module. In the module, just paste my code, and then use it like you would normally use any formula.. Regards, Sam On Tue, Oct 25, 2011 at 1:50 AM, Aamir Shahzad aamirshahza...@gmail.com wrote: SAM please further brief step by step procedure which are you saying as I am very new in macro. Aamir Shahzad On Tue, Oct 25, 2011 at 1:05 AM, Sam Mathai Chacko samde...@gmail.com wrote: Aamir, copy the entire code to your personal.xlsb file. You will now have it available in all your workbooks, similar to an add-in. If you do not have the personal file, just do any macro recording by selecting the personal workbook. Stop recording, and the overwrite the macro that was recorded. Regards, Sam Mathai Chacko (GL) On Tue, Oct 25, 2011 at 1:32 AM, Aamir Shahzad aamirshahza...@gmail.com wrote: thank you very much SAM for this wonderful solution. But I want to make this to permanent function you can say by means of add in, I want to make add in to use this MultiResultLookedup Macro because any time if I want to use this function I have to convert the file format xlsx to xlsm. Please suggest. Regards, Aamir Shahzad On Mon, Oct 24, 2011 at 10:27 PM, Sam Mathai Chacko samde...@gmail.com wrote: Function MultiResultLookedUp(varLookupValue, rngRange As Range) As String Dim lngLoop As Long Dim varArray varArray = rngRange For lngLoop = LBound(varArray, 1) To UBound(varArray, 1) If varArray(lngLoop, 1) = varLookupValue Then MultiResultLookedUp = MultiResultLookedUp varArray(lngLoop, 2) / End If Next lngLoop MultiResultLookedUp = Left(MultiResultLookedUp, Len(MultiResultLookedUp) - 1) End Function Regards, Sam Mathai Chacko (GL) On Mon, Oct 24, 2011 at 10:46 PM, Aamir Shahzad aamirshahza...@gmail.com wrote: Dear Experts, I want to pick the multi values like vlookup formula. Is there any way? Sheet attached. Can we prepare the any function e.g. (mylookup) which save in excel when ever I use that function it picks the
