Forum Widgets
Latest Discussions
Filtering Out Rows With Specific Text When Filtering With Multiple Criteria
I have a workbook to find duplicates in content that is housed on our site. This workbook has different worksheets that are combined into one using Power Query and each instance is tracked using an index key to specify what each is a duplicate of and of which type. From there, I used the Power Query output table name (Duplicates) to create a dashboard, that has search boxes to help narrow down the list so it's easier to find the related duplicates. I'm using the FILTER function to filter the table according to the indexes at the top and ignoring the second, third, and fourth indexes if the search fields are blank. I'm sure there's a better way to do that but it was the only way I could get it to work. =FILTER(Duplicates,ISNUMBER(SEARCH(B1,Duplicates[Index]))+IF(B2<>"",ISNUMBER(SEARCH(B2,Duplicates[Index])))+IF(B3<>"",ISNUMBER(SEARCH(B3,Duplicates[Index]))),IF(B4<>"",ISNUMBER(SEARCH(B4,Duplicates[Index])))) There is a Notes column added at the end of the table that I am trying to target so any items that are marked as "Done" are not in this list. I've tried amending the FILTER function with NOT(ISNUMBER(SEARCH("Done", Duplicates[Notes]))) and using an * or + but it just causes a VALUE error. I have also tried adding ISNUMBER(SEARCH("", Duplicates[Notes])) with an * or + as well. Due to the nature of this content, I cannot share the source file so if I can provide any other clarifying information, please let me know.renee_crozierJan 16, 2025Brass Contributor88Views0likes6CommentsTrouble with 'themes'
Hello all, I have created a colour scheme theme in excel, which I want to save and then put on our company server so that all of my colleagues can download it, and then upload it into their own versions of excel so there's a bit of branding consistency with things like graph colours and font colours etc. I clicked 'Themes > Save Current Theme' and then saved it as a .thmx file My colleague then tested it, by going into her themes > browse for themes, located the .thmx file and opened it - but nothing seemed to happen. The theme I had saved hasn't appeared in her own themes to use. Am I doing something spectacularly dense? We've tested it a number of times, with a number of different people, and nothing seems to happen when they open up that saved theme. Any help would be much appreciated!azrael123Jan 16, 2025Occasional Reader12Views0likes1CommentWhich graph is best to show positive and negative relationship of different variable to one output?
Hi everyone, I am working on a business case study where I have to show a realtionship of 6 x (x1,x2,x3,x4,x5,x6) to a single output (y) . now x1,x2 & x3 have positive relationship with output y for example if x1,x2 and x3 are higher the better for output y but x4,x5,x6 have negative relationship with output y for example if x4,x5,x6 are lower the better for output of y I am struggling to understand which graph should I used or which technique should I used to show on a dashboard that why Y was not achieved based on different behaviors of x1,x2,x3,x4,x5 and x6. Waiting for an answer. thanksExcelGeek90Jan 16, 2025Brass Contributor19Views0likes1CommentAssistance Required for Excel Co-Authoring Sync Issue
Dear Microsoft Support Team, We are encountering an issue with Excel's co-authoring feature and would appreciate your assistance in resolving it. Problem Statement: We are using an Excel file with co-authoring enabled, allowing multiple users to work on the same file stored in OneDrive simultaneously. However, we have noticed a data syncing issue where two users working on the file are seeing different data. This discrepancy appears to stem from the syncing process. Could you please help us investigate and resolve this issue? If there are any recommended steps or troubleshooting methods we should follow, kindly share those as well. We look forward to your support. Best Regards, VipinvipinpanwarJan 16, 2025Copper Contributor15Views0likes1CommentOffice Scripts - How to use "RC" in a Script
Hello, I tried to use ROW(RC) in a conditionnal formula in an Office Script but the result is ROW('RC') and the formula doesn't work. If I use only ROW() my conditonnal formula doesn't work. How can I create a conditionnal formula that refers to an RC reference in Office Script ? Thank you, PS: I use french XL so it's LIGNE(LC) instead of ROW(RC). Arnaud (from France)AAsc49Jan 16, 2025Copper Contributor12Views0likes1Commenttest
Data was exported from one server and has to be imported into another server. The servers accept the information but it has to be re-formatted to be accepted and not throw errors. The down load server export sheet contains a cell of information that will not be accepted by the upload server. It has the header "ITEM SPECIFICS". It generates two columns of data (left & right) the left is the data title or data term. It is followed by a ":" The right side is the associated tombstone data. It is followed by a ",". The column has over 100 terms. If there is no associated data with the term, the ":" is immediately followed by a comma ",".Cannnot_Sign_in_everJan 16, 2025Copper Contributor27Views0likes4CommentsExcel Calendar
I am trying to create a calendar that will update content on dates based on what is entered into a separate table. I have a drop down to select month and year, and a separate table with 3 headers, two of which I would like to appear on the calendar. I am using the following formula to create the calendar: =SEQUENCE(6, 7, DATE(C3, MONTH(DATEVALUE(B3 & " 1")), 1) - WEEKDAY(DATE(C3, MONTH(DATEVALUE(B3 & " 1")), 1), 1) + 1, 1) Along with conditional formatting for the dates. Any feedback on how to do this would be greatly appreciated. J3-L3 are headers for the table (Name, Due Date, Notes) I need content Name and Notes to appear on the corresponding date in the calendar (due date). B3 is the drop down for month, and C3 is the drop down for year. The calendar starts at B6 (days of the weeks listed B5-H5).elranditoJan 16, 2025Occasional Reader23Views0likes1CommentCount how many pairs of dice sum >= 7?
Please help me help someone in another forum. The problem: if we toss a pair of dice (6-sided), what is the probability that their sum is 7 or more? As I demonstrate below, the answer comes down to enumerating and counting the number of pairs with sum >= 7. Then, the probability is (#paired sums >= 7) / #pairs, where #pairs is #sides^2. (The answer is 21/36 = 7/12.) My question is: is there a formula that calculates #paired sums >= 7 without doing the enumeration manually or relying on VBA? I'm guessing that we can use Excel 365 features such as LAMBDA etc. But I know nothing of those features. And less importantly, for my benefit, is there an Excel 2010 formula, without relying on VBA? My "manual" solution:SolvedJoeUser2004Jan 16, 2025Bronze Contributor132Views0likes5CommentsFinding a Commission with the IF Function
I am having trouble with the IF function in a project I am working on in a course. The instructions say, "In the first cell under the heading Commission, create an IF formula that checks if the sales amount on that row is greater than or equal to the target. If it is, the IF formula should calculate the commission due using the named cell. If the target is not met, the IF formula should return the value zero." I have tried typing in: =IF(F2>=G2,"Yes","No") but I am sure that is incorrect because it just tells me that the value is not greater than or equal to. Someone had suggested to put F2*10% instead of "yes", but what should I put for "No"? I have also been told that maybe I need to name a cell, "Commission" or "ComissionRate" where it would contain the value used to calculate the commission with this formula: =IF(F2>=G2,F2*Commission,0). I need to get the commission due. I am unsure of what cell to rename. Perhaps the cell with 10% in it? I have a sample worksheet and an image of what the final sheet should look like for reference: My sheet: https://docs.google.com/spreadsheets/d/124Iv3UvVtQECoKHIFGOzsI2d7H_oJjATaJmYEeMtStw/edit?usp=drive_link If anyone can assist me with this, I will greatly appreciate it. Thank you!katinekoJan 16, 2025Occasional Reader58Views0likes2Comments
Resources
Tags
- Excel41,997 Topics
- Formulas and Functions24,343 Topics
- Macros and VBA6,325 Topics
- office 3655,896 Topics
- Excel on Mac2,605 Topics
- BI & Data Analysis2,315 Topics
- Excel for web1,867 Topics
- Formulas & Functions1,716 Topics
- Need Help1,703 Topics
- Charting1,602 Topics