$$Excel-Macros$$ Excel hyperlink help required
Respected Group Members kindly download the sample file for detail. Thanks & Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups "MS EXCEL AND VBA MACROS" group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. ECI sample.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ insert option is disabled in context menu
Dear Sir, please help me to enable the insert option context menu. Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Excel Tip
THANKS FOR GREAT TRICK VAIBHAV WORKING PERFECTLY On Thu, Feb 26, 2015 at 12:01 PM, amar takale amartak...@gmail.com wrote: pls look sheet where sheetl1 not change as per you saying. Pls explain me On Thu, Feb 26, 2015 at 10:58 AM, Vaibhav Joshi v...@vabs.in wrote: Dear Amar Data in col b date only, you just need to change format of col B to date by selecting col b pressing ctr+shift+3 Cheers!! On Wed, Feb 25, 2015 at 5:11 PM, amar takale amartak...@gmail.com wrote: Dear Vabs bro thanks very much for this knowledgeable trick. I discuss here attached file for date issue not converted in same format as per your trick,why? i always use text to column operation trick for same format. On Wed, Feb 25, 2015 at 3:46 PM, Vaibhav Joshi v...@vabs.in wrote: Cheers Chandan Gaurav On Tue, Feb 24, 2015 at 11:57 AM, Gaurav Devrani gauravdev1...@gmail.com wrote: Superb Vaibhav. Thanks for sharing this with us. Regards Gaurav Devrani On Mon, Feb 23, 2015 at 11:25 PM, Chandan Bisht csb.bi...@gmail.com wrote: Hi. Very nice... Thankx Rgds, Chandra Singh Bisht On Mon, Feb 23, 2015 at 8:36 PM, Vaibhav Joshi v...@vabs.in wrote: Convert all date in same format: While receiving data from different sources many time it happens that data received is not in same format due to various reason. One of the tedious activity is to transforming data to same format. I will share very good technique to convert all dates to same format, suppose you have date in one column A it has different format viz dd-mm- or -mm-dd (it should be in d-m-y or y-m-d format). In column B write formula in cell B1, =A1*1 drag down; you can see all dates will get converted in same format in column b. Also you can apply paste special multiply by 1 operation on data in column A if you don't want to get result through help of column. Also you can perform data text to column operation of column A, select data type as Delimited, delimiter type Tab, data format General. Do share me if you have discovered unique method/trick. Cheers!! -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Thanks Regards Gaurav Devrani -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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
Re: $$Excel-Macros$$ Pick from drop down list disable on moust right click
plz check the the attachment On Sat, Nov 8, 2014 at 12:48 PM, Kartik Dale kartik.1...@gmail.com wrote: Hi All, I want to disable the Pick from Drop-down list option on mouse right click. [image: Inline image 1] -- Thanks Kartik -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. drop down.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ plz solve my query sorting and unique data
i have need formula for this work. On Sun, Jun 22, 2014 at 6:06 AM, Bé Trần Văn betnmtdongna...@gmail.com wrote: Advanced use fiter to remove duplicates, sort and normal. 2014-06-21 18:12 GMT+07:00 Abhishek Jain abhishek@gmail.com: Not sure if your output has anything to do with sorting. Remove Duplicates (under Data tab) will give you the same results. Regards, Abhishek On Sat, Jun 21, 2014 at 4:11 PM, Sourabh Salgotra rhtdmja...@gmail.com wrote: Dear Sir, plz solve my query related to getting the unique and sorting data from the list. sample sheet attached. Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- 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 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW
$$Excel-Macros$$ plz solve my query sorting and unique data
Dear Sir, plz solve my query related to getting the unique and sorting data from the list. sample sheet attached. Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. SORTING WITH UNIQUE OCCURANCE.xlsx Description: MS-Excel 2007 spreadsheet
Re: $$Excel-Macros$$ Sorting Alphabetically with formula
use =SMALL($B$2:$B$21,ROW()-1) On 6/8/12, Rajan_Verma rajanverma1...@gmail.com wrote: Hi Hilary You can take idea from this file. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of hilary lomotey Sent: 08 June 2012 6:56 To: excel-macros Subject: $$Excel-Macros$$ Sorting Alphabetically with formula Hi Experts i am trying to sort alphabetically with a formula in the attached sheet in column O, i tried using COUNTIF($O$29:$O$44,=O29) to get the first number and the rank it with either index and match or vlookup. the problem is that when i use COUNTIF($O$29:$O$44,=O29), the result doesnt begin from 1, and i dont know what dynamic figure to deduct from make it start from one. pls assist with the right approach -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Records found but unable to get proper result.
many many thanks ashish sir for helping me. i am also done it with the following formula =IFERROR(INDEX(Table1[SUBCODE],SMALL(IF(COURSES!$A$2:$A$804=LIST!$E$1,ROW(INDIRECT(1:803)),),ROW()-34)),) but sir your method is simpler than me now i am following your method. On Mon, Jun 4, 2012 at 8:59 PM, ashish koul koul.ash...@gmail.com wrote: see if it helps On Mon, Jun 4, 2012 at 8:48 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: Dear Sir, i have little knowledge about vba. that's why i am asking sol with index/match. and plz tell me abt offset function also. On Sun, Jun 3, 2012 at 11:42 PM, pawel lupinski lupins...@yahoo.comwrote: Don, love it (great reply) :) Pawel -- *From:* dguillett1 dguille...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Sunday, June 3, 2012 6:55 PM *Subject:* Re: $$Excel-Macros$$ Records found but unable to get proper result. I like my solution. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Sunday, June 03, 2012 12:53 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Records found but unable to get proper result. thanks for help. plz provide index/atch solution also On Sun, Jun 3, 2012 at 6:35 PM, dguillett1 dguille...@gmail.com wrote: How about a nice macro? Change your formatting and use in macro enabled workbook Sub filtercopy() With Sheets(COURSES).UsedRange .AutoFilter Field:=1 'criteria IF needed .AutoFilter Field:=2 .AutoFilter Field:=3, Criteria1:=Sheets(form).Range(n1) .Offset(1, 3).Resize(, 2).SpecialCells(xlVisible). _ Copy Sheets(form).Range(d35) End With End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Sunday, June 03, 2012 5:08 AM *To:* excel-macros@googlegroups.com *Cc:* Don Guillett dguille...@gmail.com ; rajanverma1...@gmail.com ; noorain.ans...@gmail.com *Subject:* $$Excel-Macros$$ Records found but unable to get proper result. Dear sir, i am using index/match formula. in my problem i am getting the 1st occurrence result only. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS I 2 #NUM! #NUM! 3 #NUM! #NUM! 4 #NUM! #NUM! 5 #NUM! #NUM! 6 #NUM! #NUM! 7 #NUM! #NUM! 8 #NUM! #NUM! 9 #NUM! #NUM! i want the output like this. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS 2 BF 2 CHEMISTRY 3 BF 3 ENGLISH I 4 BF 4 ELECTRICAL TECHNOLOGY 5 BF 5 MECHANICS 6 BF 6 INTRODUCTION TO MANUFACTURING PROCESS 7 BF 2P CHEMISTRY PRACTICAL 8 BF 4P ELECTICAL TECHNOLOGY PRACTICAL 9 BF 7 INDIAN CONSTITUTION AND ETHICS sample sheet attached Thanks Regards Sourabh Contact Numbers: +91-94630-49202 -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Records found but unable to get proper result.
Dear Sir, i have little knowledge about vba. that's why i am asking sol with index/match. and plz tell me abt offset function also. On Sun, Jun 3, 2012 at 11:42 PM, pawel lupinski lupins...@yahoo.com wrote: Don, love it (great reply) :) Pawel -- *From:* dguillett1 dguille...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Sunday, June 3, 2012 6:55 PM *Subject:* Re: $$Excel-Macros$$ Records found but unable to get proper result. I like my solution. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Sunday, June 03, 2012 12:53 PM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Records found but unable to get proper result. thanks for help. plz provide index/atch solution also On Sun, Jun 3, 2012 at 6:35 PM, dguillett1 dguille...@gmail.com wrote: How about a nice macro? Change your formatting and use in macro enabled workbook Sub filtercopy() With Sheets(COURSES).UsedRange .AutoFilter Field:=1 'criteria IF needed .AutoFilter Field:=2 .AutoFilter Field:=3, Criteria1:=Sheets(form).Range(n1) .Offset(1, 3).Resize(, 2).SpecialCells(xlVisible). _ Copy Sheets(form).Range(d35) End With End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Sunday, June 03, 2012 5:08 AM *To:* excel-macros@googlegroups.com *Cc:* Don Guillett dguille...@gmail.com ; rajanverma1...@gmail.com ; noorain.ans...@gmail.com *Subject:* $$Excel-Macros$$ Records found but unable to get proper result. Dear sir, i am using index/match formula. in my problem i am getting the 1st occurrence result only. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS I 2 #NUM! #NUM! 3 #NUM! #NUM! 4 #NUM! #NUM! 5 #NUM! #NUM! 6 #NUM! #NUM! 7 #NUM! #NUM! 8 #NUM! #NUM! 9 #NUM! #NUM! i want the output like this. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS 2 BF 2 CHEMISTRY 3 BF 3 ENGLISH I 4 BF 4 ELECTRICAL TECHNOLOGY 5 BF 5 MECHANICS 6 BF 6 INTRODUCTION TO MANUFACTURING PROCESS 7 BF 2P CHEMISTRY PRACTICAL 8 BF 4P ELECTICAL TECHNOLOGY PRACTICAL 9 BF 7 INDIAN CONSTITUTION AND ETHICS sample sheet attached Thanks Regards Sourabh Contact Numbers: +91-94630-49202 -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Records found but unable to get proper result.
Dear sir, i am using index/match formula. in my problem i am getting the 1st occurrence result only. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS I 2 #NUM! #NUM! 3 #NUM! #NUM! 4 #NUM! #NUM! 5 #NUM! #NUM! 6 #NUM! #NUM! 7 #NUM! #NUM! 8 #NUM! #NUM! 9 #NUM! #NUM! i want the output like this. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS 2 BF 2 CHEMISTRY 3 BF 3 ENGLISH I 4 BF 4 ELECTRICAL TECHNOLOGY 5 BF 5 MECHANICS 6 BF 6 INTRODUCTION TO MANUFACTURING PROCESS 7 BF 2P CHEMISTRY PRACTICAL 8 BF 4P ELECTICAL TECHNOLOGY PRACTICAL 9 BF 7 INDIAN CONSTITUTION AND ETHICS sample sheet attached Thanks Regards Sourabh Contact Numbers: +91-94630-49202 -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com FORM.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Records found but unable to get proper result.
thanks for help. plz provide index/atch solution also On Sun, Jun 3, 2012 at 6:35 PM, dguillett1 dguille...@gmail.com wrote: How about a nice macro? Change your formatting and use in macro enabled workbook Sub filtercopy() With Sheets(COURSES).UsedRange .AutoFilter Field:=1 'criteria IF needed .AutoFilter Field:=2 .AutoFilter Field:=3, Criteria1:=Sheets(form).Range(n1) .Offset(1, 3).Resize(, 2).SpecialCells(xlVisible). _ Copy Sheets(form).Range(d35) End With End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Sunday, June 03, 2012 5:08 AM *To:* excel-macros@googlegroups.com *Cc:* Don Guillett dguille...@gmail.com ; rajanverma1...@gmail.com ; noorain.ans...@gmail.com *Subject:* $$Excel-Macros$$ Records found but unable to get proper result. Dear sir, i am using index/match formula. in my problem i am getting the 1st occurrence result only. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS I 2 #NUM! #NUM! 3 #NUM! #NUM! 4 #NUM! #NUM! 5 #NUM! #NUM! 6 #NUM! #NUM! 7 #NUM! #NUM! 8 #NUM! #NUM! 9 #NUM! #NUM! i want the output like this. Sr. No. Subject Code Subject/Paper code 1 BF 1 MATHEMATICS 2 BF 2 CHEMISTRY 3 BF 3 ENGLISH I 4 BF 4 ELECTRICAL TECHNOLOGY 5 BF 5 MECHANICS 6 BF 6 INTRODUCTION TO MANUFACTURING PROCESS 7 BF 2P CHEMISTRY PRACTICAL 8 BF 4P ELECTICAL TECHNOLOGY PRACTICAL 9 BF 7 INDIAN CONSTITUTION AND ETHICS sample sheet attached Thanks Regards Sourabh Contact Numbers: +91-94630-49202 -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- FORUM RULES (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 (986+ 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION
Dear Sir, thanks for help. i am already woking with index/match fourmula. i want macro function to solve. On Fri, May 4, 2012 at 10:49 AM, Deepak Rawat deepakexce...@gmail.comwrote: Hi Pls find the attached. I used formula instead of Macro. Regards, Deepak Rawat On Thu, May 3, 2012 at 9:33 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: DEAR SIR, PLZ DOWNLOAD THE ATTACHED FILE AND GIVE THE CODE FOR CREATING FUNCTION TO CALCULATE WEIGHT AGE AND GRADE Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (986+ 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 (986+ 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 (986+ 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$$ HELP REQUIRED IN MACRO FUNCTION
DEAR SIR THANKS TO ALL. I HAVE DONE IT. THIS IS MY FIRST SMALL VBA PRG. I HAVE LEARN VBA FROM THIS GROUP. On Fri, May 4, 2012 at 6:34 PM, dguillett1 dguille...@gmail.com wrote: Then, one way is to apply the formula using a macro and then change to value if desired. Or, use EVALUATE for the formula. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Sourabh Salgotra rhtdmja...@gmail.com *Sent:* Friday, May 04, 2012 1:03 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION Dear Sir, thanks for help. i am already woking with index/match fourmula. i want macro function to solve. On Fri, May 4, 2012 at 10:49 AM, Deepak Rawat deepakexce...@gmail.comwrote: Hi Pls find the attached. I used formula instead of Macro. Regards, Deepak Rawat On Thu, May 3, 2012 at 9:33 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: DEAR SIR, PLZ DOWNLOAD THE ATTACHED FILE AND GIVE THE CODE FOR CREATING FUNCTION TO CALCULATE WEIGHT AGE AND GRADE Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (986+ 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 (986+ 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 (986+ 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 (986+ 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$$ HELP REQUIRED IN MACRO FUNCTION
Dear Sir, grade calculated on weight age and weight age calculates as (obs total/total no)*10 (27/40)*10=6.75 then grade will be b2 On Thu, May 3, 2012 at 10:28 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Can you please more explain.Like where we need to match Grade Bucket Criteria for Calculation/ ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Sourabh Salgotra *Sent:* 03 May 2012 21:34 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ HELP REQUIRED IN MACRO FUNCTION ** ** DEAR SIR, PLZ DOWNLOAD THE ATTACHED FILE AND GIVE THE CODE FOR CREATING FUNCTION TO CALCULATE WEIGHT AGE AND GRADE Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (986+ 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 (986+ 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 (986+ 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$$ regarding pivot table problem
plz check attachement On Mon, Apr 9, 2012 at 4:48 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Sir, previously i sent you the mail. But I got the error message that the message I am sending is cross the allocated limit so I am sending you the fresh message. Please see the attachment. I have created the Pivot table based on the data of sheet1. Then follow the step for creating pivot table. But I want in same different format. In BS column referred to buy and sale of scripts. If there is B in the column then quantity should be put as buy qty and next buy rate. If there is S in the column then quantity should be put as sale and next sale rate. Net qty should be buy - sale quantity. Please help to solve the problem Thanking you in Advance. Sanjib -- - -- FORUM RULES (986+ 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 (986+ 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 Copy_of_EXAMPLE_VKGOEL.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ REG:$$Column to table formula not working
i think u want as attachment. see attachment On Wed, Mar 28, 2012 at 4:51 PM, karunanithi ramaswamy era_...@yahoo.comwrote: Sir, the file is attached. *From:* dguillett1 dguille...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tuesday, March 27, 2012 11:39 PM *Subject:* Re: $$Excel-Macros$$ REG:$$Column to table formula not working Show us your before/after data and/or send a file with explanation. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* karunanithi ramaswamy era_...@yahoo.com *Sent:* Tuesday, March 27, 2012 12:34 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ REG:$$Column to table formula not working Sir, About 4 to 6 months back, in theis Forum Someone(may be Siti or so) has given a formula to convert a column to table. i.e., =Row(A1)*3-(3-Column(A1)) this works fine when A1 to A100 is 1 to 100. But not with 10 digit cell phone number data. Can any one suggest any formula or vba.(i am using windows 2007) Karunanithi R -- FORUM RULES (986+ 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 (986+ 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 (986+ 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 (986+ 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 col-table.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ REG:$$Column to table formula not working
chk this one. -- FORUM RULES (986+ 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 col-table.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Urgent Help Required...!
chk attachments solved On Fri, Mar 2, 2012 at 6:11 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi, Do you want to chek whether the master file ph.# are callable or non-callable by verying it with NDNC sheet? On Sat, Mar 3, 2012 at 4:16 AM, Satvik satvik...@gmail.com wrote: Hi Every One, Friend I need a big help from you all, as I work in BPO company as a MIS executive but I am not aware about Access or SQL. But every day I need to scrub the NDNC data which I receive it from my client side.. Volume of a data will be around 5 to 6 lake. Where I get NDNC scrubbed file from the NDNC link using this file I need to map the NDNC status to my Master file. Will any one help me to do my work easier and do my other work @ the same time. Attached the sample files... Sample 1 - master file Sample 2 - NDNC file. Regards, Satvik -- FORUM RULES (986+ 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 (986+ 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 (986+ 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 NDNC file.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet master file.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Urgent Help Required...!
u can try this one =INDEX('E:\Desktop\[NDNC file.xlsx]Sheet1'!$A$2:$B$11,MATCH(A2,'E:\Desktop\[NDNC file.xlsx]Sheet1'!$A$2:$A$11,0),2) On Sat, Mar 3, 2012 at 7:19 AM, Satvik satvik...@gmail.com wrote: ** Shaik, As off now I'm doing the same logic. Where as my data volume is too high! Is there any other logic to map the same... Regards, Satvik Sent from BlackBerry® on Airtel -- *From: *Shaik Waheed waheedb...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Fri, 2 Mar 2012 20:43:19 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...! Hi, You can use vlookup to find the callable # from DNC sheet. Find the attached file for ur reference. On Sat, Mar 3, 2012 at 6:59 AM, Satvik satvik...@gmail.com wrote: ** Thanks for the replay Shaik... Yes I need to check with DNC.. Sent from BlackBerry® on Airtel -- *From: *Shaik Waheed waheedb...@gmail.com *Sender: *excel-macros@googlegroups.com *Date: *Fri, 2 Mar 2012 18:11:44 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ Urgent Help Required...! Hi, Do you want to chek whether the master file ph.# are callable or non-callable by verying it with NDNC sheet? On Sat, Mar 3, 2012 at 4:16 AM, Satvik satvik...@gmail.com wrote: Hi Every One, Friend I need a big help from you all, as I work in BPO company as a MIS executive but I am not aware about Access or SQL. But every day I need to scrub the NDNC data which I receive it from my client side.. Volume of a data will be around 5 to 6 lake. Where I get NDNC scrubbed file from the NDNC link using this file I need to map the NDNC status to my Master file. Will any one help me to do my work easier and do my other work @ the same time. Attached the sample files... Sample 1 - master file Sample 2 - NDNC file. Regards, Satvik -- FORUM RULES (986+ 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 (986+ 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 (986+ 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 (986+ 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
Re: $$Excel-Macros$$ help needed??
thanks for help sir i am already done with if statement. chk attachment. and provide other solution vlookup/index-match On Sun, Feb 26, 2012 at 9:33 PM, xlstime xlst...@gmail.com wrote: please find the attachment On Sun, Feb 26, 2012 at 9:19 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: Dear sir, plz download the attachment and help me... -- FORUM RULES (986+ 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 (986+ 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 (986+ 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 Copy of HELP NEEDED ON SUBJECTS.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ vlookup and index/match functions help required
thanks kris sir and sam sir . On Tue, Feb 7, 2012 at 10:30 PM, Sam Mathai Chacko samde...@gmail.comwrote: I would also go with the LOOKUP suggested by Kris as it is direct, and simple. But if you do not want to make any change to your layout, you could also use a CSE formula =INDEX($H$3:$H$9,MATCH(B2,--TRIM(RIGHT(SUBSTITUTE($G$3:$G$9,-,REPT( ,20)),10)),-1)) Regards, Sam Mathai Chacko On Tue, Feb 7, 2012 at 9:52 PM, Kris krishnak...@gmail.com wrote: Hi, In C2 and copied down, =LOOKUP(B2,$I$3:$J$11) and arrange your table like RANGE GRADE 0 No Grade 3.2 D 4.1 C2 5.1 C1 6.1 B2 7.1 B1 8.1 A2 9.1 A1 10.1 No Grade Kris -- FORUM RULES (986+ 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 (986+ 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 (986+ 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$$ Need Formula for Lookup Based on a Matrix of Data
plz sir explain this formula i have confusion in this. how it can take total values from data sheet. On Thu, Jan 26, 2012 at 10:19 PM, dguillett1 dguille...@gmail.com wrote: Simpler with no CSE '=INDEX(Data!$A$1:$L$37,MATCH($E3,Data!$A:$A),MATCH(F$2,Data!$1:$1,0)) Don Guillett SalesAid Software dguille...@gmail.com *From:* NOORAIN ANSARI noorain.ans...@gmail.com *Sent:* Thursday, January 26, 2012 10:22 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need Formula for Lookup Based on a Matrix of Data Dear John, You can also use in F3... =INDEX(Data!$C$2:$C$37,MATCH(1,(Data!$A$2:$A$37=E3)*(Data!$B$2:$B$37=Total),0)) with ctrl+Shift+enter 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, Jan 26, 2012 at 8:48 PM, John A. Smith johnasmit...@gmail.comwrote: Thank you for your valuable help. I need a formula that will lookup a value based on a column heading, a date column/row and a row qualifier (the word Total). Please see the attached spreadsheet. Thank you. John -- FORUM RULES (986+ 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 (986+ 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 (986+ 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 (986+ 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
Re: $$Excel-Macros$$ query about translate
use http://translate.google.co.in/ On Fri, Jan 20, 2012 at 6:26 PM, Rajan_Verma rajanverma1...@gmail.comwrote: I think no way in excel without use of any other software ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *anil kumar *Sent:* Jan/Fri/2012 06:12 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ query about translate ** ** I want to translate all name and add. in english anil -- FORUM RULES (986+ 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 (986+ 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 (986+ 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$$ FW: Hidden file
go to run type cmd @command prompt type attrib -r -s -h -a filename -- FORUM RULES (986+ 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: Array Help
many -2 thanks to all of u -- FORUM RULES (986+ 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 - Array Help
* * dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * 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, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- FORUM RULES (986+ 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 (986+ 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 (986+ 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 saurabh.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Excel - Array Help
Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, 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, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: * * dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * 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, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- FORUM RULES (986+ 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 (986+ 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 (986+ 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 (986+ 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
Re: $$Excel-Macros$$ Excel - Array Help
and plz explain the sum formula of counting unique records On Fri, Jan 20, 2012 at 6:50 AM, Sourabh Salgotra rhtdmja...@gmail.comwrote: Thank you so much sir, if we want without help. col On Thu, Jan 19, 2012 at 11:35 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: 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, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: * * dear sir plz tell me that how i can these fourmula on multiple match like attachment. On Thu, Jan 19, 2012 at 2:42 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Amar, Please use below formula to count total unique name *=SUM(1/COUNTIF(B2:B6,B2:B6)) *press ctrl+Shift+Enter or use this one to check unique or Duplicate Entry. *=IF(COUNTIF($B$2:B2,B2)1,Duplicate,Unique) * 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, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender kassi.re...@gmail.com wrote: Hi Experts, I'm facing a problem in identifying duplicate names in a column. Here is what I'm looking for. If there are duplicates in column A i.e. A1 = Amar A2= Vijay A3 = Suresh A4 = Ravi A5 = Amar Then I would like to interior color A1 and A5 as they are duplicates, I would like to use the cell references rather than Range's as in my sheet Column is fixed but rows are not fixed. It'll be great if you can help me with this. Thanks in advance, Amar -- FORUM RULES (986+ 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 (986+ 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 (986+ 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 (986+ 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
$$Excel-Macros$$ plz explain the working of 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 -- 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
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
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
Re: $$Excel-Macros$$ need correction in the formula
plz tell me about 9E300. On Wed, Nov 23, 2011 at 8:06 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Great Solution Haseeb..Excellent.. On Wed, Nov 23, 2011 at 12:59 AM, Haseeb Avarakkan haseeb.avarak...@gmail.com wrote: Hello Santosh, Another one. =IFERROR(LOOKUP(9E300,SEARCH({Sa,Su,Sha},B4),{Hero,Boy,Shaan}),) __ 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.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$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST
On Sat, Oct 1, 2011 at 1:23 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: thanks for help but in this sheet all the data returned from the selected sheet searching not working. i want 2 solutions 1 choose sheet 2 search data (which is in c3 cols) if u type singh in c3 then result generated the all the record that contain singh displayed On Sat, Oct 1, 2011 at 12:08 PM, rajan verma rajanverma1...@gmail.comwrote: hi.. See the attached Sheet... Its Done With HlookUp + indirect and Other Way By offset() Regards Rajan. On Sat, Oct 1, 2011 at 8:03 AM, Saurabh Salgotra rhtdmja...@gmail.comwrote: IN THIS SHEET SEARCHING IS WORKING BUT IT IS LIMITING FOR SEARCHING THE DATA ONLY FROM ONE SHEET(WHICH IS ADDREDSSED IN FORMULA). I WANT TO SEARCH DATA FROM THE SHEET WHICH I HAVE SELECTED IN THE DROP DOWN LIST I MEAN THAT WHICH SHEET IS SELECTED IN DROPDOWN LIST I GOT THE RESULT FROM THAT SHEET. FORMULA IS: =INDEX(JUN12!$A$2:$A$65536,**SMALL(IF(ISNUMBER(SEARCH($C$3,** JUN12!$B$2:$B$65536)),ROW(**JUN12!$B$2:$B$65536)-MIN(ROW(** JUN12!$B$2:$B$65536))+1,),**ROW(A1))) IN THIS FORMULA I HAVE MENTIONED THE SHEET NAME. SEE DROPDOWNLIST IN D1 I HAVE SELECTED THE SHEET DEC-10, HOW I CAN WRITE THE FORMULA FOR THIS -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Regards Rajan verma +91 9158998701 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST
not working On Sat, Oct 1, 2011 at 10:40 AM, Sam Mathai Chacko samde...@gmail.comwrote: USE =INDEX(INDIRECT(TEXT(D1,MMMYY)!$A$2:$A$65536),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536))),ROW(INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536))-MIN(ROW(INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536)))+1,),ROW(A1))) in B8 Regards Sam Mathai Chacko (GL) On Sat, Oct 1, 2011 at 8:03 AM, Saurabh Salgotra rhtdmja...@gmail.comwrote: IN THIS SHEET SEARCHING IS WORKING BUT IT IS LIMITING FOR SEARCHING THE DATA ONLY FROM ONE SHEET(WHICH IS ADDREDSSED IN FORMULA). I WANT TO SEARCH DATA FROM THE SHEET WHICH I HAVE SELECTED IN THE DROP DOWN LIST I MEAN THAT WHICH SHEET IS SELECTED IN DROPDOWN LIST I GOT THE RESULT FROM THAT SHEET. FORMULA IS: =INDEX(JUN12!$A$2:$A$65536,**SMALL(IF(ISNUMBER(SEARCH($C$3,** JUN12!$B$2:$B$65536)),ROW(**JUN12!$B$2:$B$65536)-MIN(ROW(** JUN12!$B$2:$B$65536))+1,),**ROW(A1))) IN THIS FORMULA I HAVE MENTIONED THE SHEET NAME. SEE DROPDOWNLIST IN D1 I HAVE SELECTED THE SHEET DEC-10, HOW I CAN WRITE THE FORMULA FOR THIS -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sam Mathai Chacko -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST
I HAVE CHECKED ITS WORKING BUT PROBLEM IS THAT THIS FORMULA IS ON MY TIPS . SO THAT'S WHY I WANT ERROR HANDLER ON THIS On Sat, Oct 1, 2011 at 10:18 PM, Sam Mathai Chacko samde...@gmail.comwrote: Well, I haven't used error handler in the first post, but if you use one of the formulas from my second post, you will not get that #NUM error. Check the attached file in my previous post. Sam On Sat, Oct 1, 2011 at 10:12 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: VERY VERY THANKS SIR FOR HELPING ME I HAVE ONE QUERY ALSO PENDING I WANT THAT WHICH CELLS HAVE NOT ANY RESULT THEY CAN DISPLAYED AS BLANK NOT AS #NUM IN THE FORMULA THAT I HAVE USED IN ATTACHED FILE. On Sat, Oct 1, 2011 at 4:15 PM, Sam Mathai Chacko samde...@gmail.comwrote: By the way, replace SINGH with $C$3 On Sat, Oct 1, 2011 at 4:14 PM, Sam Mathai Chacko samde...@gmail.comwrote: Don't seem like you tried my suggestion. Anyway, since there were posts sharing two examples with HLOOKUP and OFFSET, I have included that also in my suggestion. HLOOKUP and OFFSET will work, but not the way it was formulated it the previous post. Here's the working version of it in your sample file. I have left it in reverse order, and will leave you to figure out how to sort it in ascending order as I didn't think it was critical to your original query. For the mobile users, here's the array formulas used INDEX VERSION =IF(LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1))0, *INDEX* (INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$A$1:$A$100),LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1))),) HLOOKUP VERSION =IF(LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1))0, *HLOOKUP* (C$7,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$A$1:$E$100),LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1)),0),) OFFSET VERSION =IF(LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1))0, *OFFSET* (INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$C$1),LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1))-1,0),) Regards, Sam Mathai Chacko (GL) On Sat, Oct 1, 2011 at 1:33 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: not working On Sat, Oct 1, 2011 at 10:40 AM, Sam Mathai Chacko samde...@gmail.com wrote: USE =INDEX(INDIRECT(TEXT(D1,MMMYY)!$A$2:$A$65536),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536))),ROW(INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536))-MIN(ROW(INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536)))+1,),ROW(A1))) in B8 Regards Sam Mathai Chacko (GL) On Sat, Oct 1, 2011 at 8:03 AM, Saurabh Salgotra rhtdmja...@gmail.com wrote: IN THIS SHEET SEARCHING IS WORKING BUT IT IS LIMITING FOR SEARCHING THE DATA ONLY FROM ONE SHEET(WHICH IS ADDREDSSED IN FORMULA). I WANT TO SEARCH DATA FROM THE SHEET WHICH I HAVE SELECTED IN THE DROP DOWN LIST I MEAN THAT WHICH SHEET IS SELECTED IN DROPDOWN LIST I GOT THE RESULT FROM THAT SHEET. FORMULA IS: =INDEX(JUN12!$A$2:$A$65536,**SMALL(IF(ISNUMBER(SEARCH($C$3,** JUN12!$B$2:$B$65536)),ROW(**JUN12!$B$2:$B$65536)-MIN(ROW(** JUN12!$B$2:$B$65536))+1,),**ROW(A1))) IN THIS FORMULA I HAVE MENTIONED THE SHEET NAME. SEE DROPDOWNLIST IN D1 I HAVE SELECTED THE SHEET DEC-10, HOW I CAN WRITE THE FORMULA FOR THIS -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Sam Mathai Chacko -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http
Re: $$Excel-Macros$$ SEARCHING DATA WITHIN SHEET WHICH IS SELECTED IN DROP DOWN LIST
very very thanks sir for helping me. On 10/1/11, Sam Mathai Chacko samde...@gmail.com wrote: Shorter one... =IF(ROW($A1)COUNTIF(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9),*$C$3*),,INDEX(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$A$2:$A$9),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9))),ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9))-MIN(ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9)))+1,),ROW(A1 Sam On Sat, Oct 1, 2011 at 10:28 PM, Sam Mathai Chacko samde...@gmail.comwrote: Interesting!!! Here you go... =IF(ISERROR(SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9))),ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9))-MIN(ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9)))+1,),ROW(A1))),,INDEX(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$A$2:$A$9),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9))),ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9))-MIN(ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$2:$B$9)))+1,),ROW($A1 Sam On Sat, Oct 1, 2011 at 10:21 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: I HAVE CHECKED ITS WORKING BUT PROBLEM IS THAT THIS FORMULA IS ON MY TIPS . SO THAT'S WHY I WANT ERROR HANDLER ON THIS On Sat, Oct 1, 2011 at 10:18 PM, Sam Mathai Chacko samde...@gmail.comwrote: Well, I haven't used error handler in the first post, but if you use one of the formulas from my second post, you will not get that #NUM error. Check the attached file in my previous post. Sam On Sat, Oct 1, 2011 at 10:12 PM, Sourabh Salgotra rhtdmja...@gmail.comwrote: VERY VERY THANKS SIR FOR HELPING ME I HAVE ONE QUERY ALSO PENDING I WANT THAT WHICH CELLS HAVE NOT ANY RESULT THEY CAN DISPLAYED AS BLANK NOT AS #NUM IN THE FORMULA THAT I HAVE USED IN ATTACHED FILE. On Sat, Oct 1, 2011 at 4:15 PM, Sam Mathai Chacko samde...@gmail.comwrote: By the way, replace SINGH with $C$3 On Sat, Oct 1, 2011 at 4:14 PM, Sam Mathai Chacko samde...@gmail.comwrote: Don't seem like you tried my suggestion. Anyway, since there were posts sharing two examples with HLOOKUP and OFFSET, I have included that also in my suggestion. HLOOKUP and OFFSET will work, but not the way it was formulated it the previous post. Here's the working version of it in your sample file. I have left it in reverse order, and will leave you to figure out how to sort it in ascending order as I didn't think it was critical to your original query. For the mobile users, here's the array formulas used INDEX VERSION =IF(LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1))0, *INDEX* (INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$A$1:$A$100),LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1))),) HLOOKUP VERSION =IF(LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1))0, *HLOOKUP* (C$7,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$A$1:$E$100),LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1)),0),) OFFSET VERSION =IF(LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1))0, *OFFSET* (INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$C$1),LARGE((ROW(INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100))*(ISNUMBER(SEARCH(SINGH,INDIRECT(TEXT(SEARCH!$D$1,MMMYY)!$B$1:$B$100),ROW($A1))-1,0),) Regards, Sam Mathai Chacko (GL) On Sat, Oct 1, 2011 at 1:33 PM, Sourabh Salgotra rhtdmja...@gmail.com wrote: not working On Sat, Oct 1, 2011 at 10:40 AM, Sam Mathai Chacko samde...@gmail.com wrote: USE =INDEX(INDIRECT(TEXT(D1,MMMYY)!$A$2:$A$65536),SMALL(IF(ISNUMBER(SEARCH($C$3,INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536))),ROW(INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536))-MIN(ROW(INDIRECT(TEXT(D1,MMMYY)!$B$2:$B$65536)))+1,),ROW(A1))) in B8 Regards Sam Mathai Chacko (GL) On Sat, Oct 1, 2011 at 8:03 AM, Saurabh Salgotra rhtdmja...@gmail.com wrote: IN THIS SHEET SEARCHING IS WORKING BUT IT IS LIMITING FOR SEARCHING THE DATA ONLY FROM ONE SHEET(WHICH IS ADDREDSSED IN FORMULA). I WANT TO SEARCH DATA FROM THE SHEET WHICH I HAVE SELECTED IN THE DROP DOWN LIST I MEAN THAT WHICH SHEET IS SELECTED IN DROPDOWN LIST I GOT THE RESULT FROM THAT SHEET. FORMULA IS: =INDEX(JUN12!$A$2:$A$65536,**SMALL(IF(ISNUMBER(SEARCH($C$3,** JUN12!$B$2:$B$65536)),ROW(**JUN12!$B$2:$B$65536)-MIN(ROW(** JUN12!$B$2:$B$65536))+1,),**ROW(A1))) IN THIS FORMULA I HAVE MENTIONED THE SHEET NAME. SEE DROPDOWNLIST IN D1 I HAVE SELECTED THE SHEET DEC-10, HOW I CAN WRITE THE FORMULA FOR THIS -- -- Some important links for excel users: 1. Follow us on TWITTER for tips
Re: $$Excel-Macros$$ Fwd: date format help
SIMPLE WAY SELECT THAT CELLS GO TO FORMAT CELLS THEN CLICK ON NUMBER--CUSTOM--- TYPE THE DD-MMM-YY IN THE TYPE FIELD On Fri, Sep 30, 2011 at 2:28 PM, Amresh Maurya amreshkushw...@gmail.comwrote: Hi PFA Solution. On Fri, Sep 30, 2011 at 12:49 AM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear All Please go through the mail and help me. Ragards, sanjib -- Forwarded message -- From: Sanjib Chatterjee chatterjee.kolk...@gmail.com Date: Fri, Sep 30, 2011 at 12:15 PM Subject: date format help To: excel-macros excel-macros@googlegroups.com Dear All members, please help me regarding date format in Excel. I want to put the value in excel as dd/mm/, but like to get the value as dd-mmm- (i.e. 30/09/2011 should display 30-sep-2011, 01/12/2011 should display 01-dec-2011) Thank you in advance Regards, Sanjib -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- 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 -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel