Forum Widgets
Latest Discussions
Formula worked in Excel under windows10 but not in Windows 11
=SUMPRODUCT(((Urenregistratie!A2:A2500)=1)*(Urenregistratie!I2:I2500)) The Formula above worked in Excel under windows10 but not in Windows 11, did something change? How can I make my formula work again? Hope anyone can help me... Best regards, Rick.Rick_DijsFeb 10, 2025Copper Contributor36Views0likes4CommentsExcel files will not open
SuddenlyTI cannot open any of my excel files. I unistalled-reinstalled MS office but that did not help. I googled for suggestions but nothing works. Every time I try to open an excel file I get the message "select an app to open this .xlsx file." My files are stored in icloud. Excel only wants to open files stored in one drive. Would appreciate any suggestions. ThanksMbp040146Feb 10, 2025Copper Contributor198KViews0likes5CommentsFormula assistant
Hi All, Attached the following pic: Im trying to create the yellow cells by formula (I made it manually) the rules: if the column date and the raw date is a match so it should give us column H value (exm:cell J7, the column date is 01/01/2025, same as row 7 date so im getting H7 value) one cell to the right where we got our match I want it to take the left cell divide by minus 4 and multy by 3 (15360/4*-3 = -11520) and than to the next 3 cell to the right, I want to get the -11520/-3 = 3840 after 3 cells I want it to get zeroed, thx all in advanced !TomerIwanirFeb 10, 2025Occasional Reader56Views0likes4CommentsMissing slots calculation
Dear Experts, I have data like below:- Each Frame(Column A) has 4 corresponding slots(Column B) :- So, A6(955) has entry 3,8,13,18 , which is a complete set, and so on as shown in the ok(complete set) example. In column J, K , I want to populate the Frames(J == SFN == Frames) which are in complete and in Column K, want to populate the slots which are missing in those corresponding Frames. Attached is the Worksheet. Thanks in Advance, Br, AnupamSolved139Views0likes10CommentsVLOOKUP help required
I am not sure whether to use nested VLOOKUPs or MATCH/INDEX and VLOOKUP to implement what I’m trying to do. On the main worksheet I have populated the Project Category using VLOOKUP based on the project lifecycle entered by the user. =VLOOKUP(H4,Category,2,FALSE) – this works fine and is using Lookup table 1. On the main worksheet, the user will enter in a score for each of the Project Elements (ranging from 1- unacceptable to 5-excellent). What I need to do is – based on the Category, apply the appropriate Weighting factor to the Project Element Scores (lookup table 3) and output that value into another column (called Project Element Weighted Score). Lookup table 1: Lifecycle Category 1-Investigation 1-Conceive 2-Definition 2-Design 3-Implementation 3-Build 4-Production 3-Build 5-Frozen 4-Manage 6-Phase out Started 4-Manage 7-Phased out 4-Manage Lookup table 2: Category Project Elements Score Output value weighting 1-Conceive Personnel 5 5 1 1-Conceive Personnel 4 4 1-Conceive Personnel 3 3 1-Conceive Personnel 2 2 1-Conceive Personnel 1 1 1-Conceive R&D 5 5 5 1-Conceive R&D 4 4 1-Conceive R&D 3 3 1-Conceive R&D 2 2 1-Conceive R&D 1 1 1-Conceive Infrastructure 5 5 2 I have in the weighted score field on the main spreadsheet and a VLOOKUP formula that was working prior to introducing the Weighting by Category concept. I can’t figure out how to include a lookup to to get the category and the corresponding weighting factor and use the correct weighting factor to apply to the score. I hope I’ve been clear enough - I cannot send my spreadsheet as it has cBrenda HinesFeb 10, 2025Copper Contributor923Views0likes2CommentsIs it really impossible to break workbook protection?
Hi, I process personal data and need strict protection (GDPR). My raw data from a survey is copied to several worksheets in a workbook and the processed anonymous data (dashboards) is in other worksheets in the same workbook. Before sending the whole workbook with the visible dashboards to my customers I delete some of the raw data worksheets and hide others. After that I protect the structure of the workbook with a code. Now only the worksheets with the dashboards are visible. Will it at all be possible for my customers to break the protection and get access to the sensitive raw personal data or am I completely safe? Thanks in advance to your reply! Best regards PerSolvedperskovmandrasmussenFeb 10, 2025Copper Contributor3.5KViews0likes17CommentsRepeat list of items for each month in table
Hi all I am looking to have an automatic repeating list of items that repeats based on the amount of months in a table. If however a month is mentioned in the list of items, the item will only repeat for that month only and not all the months in the table. Please see my example spreadsheet with the desired output, which should make it clear. I just need a formula to make this output table. I guess LET would be possible, but can anyone help please? Thank you Mattmatt0020190Feb 10, 2025Brass Contributor36Views0likes3CommentsCheckbox online disappearing when doing to desktop in excel.
When i use Office365 online i can use insert> checkbox and can see the box, when i open it on desktop version the box is gone but can see the true and false value in the formula barSavageswayFeb 10, 2025Occasional Reader24Views0likes5CommentsPlot defects on graph
Hello All, I am not very good with graphs although I believe using a graph would be the best way of doing this. Im making a spreadsheet that will take a "box" based on a defects axial start, length, circumferential center and width and be colour coded based on defect type, and then plot this information on a graph. the graph is more so used to represent the pipes surface. Please see the attached for an example. I have seen some companies do it where the final product looks like the imitation graph that I drew and others where they actually use a cylinder for the pipe shape. Hopefully this is enough information to make sense of what I am after. P.S. the axial distances can sometimes shift. By that I mean the extents. Sometimes the x axis will be from -2m to +18m and other times we will get all positive numbers. Basically which part of the line is exposed. and the defects fall within that area. and then obviously 0 - 360 is always going to be 0-360 degrees. so the y axis never changes. If there are any questions or if I didnt make sense please let me know.Jn12345Feb 10, 2025Brass Contributor13Views0likes1Comment
Resources
Tags
- excel42,174 Topics
- Formulas and Functions24,448 Topics
- Macros and VBA6,348 Topics
- office 3655,930 Topics
- Excel on Mac2,616 Topics
- BI & Data Analysis2,328 Topics
- Excel for web1,878 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,607 Topics