Finding return value from multiple columns/cells with specific text
Hello, I have to verify multiple cells (C2 to F2) with two possible statuses: "Eligible" and "Not Eligible". In Excel, would it be possible to: If all cells "Eligible", then the result is "Passed". If any of the columns is "Not Eligible", then the result is "Failed". (additional issue) this is not super important but it would be helpful to add one more condition: if any of the columns is "Consult", then the result is "No Result". I'm fine if only the 1st and 2nd issue works, though. I have tried finding solutions in other discussions, but usually the formula that I copy-pasted keep showing "Passed" even if one of the documents is listed as "Not Eligible". Thanks in advance. A B C D E F G 1 No. Name Document 1 Document 2 Document 3 Document 4 Result 2 1 Candidate A Eligible Eligible Eligible Eligible Passed 3 2 Candidate B Eligible Not Eligible Eligible Eligible Failed 4 3 Candidate C Eligible Eligible Consult Eligible No Result 5 4 Candidate D Eligible Eligible Eligible Not Eligible Failed
how to make each excel instance independent?
using Excel version 2603 build 19822.20114 when I have multiple files open, all instances of excel are linked in that when I refresh APIs in one instance, all instances are frozen and I can't even scroll to view. Is there a way to make each instance independent to avoid this? thanks
Allow removal of "Copilot Suggestions" from right-click menu
I have been using Excel for decades and CONSTANTLY use the right-click menu for quick access to basic functions (e.g., "Insert"). Ever since "Copilot Suggestions" was added to the drop-down list, it always throws me off due to its placement. I have Microsoft 365 on Windows 11 Pro. I have searched for ways to remove this from appearing there and the result said "go to File > Options > Copilot and uncheck the 'Enable Copilot' box". However, when I attempt to do that, there is NO "Copilot" option available! PLEASE allow removal of "Copilot Suggestions" from the right-click menu OR at least the option to move it to the bottom (so it isn't in the way of things used ALL the time). I realize that Copilot is a great resource for many users, but I am confident in my Excel skills and in my ability to research/learn new skills the "old school" way, so I have little use for this feature now and would prefer to hide it.
Using calculated columns in pivot table
I already used calculated fields to get some datas in my pivot table. They're displayed as count or sum. I want to make a new calculated fields using a Sum of working time, divide it with the number of operations. How can I use the count and the sum ? Right now, it doesn't seem to use the sum nor the count : Here I want Sum of MBTF to be : Sum of working time/ Count of Stop but the values in Sum of MTBF seems to use the values in Stops (they are dispalyed in my original table as 6/7 numbers, but I used the function count to only get the number of occurences). I believe that's the thing causing my Sum of MTBF to show 1.68E-07 numbers ( for the first line it should be 52.001) : How can I get to have a column displaying the right values (52.001, and others for each line) ? Thank you in advance for your help !
Excel says two numbers are not equal
Column A are numbers typed into the cells. Column B, the numbers in B1 to B3 are also typed in. Cell B4 is SUM(b1:b3) C4 is =B4=A4 Can someone please explain why excel is saying the two numbers in A4 & B4 are not equal. I understand about using rounding or truncation with large calculations but I've never seen anything like this on such a simple calculation. I've tried this on a new spreadsheet and the results are the same. I am using Excel Version 16.109 (26033013) on a Mac. Thank you for your help.
Unwanted format changes on Excel worksheet in SharePoint
Hello - I've been working successfully with an Excel worksheet (.XLSX extension) that is published to SharePoint and has multiple Users viewing/updating data on this worksheet every day. Today, columns on this worksheet keep reverting back to varying widths (some way too wide and others way too narrow) despite going into the worksheet, re-formatting the column widths and saving the document. Other worksheets in the same workbook so far do not exhibit this behavior and are maintaining the desired column formatting (i.e., proper widths). I cannot figure out what is causing this unwanted formatting to happen and it has not happened before. I'm guessing this is an Excel issue, but might the SharePoint component be a factor as well? What are the potential causes of this, and what can I do to make the desired formatting remain and not revert back to the unwanted formatting? Thank you!
Microsoft Excel Update Changed Formula
I've used Excel for the last 2-3 years to track changes in a sheet by month the data listed is added or changed. The formula I've used worked fine until today, when I started receiving an _xlfn in the formula. It now reads as follows: =IF(ISBLANK($A6),$A2,IF((_xlfn.MAXIFS(A$7:A$41,D$7:D$41,">"&0))>=$A$2,_xlfn.MAXIFS(A$7:A$41,D$7:D$41,">"&0),"")) My goal was to have Excel look if there were updated values in D6 and enter the most recent date associated with that value from A6 to A41. Does Excel no longer support MAXIFS?Need a consecutive XLookup
Hello All, OK let me describe what I am trying to do: I need to create a Task List. In this list I will have let’s say 200 tasks, and 50 people to perform these tasks. i need a way to assign the first task to the first person, then the second task to the second person, then the 3rd task to the 3rd person and so on until the first 50 tasks are assigned. then I need to assign the 51st task to the first person, the 52nd to the second person, and the 53rd task to the 3rd person until that batch of tasks and People are matched. but this is not linear, I may want to choose task 52 to person 3 because the 3rd task is related to the 52nd task. i can live without this feature and fine tune the list manually but the main question is how can I look up a name and match it to a task. i hope this makes sense to you, please ask for any clarification and i shall add that bit. thanks in advance… wassim
