$$Excel-Macros$$ Re: vba code help for the open file location
Hi Baluja, It works well. Thanks a lot for your help. Appreciate that. Cheers On Friday, 8 January 2016 13:24:17 UTC+8, Mandeep Baluja wrote: > > Check this out !! > > REgards, > Mandeep baluja > -- 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: vba code help for the open file location
Check this out !! REgards, Mandeep baluja -- 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. update button code.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ vba code help for the open file location
Hi all, I was wondering how could I make the open folder button for file name column instead of file location path column? For instance, from the picture below, when I point my cursor to C:\Users\maggie\Desktop\coke\diet\apr\2F6KB026 and click open file button, it will open the file 2F6KB026. At the moment, I would like to open the file 2F6KB026 by pointing my cursor to 2F6KB026. Please see attached for the vba code. Thanks in advanced. 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. update button code.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ Client in Basking Ridge, NJ need Technical Business Analyst/ PM
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com Person would be coming in to PM with SOE Web Portal that client is developing. Looking for someone who can come in and answer all questions about the website. Need someone who is web savvy and customer focused. Development background helpful. Enterprise experience also helpful. *Interview Process is Phone Screen then in person (2 rounds). * *Location:* *Basking Ridge, NJ * *Duration: 12 months+* *Duties and Responsibilities* Join the asset and vendor management team within Corporate Technology and help us implement new and innovative ways to manage our software and hardware assets more efficiently. In addition, be on the forefront of defining technology standards and introducing cutting edge technologies into our compute environment. Candidate will be responsible for differing functions across the Enterprise Asset Management, Standards, and Cloud team. Responsibilities may include detailed analysis on technology in use across the enterprise, research and analysis of emerging technology and industry trends, and the preparation of internal communications and presentations to promote our organization’s platforms and goals. Candidate will also work closely with various groups across the enterprise to promote the use of asset management and standards tools and help resolve issues impeding the use of these tools. *Qualifications* Excellent written and oral communication skills. Presentation skills are also critical. - Strong organizational and project management skills - Ability to work within a high pressure, often changing environment, and be able to adjust priorities as needed - Ability to create alliances and resolve conflict with other groups in order to be successful - Comfortable with executive updates and presentations - Excellent mix of technical and business acumen - Strong technical foundation and experience with a wide array of technologies - Position is located in Basking Ridge, NJ - Experience with Scrum needed --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as "Spam" as we have included the contact information. If you wish to be removed from our mailing list, please respond with "remove" in the subject field. We apologize for any inconvenience caused. Please consider the environment before printing this e-mail -- 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$$ Client in Houston TX need 3 PHP Consultants
Hi Partner, Hope you are doing great … Please send resume to ma...@genuineitllc.com *Title : PHP Consultants* *Duration: 1 year * *Location: in Houston, TX* JD:- Assists in the evaluation of client area application systems/programming requirements and processes (e.g., new, enhancements or maintenance) *PHP4/5* *OOP/OOD concepts* *HTML5/CSS* *Use of PHP Frameworks (Symfony, CakePHP, Codeignitier, etc)* Experience using MySQL/MySQL command line Knowledge of API development including use of multiple different protocols (JSON/WSDL) Strong understanding of Linux and LAMP Hands-on use of technologies, ranging from front-end user interfaces through back-end systems Understanding of MVC (Model/View/Controller) development approach Experience using version control Git/SVN --- *With Warm Regards * *Madhu Roy* GenuineIT LLC *Certified Women Owned Business* Making IT Happen… Ph: 832 539 3475 Fax: 281-605-5969 *E-Mail* :ma...@genuineitllc.com *Gmail *: *nandimadhu74 , madhu.genuineitllc* *YM *: madhu_recruiter Looking ahead to work with you for better Business prospects According to Bill S.1618 Title III passed by the 105th US Congress, this message is not considered as "Spam" as we have included the contact information. If you wish to be removed from our mailing list, please respond with "remove" in the subject field. We apologize for any inconvenience caused. Please consider the environment before printing this e-mail -- 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$$ Assigning a folder to merge the files in that folder
Hey Mandeep, Its working properly. Thanks ☺☺ On Thu, Jan 7, 2016 at 10:47 PM, Mandeep Baluja wrote: > Check this code now !! > > Regards, > Mandeep baluja > > Sub Merge_Files() > Dim objFSO As Object > Dim objFolder As Object > Dim objFile As Object > Dim i As Long > Dim col_no As Long, row_no As Long > Dim arr_ws As Variant > Dim ws1 As Worksheet, wb1 As Workbook > Dim col_ws1 As Long, row_ws1 As Long > > Set wb1 = ThisWorkbook > Set ws1 = ActiveSheet > > Set d = Application.FileDialog(msoFileDialogFolderPicker) > d.Show > fldpath = d.SelectedItems(1) & "\" > > 'Create an instance of the FileSystemObject > Set objFSO = CreateObject("Scripting.FileSystemObject") > 'Get the folder object > Set objFolder = objFSO.GetFolder(fldpath) > i = 0 > 'loops through each file in the directory and prints their names and path > For Each objFile In objFolder.Files > Debug.Print objFile > i = i + 1 > Workbooks.Open Filename:=objFile > row_no = ActiveSheet.Range(Cells(Rows.Count, 1), Cells(Rows.Count, > 1)).End(xlUp).Row > col_no = ActiveSheet.Range(Cells(1, Columns.Count), Cells(1, > Columns.Count)).End(xlToLeft).Column > arr_ws = ActiveSheet.Range(Cells(1, 1), Cells(row_no, col_no)) > ActiveWorkbook.Close savechanges = no > ws1.Activate > If ws1.Range("A1").Value <> "" Then > row_ws1 = ActiveSheet.Range(Cells(Rows.Count, 1), > Cells(Rows.Count, 1)).End(xlUp).Row + 1 > col_ws1 = ActiveSheet.Range(Cells(1, Columns.Count), Cells(1, > Columns.Count)).End(xlToLeft).Column > Else > row_ws1 = 1 > col_ws1 = 1 > End If > ws1.Range(Cells(row_ws1, 1), Cells(row_ws1 + row_no - 1, col_no)) = > arr_ws > > Next objFile > End Sub > > -- > 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. > -- With Regard !!! Devendra Rahi -- 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$$ Assigning a folder to merge the files in that folder
Hi Experts, Currently I am using below code to merge a set of excel files in one file, but I have to change the path in code, each time for run this code. So if we can assign a path at the time of running this code, would be helpful. So please assist. I have highlighted the code, where am assigning the path to get the .xls files in that folder & merge them., Note- This code create a merged file in the same workbook. Code-- Sub Merge_Files() Dim objFSO As Object Dim objFolder As Object Dim objFile As Object Dim i As Long Dim col_no As Long, row_no As Long Dim arr_ws As Variant Dim ws1 As Worksheet, wb1 As Workbook Dim col_ws1 As Long, row_ws1 As Long Set wb1 = ThisWorkbook Set ws1 = ActiveSheet 'Create an instance of the FileSystemObject Set objFSO = CreateObject("Scripting.FileSystemObject") 'Get the folder object Set objFolder = objFSO.GetFolder("C:\Users\Desktop\(Tech-Specs 3.4)\BULK Excel") i = 0 'loops through each file in the directory and prints their names and path For Each objFile In objFolder.Files i = i + 1 Workbooks.Open FileName:=objFile row_no = ActiveSheet.Range(Cells(Rows.Count, 1), Cells(Rows.Count, 1)).End(xlUp).Row col_no = ActiveSheet.Range(Cells(1, Columns.Count), Cells(1, Columns.Count)).End(xlToLeft).Column arr_ws = ActiveSheet.Range(Cells(1, 1), Cells(row_no, col_no)) ActiveWorkbook.Close savechanges = no ws1.Activate If ws1.Range("A1").Value <> "" Then row_ws1 = ActiveSheet.Range(Cells(Rows.Count, 1), Cells(Rows.Count, 1)).End(xlUp).Row + 1 col_ws1 = ActiveSheet.Range(Cells(1, Columns.Count), Cells(1, Columns.Count)).End(xlToLeft).Column Else row_ws1 = 1 col_ws1 = 1 End If ws1.Range(Cells(row_ws1, 1), Cells(row_ws1 + row_no - 1, col_no)) = arr_ws Next objFile End Sub -- With Regard !!! Devendra Rahi 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. -- 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: Need Help in calculation of score
> > Hey check this out !! >> > Regards, Mandeep baluja -- 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. SG (2).xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: Need Help in calculation of score
Hey SG, It's very difficult to understand your query what you wish or what you want to achieve as may be we both are using different terminology or might be explanation. Sorry to say Hope someone will help you with these given below instructions as I am not able to matchup the aim. You Wrote:- 1) What i need is to calculate the final score in column "I" 2) however, i'm, not able to do distribution of score. "Here the distribution is given in range("K3:P5")" 3) if any of parameter is NA then its score must be distributed in rest of the parameters.(Not to M(Fatal) parameter) 4) Sorry for the confusion. Final score is 100 if all are Yes. 5) I need the formula in Colum "I" for Score.(Distribution of Score in case of "NA" should be calculated here.) 6) The difference in headers are typo errors. 7) d4 & e4 are no..that means their score 30& 10 = 40 gets divided by 4. so the score in k4 is 20,l4=30,m4=0,n4=0,o4 =25 & p4=25,*so that final score in i4 is 100. if any parameter goes "No"*, then its number get deducted from total score. 8) Also, in k11, why the score is 20. It should be 10 only according to the header & same for rest of the cells. Regards, Mandeep baluja -- 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: Need Help in calculation of score
Hi Mandeep, Please refer to the comment in attached sheet. I hope it would get clear now. :) On Thursday, January 7, 2016 at 2:06:11 PM UTC+5:30, Mandeep Baluja wrote: > > Hey SG, > > Correct me if I am wrong !! > 1)If Parameter M(Fatal) is No, then total score would be 0 Formula should > be =IF(H3="No",0 > > 2)If any parameter is "No", then its score should get deducted from final > score formula should be IF(COUNTIF($B$3:$H$3,"No")>0,100-SUM(K3:P3) > Now on combining these two formulas > is =IF(H3="No",0,IF(COUNTIF($B$3:$H$3,"No")>0,100-SUM(K3:P3) > > Confusion !! > 3) if any of parameter is NA then its score must be distributed in rest > of the parameters.(Not to M(Fatal) parameter) > *Score must be distributed in rest of parameters ??? Does it mean > formula should do distribution on which cells ? because k3:p5 is already > filled with your formula.Can you put the output manually below your data.* > > *Regards,* > *Mandeep baluja * > > > -- 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. Book1 - Copy.xlsx Description: MS-Excel 2007 spreadsheet
$$Excel-Macros$$ Re: Need Help in calculation of score
Hi Mandeep, Sorry for the confusion. Final score is 100 if all are Yes. I need the formula in Colum "I" for Score.(Distribution of Score in case of "NA" should be calculated here.) Data in K:P are the values for "Yes" & "No" of data in B:H. PFA updated sheet. The difference in headers are typo errors. Regards, SG On Thursday, January 7, 2016 at 1:11:40 PM UTC+5:30, Mandeep Baluja wrote: > > Hi SG, > > Things I would like to know !!! > 1) What is required You need formula in column "I" or You need to > distribute data in "K3:P5" > 2) Why headers(%) B:H and k:P are different? are they being used in > formulas for calculation. > 3) What is final Score ? > > Can we have the result set below your question with result required > manually for better understanding. > > Regards, > Mandeep baluja > > > > > > -- 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. Book1.xlsx Description: MS-Excel 2007 spreadsheet