Re: $$Excel-Macros$$ Counting up the combinations
OK, people, I like a good dialog as much as anyone else. But will you please stop using this thread for your conversation! Thanks, Greg Della-Croce -- 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.
Re: $$Excel-Macros$$ Counting up the combinations
On Mon, 2/20/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Counting up the combinations To: excel-macros@googlegroups.com Date: Monday, February 20, 2017, 9:23 PM On Mon, 2/20/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Counting up the combinations To: excel-macros@googlegroups.com Date: Monday, February 20, 2017, 7:11 PM On Mon, 2/20/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Counting up the combinations To: "excel-macros@googlegroups.com" Date: Monday, February 20, 2017, 4:50 PM What's the format of your survey results? My script "assumes" that the current sheet has three columns: Survey#, Question, Answer in columns A, B, and C. It places the summary in columns F:Kwith the header of: Question#, Ans_1, Ans_2, Ans_3, Ans_4, Ans_5 Sub CountArray() Dim Results(1 To 4, 1 To 5) Dim nRow, nRows Dim qNo As Integer, qVal As Integer nRows = Application.WorksheetFunction.CountA(Range("A:A")) For nRow = 2 To nRows qNo = Cells(nRow, "B").Value qVal = Cells(nRow, "C").Value Results(qNo, qVal) = Results(qNo, qVal) + 1 Next nRow For qNo = 1 To 4 For qVal = 1 To 5 Cells(qNo + 1, qVal + 6).Value = Results(qNo, qVal) Next qVal Next qNo MsgBox "Fin" End Sub Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Monday, February 20, 2017 8:43 AM, Greg Della-Croce wrote: Paul, That is an excellent idea! All my survey results are on one page of on workbook. So this should be fairly simple to write. Thanks!! Greg Della-CroceSkype: gdellacroce55Cell: 407-408-2572greg_della-cr...@sil.org"If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - Rod Favarod, CEO of Spredfast On Mon, Feb 20, 2017 at 7:55 AM, Paul Schreiner wrote: How are your survey results stored?Are they separate files?or have you already combined them into one workbook? What *I* would do would define an array:Results(QuestionNo, QuestionVal) Dim Results(1 to 4,1 to 5) Then, go through your surveys and increment the array value for each questionThat is: Question 1, value 1, increment Results(1,1) by 1: Results(qNo, qVal) = Results(qNo, qVal) + 1 Once you've populated the array, you can use nested loops to write the values: For qNo = 1 To 4 For qVal = 1 To 5 Cells(qNo + 1, qVal).Value = Results(qNo, qVal) Next qVal Next qNo Since I don't know how your data is formatted, it is difficult to write sample code. I created a worksheet of 1000 surveys, 4 questions each, and random values 1-5. The entire subroutine to count the values and write out the results was 20 lines and took less than a second to run! If you have to open each survey separately, it will take significantly longer :) let me know if you need additional assistance. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Saturday, February 18, 2017 6:28 PM, Greg Della-Croce wrote: I have a sheet of responses to a short survey. The survey asked 4 questions with range answers (1 to 5, 5 being best), and then two open-ended questions. I would like to count up the number of each combination of answers with the range answers. So for all of the surveys, I would like to know how many people that answered 1 to question 1 answered question 2 - 1, 3 -1, 4-1, and how many of those people answered 2-2, 3-1, 4-1, and how many answered 2-1, 3-2, 4-1, and so forth for all of the combinations of answers. I just can not figure out the right algorithm to do this without hard-coding ever possible combo. Would someone know where I could get some h
Re: $$Excel-Macros$$ Counting up the combinations
On Mon, 2/20/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Counting up the combinations To: excel-macros@googlegroups.com Date: Monday, February 20, 2017, 7:11 PM On Mon, 2/20/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Counting up the combinations To: "excel-macros@googlegroups.com" Date: Monday, February 20, 2017, 4:50 PM What's the format of your survey results? My script "assumes" that the current sheet has three columns: Survey#, Question, Answer in columns A, B, and C. It places the summary in columns F:Kwith the header of: Question#, Ans_1, Ans_2, Ans_3, Ans_4, Ans_5 Sub CountArray() Dim Results(1 To 4, 1 To 5) Dim nRow, nRows Dim qNo As Integer, qVal As Integer nRows = Application.WorksheetFunction.CountA(Range("A:A")) For nRow = 2 To nRows qNo = Cells(nRow, "B").Value qVal = Cells(nRow, "C").Value Results(qNo, qVal) = Results(qNo, qVal) + 1 Next nRow For qNo = 1 To 4 For qVal = 1 To 5 Cells(qNo + 1, qVal + 6).Value = Results(qNo, qVal) Next qVal Next qNo MsgBox "Fin" End Sub Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Monday, February 20, 2017 8:43 AM, Greg Della-Croce wrote: Paul, That is an excellent idea! All my survey results are on one page of on workbook. So this should be fairly simple to write. Thanks!! Greg Della-CroceSkype: gdellacroce55Cell: 407-408-2572greg_della-cr...@sil.org"If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - Rod Favarod, CEO of Spredfast On Mon, Feb 20, 2017 at 7:55 AM, Paul Schreiner wrote: How are your survey results stored?Are they separate files?or have you already combined them into one workbook? What *I* would do would define an array:Results(QuestionNo, QuestionVal) Dim Results(1 to 4,1 to 5) Then, go through your surveys and increment the array value for each questionThat is: Question 1, value 1, increment Results(1,1) by 1: Results(qNo, qVal) = Results(qNo, qVal) + 1 Once you've populated the array, you can use nested loops to write the values: For qNo = 1 To 4 For qVal = 1 To 5 Cells(qNo + 1, qVal).Value = Results(qNo, qVal) Next qVal Next qNo Since I don't know how your data is formatted, it is difficult to write sample code. I created a worksheet of 1000 surveys, 4 questions each, and random values 1-5. The entire subroutine to count the values and write out the results was 20 lines and took less than a second to run! If you have to open each survey separately, it will take significantly longer :) let me know if you need additional assistance. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Saturday, February 18, 2017 6:28 PM, Greg Della-Croce wrote: I have a sheet of responses to a short survey. The survey asked 4 questions with range answers (1 to 5, 5 being best), and then two open-ended questions. I would like to count up the number of each combination of answers with the range answers. So for all of the surveys, I would like to know how many people that answered 1 to question 1 answered question 2 - 1, 3 -1, 4-1, and how many of those people answered 2-2, 3-1, 4-1, and how many answered 2-1, 3-2, 4-1, and so forth for all of the combinations of answers. I just can not figure out the right algorithm to do this without hard-coding ever possible combo. Would someone know where I could get some help doing this in Exel, or suggest a better program? Thanks -- 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 attenti
$$Excel-Macros$$ *** we provide GC and USC only ***
we provide GC and USC only This is Mike from Golok Global . I have a* Tableau Developer/Admin , DevOps,Java Devloper,Java UI Devloper* those are GC’s and citizens . if you have any requirements for my candidates*.* Please forward your requirements to my mail Id:*m...@golokglobal.com* Desk No: *9722329938* -- 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.
$$Excel-Macros$$ *** we provide GC and USC only ***
we provide GC and USC only This is Mike from Golok Global . I have a* Tableau Developer/Admin , DevOps,Java Devloper,Java UI Devloper* those are GC’s and citizens . if you have any requirements for my candidates*.* Please forward your requirements to my mail Id:*m...@golokglobal.com* Desk No: *9722329938* -- 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.
Re: $$Excel-Macros$$ Counting up the combinations
On Mon, 2/20/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Counting up the combinations To: "excel-macros@googlegroups.com" Date: Monday, February 20, 2017, 4:50 PM What's the format of your survey results? My script "assumes" that the current sheet has three columns: Survey#, Question, Answer in columns A, B, and C. It places the summary in columns F:Kwith the header of: Question#, Ans_1, Ans_2, Ans_3, Ans_4, Ans_5 Sub CountArray() Dim Results(1 To 4, 1 To 5) Dim nRow, nRows Dim qNo As Integer, qVal As Integer nRows = Application.WorksheetFunction.CountA(Range("A:A")) For nRow = 2 To nRows qNo = Cells(nRow, "B").Value qVal = Cells(nRow, "C").Value Results(qNo, qVal) = Results(qNo, qVal) + 1 Next nRow For qNo = 1 To 4 For qVal = 1 To 5 Cells(qNo + 1, qVal + 6).Value = Results(qNo, qVal) Next qVal Next qNo MsgBox "Fin" End Sub Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Monday, February 20, 2017 8:43 AM, Greg Della-Croce wrote: Paul, That is an excellent idea! All my survey results are on one page of on workbook. So this should be fairly simple to write. Thanks!! Greg Della-CroceSkype: gdellacroce55Cell: 407-408-2572greg_della-cr...@sil.org"If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - Rod Favarod, CEO of Spredfast On Mon, Feb 20, 2017 at 7:55 AM, Paul Schreiner wrote: How are your survey results stored?Are they separate files?or have you already combined them into one workbook? What *I* would do would define an array:Results(QuestionNo, QuestionVal) Dim Results(1 to 4,1 to 5) Then, go through your surveys and increment the array value for each questionThat is: Question 1, value 1, increment Results(1,1) by 1: Results(qNo, qVal) = Results(qNo, qVal) + 1 Once you've populated the array, you can use nested loops to write the values: For qNo = 1 To 4 For qVal = 1 To 5 Cells(qNo + 1, qVal).Value = Results(qNo, qVal) Next qVal Next qNo Since I don't know how your data is formatted, it is difficult to write sample code. I created a worksheet of 1000 surveys, 4 questions each, and random values 1-5. The entire subroutine to count the values and write out the results was 20 lines and took less than a second to run! If you have to open each survey separately, it will take significantly longer :) let me know if you need additional assistance. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Saturday, February 18, 2017 6:28 PM, Greg Della-Croce wrote: I have a sheet of responses to a short survey. The survey asked 4 questions with range answers (1 to 5, 5 being best), and then two open-ended questions. I would like to count up the number of each combination of answers with the range answers. So for all of the surveys, I would like to know how many people that answered 1 to question 1 answered question 2 - 1, 3 -1, 4-1, and how many of those people answered 2-2, 3-1, 4-1, and how many answered 2-1, 3-2, 4-1, and so forth for all of the combinations of answers. I just can not figure out the right algorithm to do this without hard-coding ever possible combo. Would someone know where I could get some help doing this in Exel, or suggest a better program? Thanks -- 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. --- Y
$$Excel-Macros$$ الدورة التدريبية تكنولوجيا الإدارة الذكية التحول من الإدارة الإلكترونية الى الإدارة الذكية إدارة المستقبل والخدمات الذكية دبى – الامارات العربية المتحدة )Smart technology management)
*الدار العربية للتنمية الإدارية* *بالتعاون مع الإتحاد الدولى لمؤسسات التنمية البشرية* *الدورة التدريبية * *تكنولوجيا الإدارة الذكية * *التحول من الإدارة الإلكترونية الى الإدارة الذكية * *إدارة المستقبل والخدمات الذكية * *دبى – الامارات العربية المتحدة * *)**Smart technology management)* *خلال الفترة من 26 الى 29 مارس 2017 م* *تهدف الورشة الى * : *تزويد المشتركين **بالمعرفة العامة في مختلف المجالات في نظام إدارة الموارد البشرية. تركز الدورة على منهج الأنظمة في إدارة الموارد البشرية, و التطوير والتحليل الوظيفي, و التصميم والتقييم, و تخطيط الموارد البشرية, والتوظيف والاختيار، و إدارة الأداء, و التدريب والتطوير، إضافة الى اتجاهات جديدة في مجال إدارة الموارد البشرية* *.* *سيتمكن المشتركون من كسب المعرفة العامة في المجالات المختلفة داخل نظام إدارة الموارد البشرية**.* *مستهدفين في ذلك* *موظفى الموارد البشرية والاشخاص المهتمين بذلك المجال .. * *والدار العربية يسرها دعوتكم للمساهمة والمشاركة في أعمال الفاعليات من خلال تجربة مميزة أو بالحضور والمناقشة، كذلك ترشيح من ترون من كوادر مؤسستكم الموقرة وتمنح الدار العربية مقعدا خامس مجانا في حال ترشيح سيادتكم اربع افراد من مؤسستكم الموقرة.* *تأكيد المشاركة* *يتم إرسال خطاب المشاركة الرسمى او تعبئة النموذج المرفق موضح بة أسماء المرشحين – مناصبهم الإدارية - اسم النشاط – طريقة سداد رسوم المشاركة ( كاش اول أيام التدريب او بتحويل بنكى قبل بدء النشاط)وصورة من تذكرة الطيران **علماً بأن رسوم الاشتراك 1500دولار أمريكى* *للفرد* *علي فاكس رقم *0020237800573 او0020235866323 *اوعلي * *بريدي الإلكتروني**saragw...@gmail.com* -- 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.
Re: $$Excel-Macros$$ Counting up the combinations
What's the format of your survey results? My script "assumes" that the current sheet has three columns: Survey#, Question, Answer in columns A, B, and C. It places the summary in columns F:Kwith the header of: Question#, Ans_1, Ans_2, Ans_3, Ans_4, Ans_5 Sub CountArray() Dim Results(1 To 4, 1 To 5) Dim nRow, nRows Dim qNo As Integer, qVal As Integer nRows = Application.WorksheetFunction.CountA(Range("A:A")) For nRow = 2 To nRows qNo = Cells(nRow, "B").Value qVal = Cells(nRow, "C").Value Results(qNo, qVal) = Results(qNo, qVal) + 1 Next nRow For qNo = 1 To 4 For qVal = 1 To 5 Cells(qNo + 1, qVal + 6).Value = Results(qNo, qVal) Next qVal Next qNo MsgBox "Fin" End Sub Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Monday, February 20, 2017 8:43 AM, Greg Della-Croce wrote: Paul, That is an excellent idea! All my survey results are on one page of on workbook. So this should be fairly simple to write. Thanks!! Greg Della-CroceSkype: gdellacroce55Cell: 407-408-2572greg_della-cr...@sil.org"If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - Rod Favarod, CEO of Spredfast On Mon, Feb 20, 2017 at 7:55 AM, Paul Schreiner wrote: How are your survey results stored?Are they separate files?or have you already combined them into one workbook? What *I* would do would define an array:Results(QuestionNo, QuestionVal) Dim Results(1 to 4,1 to 5) Then, go through your surveys and increment the array value for each questionThat is: Question 1, value 1, increment Results(1,1) by 1: Results(qNo, qVal) = Results(qNo, qVal) + 1 Once you've populated the array, you can use nested loops to write the values: For qNo = 1 To 4 For qVal = 1 To 5 Cells(qNo + 1, qVal).Value = Results(qNo, qVal) Next qVal Next qNo Since I don't know how your data is formatted, it is difficult to write sample code. I created a worksheet of 1000 surveys, 4 questions each, and random values 1-5. The entire subroutine to count the values and write out the results was 20 lines and took less than a second to run! If you have to open each survey separately, it will take significantly longer :) let me know if you need additional assistance. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Saturday, February 18, 2017 6:28 PM, Greg Della-Croce wrote: I have a sheet of responses to a short survey. The survey asked 4 questions with range answers (1 to 5, 5 being best), and then two open-ended questions. I would like to count up the number of each combination of answers with the range answers. So for all of the surveys, I would like to know how many people that answered 1 to question 1 answered question 2 - 1, 3 -1, 4-1, and how many of those people answered 2-2, 3-1, 4-1, and how many answered 2-1, 3-2, 4-1, and so forth for all of the combinations of answers. I just can not figure out the right algorithm to do this without hard-coding ever possible combo. Would someone know where I could get some help doing this in Exel, or suggest a better program? Thanks-- 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+unsubscribe@ 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. -- Are yo
Re: $$Excel-Macros$$ Counting up the combinations
On Mon, 2/20/17, Greg Della-Croce wrote: Subject: Re: $$Excel-Macros$$ Counting up the combinations To: excel-macros@googlegroups.com Date: Monday, February 20, 2017, 3:42 PM Paul, That is an excellent idea! All my survey results are on one page of on workbook. So this should be fairly simple to write. Thanks!! Greg Della-CroceSkype: gdellacroce55Cell: 407-408-2572greg_della-cr...@sil.org"If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - Rod Favarod, CEO of Spredfast On Mon, Feb 20, 2017 at 7:55 AM, Paul Schreiner wrote: How are your survey results stored?Are they separate files?or have you already combined them into one workbook? What *I* would do would define an array:Results(QuestionNo, QuestionVal) Dim Results(1 to 4,1 to 5) Then, go through your surveys and increment the array value for each questionThat is: Question 1, value 1, increment Results(1,1) by 1: Results(qNo, qVal) = Results(qNo, qVal) + 1 Once you've populated the array, you can use nested loops to write the values: For qNo = 1 To 4 For qVal = 1 To 5 Cells(qNo + 1, qVal).Value = Results(qNo, qVal) Next qVal Next qNo Since I don't know how your data is formatted, it is difficult to write sample code. I created a worksheet of 1000 surveys, 4 questions each, and random values 1-5. The entire subroutine to count the values and write out the results was 20 lines and took less than a second to run! If you have to open each survey separately, it will take significantly longer :) let me know if you need additional assistance. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Saturday, February 18, 2017 6:28 PM, Greg Della-Croce wrote: I have a sheet of responses to a short survey. The survey asked 4 questions with range answers (1 to 5, 5 being best), and then two open-ended questions. I would like to count up the number of each combination of answers with the range answers. So for all of the surveys, I would like to know how many people that answered 1 to question 1 answered question 2 - 1, 3 -1, 4-1, and how many of those people answered 2-2, 3-1, 4-1, and how many answered 2-1, 3-2, 4-1, and so forth for all of the combinations of answers. I just can not figure out the right algorithm to do this without hard-coding ever possible combo. Would someone know where I could get some help doing this in Exel, or suggest a better program? Thanks -- 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+unsubscribe@ 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. -- 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 ev
Re: $$Excel-Macros$$ Counting up the combinations
Paul, That is an excellent idea! All my survey results are on one page of on workbook. So this should be fairly simple to write. Thanks!! Greg Della-Croce Skype: gdellacroce55 Cell: 407-408-2572 greg_della-cr...@sil.org "If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - *Rod Favarod, CEO of Spredfast* On Mon, Feb 20, 2017 at 7:55 AM, Paul Schreiner wrote: > How are your survey results stored? > Are they separate files? > or have you already combined them into one workbook? > > What *I* would do would define an array: > Results(QuestionNo, QuestionVal) > > Dim Results(1 to 4,1 to 5) > > Then, go through your surveys and increment the array value for each > question > That is: Question 1, value 1, increment Results(1,1) by 1: > > Results(qNo, qVal) = Results(qNo, qVal) + 1 > > Once you've populated the array, you can use nested loops to write the > values: > For qNo = 1 To 4 > For qVal = 1 To 5 > Cells(qNo + 1, qVal).Value = Results(qNo, qVal) > Next qVal > Next qNo > > Since I don't know how your data is formatted, it is difficult to write > sample code. > > I created a worksheet of 1000 surveys, 4 questions each, and random values > 1-5. > > The entire subroutine to count the values and write out the results was 20 > lines and took less than a second to run! > > If you have to open each survey separately, it will take significantly > longer :) > > let me know if you need additional assistance. > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > > On Saturday, February 18, 2017 6:28 PM, Greg Della-Croce < > greg_della-cr...@sil.org> wrote: > > > > > I have a sheet of responses to a short survey. The survey asked 4 > questions with range answers (1 to 5, 5 being best), and then two > open-ended questions. I would like to count up the number of each > combination of answers with the range answers. So for all of the surveys, > I would like to know how many people that answered 1 to question 1 answered > question 2 - 1, 3 -1, 4-1, and how many of those people answered 2-2, 3-1, > 4-1, and how many answered 2-1, 3-2, 4-1, and so forth for all of the > combinations of answers. > > I just can not figure out the right algorithm to do this without > hard-coding ever possible combo. Would someone know where I could get some > help doing this in Exel, or suggest a better program? > > Thanks > -- > 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. > > > -- > 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 a topic in the > Google Groups "MS EXCEL AND VBA MACROS" group. > To unsubscri
Re: $$Excel-Macros$$ Password Protection
That is not an "Excel macros" question.What you're looking for is a method to password "encrypt" adobe pdf files (try googling that) If, in Excel, you have a list of files and the Employee code for each file, you may be able to write a macro using SendKeys. However, Googling "automate password protect pdf files" seems to provide options to create a "batch" process using the Acrobat application. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Monday, February 20, 2017 12:24 AM, karthikeyan sankaran wrote: Dear All, I have 100 adobe Payslip-files in one folder. I have share that folder via mail to everyone. Now , I need to enter Employee code that particular Adobe file only wants to open. Other adobe Payslip-files does not show to others. Thanks,karthik.-- 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. -- 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.
Re: $$Excel-Macros$$ Counting up the combinations
How are your survey results stored?Are they separate files?or have you already combined them into one workbook? What *I* would do would define an array:Results(QuestionNo, QuestionVal) Dim Results(1 to 4,1 to 5) Then, go through your surveys and increment the array value for each questionThat is: Question 1, value 1, increment Results(1,1) by 1: Results(qNo, qVal) = Results(qNo, qVal) + 1 Once you've populated the array, you can use nested loops to write the values: For qNo = 1 To 4 For qVal = 1 To 5 Cells(qNo + 1, qVal).Value = Results(qNo, qVal) Next qVal Next qNo Since I don't know how your data is formatted, it is difficult to write sample code. I created a worksheet of 1000 surveys, 4 questions each, and random values 1-5. The entire subroutine to count the values and write out the results was 20 lines and took less than a second to run! If you have to open each survey separately, it will take significantly longer :) let me know if you need additional assistance. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Saturday, February 18, 2017 6:28 PM, Greg Della-Croce wrote: I have a sheet of responses to a short survey. The survey asked 4 questions with range answers (1 to 5, 5 being best), and then two open-ended questions. I would like to count up the number of each combination of answers with the range answers. So for all of the surveys, I would like to know how many people that answered 1 to question 1 answered question 2 - 1, 3 -1, 4-1, and how many of those people answered 2-2, 3-1, 4-1, and how many answered 2-1, 3-2, 4-1, and so forth for all of the combinations of answers. I just can not figure out the right algorithm to do this without hard-coding ever possible combo. Would someone know where I could get some help doing this in Exel, or suggest a better program? Thanks-- 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. -- 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.
$$Excel-Macros$$ Re: Organizational Chart
Hi Kiran, Herewith i have attached as you asked. Please check & let me, if you have any questions. *Thanks & Regards,* *Suresh Kumar.B* *Mobile # 9894585740* On Thursday, February 2, 2017 at 12:53:41 AM UTC+5:30, Kiran Kancherla wrote: > > Hi All: > > I have different kind of requirement in which I have to prepare > Organizational Chart. > > I have googled my requirements but in all the codes, they are adding some > reporting numbers or something. In my current sheet I will be giving the > same some senior management executive. > > In my current case name are only the unique once. > > Attached the sample xlsx and with sample sheet. > > Request you help me with code as I cannot add 'Add ins' in my office > environment. > > Thanks in advance. > > Regards, > Kiran > -- 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. {Modified}Sample Data and Chart.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Re: Need Help in Macros for Currency change in numbers to text
Hi *Sachin*, As you said, I have made changes in the file through formulas Please check & let me know, If any Changes. *Thanks & Regards,* *Suresh Kumar.B* *Mobile #9894585740* On Friday, February 17, 2017 at 10:53:19 AM UTC+5:30, सचिन शर्मा wrote: > > Thanks Suresh, > > It's working and shows "*and*" before last 2 "00" digits. > > but, if value comes less then 100 then "*Hundred And*" still visible > (Ex.: 99 = *Hundred and Ninety Nine Rupees Only*) > > > > On Monday, February 6, 2017 at 4:24:42 PM UTC+5:30, सचिन शर्मा wrote: >> >> Dear Experts, >> >> Please help to resolve below requirement. >> >> File attached for reference. >> >> >> *Numbers .: 1,054,265* >> >> *Result Shows .: *Ten Lakh Fifty Four Thousand Two Hundred Sixty Five >> Rupees Only >> >> *Required format .: *Ten Lakh Fifty Four Thousand Two Hundred *and *Sixty >> Five Rupees Only >> >> Thanks and Regards >> *Sachin Sharma* >> > -- 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. Invoice_Format(Modified).xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12