Look up two parts of a string in a cell
Hello All, I know all about the XLOOKUP() but at times I need a special type of a look up. if I have a cell with the text “Apples and Oranges” how can I write an XLOOKUP to evaluate the “Apples” and then evaluate the “Oranges” parts. for example if I have a list of fruits in a column, then in the next column I have true if the fruit has seeds and false if the fruit does not have seeds. now normally the XLOOKUP will look for the whole string, so if there is no fruit called “Apples and Oranges” it will fail and not return anything. But I do have “Apples” in one cell and it has true for having seeds, AND I do have “Oranges” and it has false for seeds (these are Naval oranges 🤪) so the XLOOKUP will not return false. how can I write an XLOOKUP to return “Apples”, “Oranges”, AND “Apples and Oranges”? I thought of replacing the part after the And but then I’ll lose the fine parts, then I tried splitting the string on “AND” and that did not work at all. I guess you can’t run an XLOOKUP on an array part??? any help will be greatly appreciated!
How XLOOKUP arguments apply in this case
I'm not an Excel newbie, but I have never had cause to use XLOOKUP, INDEX, or MATCH before. I'm not understanding how the xlookup arguments would apply in my case or if index/match would be better. I have an array with months as my row headings and dates as my column headings. The array itself is filled with number of pages read each day. I'm trying to have a cell indicating on which date I did the maximum amount of reading. So I want to start with the max value of my array and return the month (row) and date (column) heading using xlookup. Whether those are in one cell or two, doesn't so much matter - it's a hobby tracker, but no matter how I try and call this, I end up with a value error So for example, I would want this to return January 3rd. Every example I'm finding seems to show how to input Jan 3rd and return the value 758. What am I missing to look this up the other way around? Should I be using index or match instead?
File always corrupt
Anyone have the same problem with me? I use microsoft excel 365 on my mac. At the beginning everything alright, until i use formula and then save the file. When i want to re-open the file, the messagebox showed up "we found something wrong in your content...". It gives 2 option, yes and no. If i click no, the file wont open. If i click yes, the file open, the excel do the recovery, the file open but end up with all the formulas is gone, deleted by excel and just left the value. What should i do? Do the file can still be fixed?
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?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.I need help with the baseball file.
I need help with the baseball file. Thes Teams Do Not Do Anything To Blue Jays White Sox Red Sox Column B At Astros I Want @Astros All Other Teams To Mariners At I Want Vs Mariners All Other Teams To Column C Change Time To One Hour Earlier Trim All Cells I Want Vba Code Thank you very much365 bestand downloaden naar desktop
bijgevoegd (groot) excel bestand kon ik niet meer met de desktop excel versie openen vanwege een beschadigd bestand en/of ander excel probleem (bleef hangen bij het berekenen van alle formules). ik kon het echter wel on-line openen met 365 (uploaden). Ga ervanuit dat daarmee de fout(en) in het on-line bestand gerepareerd zijn. Dus wilde ik het weer downloaden (zowel als xlsx en als csv) om weer verder te gaan met de desktop excel versie maar kreeg de melding dat dat te lang zou duren of te groot was. hoe krjjg ik het bestand nu weer op mijn desktop?
Changing font color increases indent
The task is to color certain words or parts of certain words in the Arabic language. The original text was not indented, like so: but when I color a part of a word, the entire line becomes indented: but if I color the entire word, it goes back: The same thing happens to other fonts, other colors, and other parts of words too: There are other phrases in the cell so an indentation in one line makes it seem like the line has some particular significance when it doesn't. How do I remove that indentation?
