Xlookup with nested IF
Thank you in advance for your help. What I am trying to do is return a value (using Xlookup) but only if another value matches. Maybe I need to use Index/Match, but here's my example: Col A Col B Col C Col D Yes John Smith 1.50 No John Smith 1.25 So, I'm trying to enter an Xlookup that will search for "Smith" in column C and return Col D, but only if Col A is also "Yes". I tried =XLOOKUP("Smith",$C:$C,IF($A3="yes",$D:$D,"-"),"-") but I get a "#Value" error. For real life application, I would be replacing "Smith" with a cell reference and "yes" with another cell reference. But for the example, if A=yes, then return D if Col C=Smith. I just need to figure out in which order xlookup (or index/match) would look for those. Any help is appreciated.ODBC error (incorrect syntax) since 2604
Overnight i have the problem that many inserts in my MS Access app do not work anymore. I get the error Run-time error '3155': ODBC--insert on a linked table 'tablename' failed. [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.(#102) I have been able to isolate this issue on a column of type NVARCHAR(MAX). If I insert any value except null in this column the error above will show on save. I tested with other variants of NVARCHAR. The problem happens starting from NVARCHAR(256), thus what is Long Text for Ms Access. When i insert the record first with a value null for this column, no error is generated and the record is saved. If i 'Update' the record later with a text value in this column, that is no problem. So, the ODBC connection generates a sql insert statement that is mallformed in case of a long text. I have this problem consistent on all apps and all tables where i have NVARCHAR(>255). My solution is to go back to office release 2508 (semi annual support).
Functionality to mark a slide complete
I do not believe this functionality alread exists but I'm quite sure I'm not the only one that would love to have it added. Now when working in a larger powerpoint slide deck I start with adding a "traffic light" to my slides that's red, and when the slide is finished I turn it green. Then, before presenting I have to delete all traffic lights before the deck is truly ready. This way I can keep track of which slides still need attention and prevent myself from spending time on slides I shouldn't. Now I believe it would be very nice if it was a built in feature where you can mark individual slides as "complete / final" or "needs attention" with visual feedback of this status in for example the navigation pane. How do others handle this and is there a trick I do not know of?
Crash of Excel
Faulting application name: EXCEL.EXE, version: 16.0.19822.20150, time stamp: 0x69cd5771 Faulting module name: EXCEL.EXE, version: 16.0.19822.20150, time stamp: 0x69cd5771 Exception code: 0xc0000005 Fault offset: 0x000000000004879a Faulting process id: 0xC24C Faulting application start time: 0x1DCD1000E36A5B4 Faulting application path: C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE Faulting module path: C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE Report Id: 0fb8fffd-6a61-48fa-b50b-79d49dc71e0e Faulting package full name: Faulting package-relative application ID: Occurs every 2-3rd day.. Kutools extension is used and crash always occurs when Grid Focus feature of Kutools is enabled.OneNote breaks if I move it onto an external display
Hi guys I use OneNote extensively for work as my virtual notepad. At most of my working locations, I use my laptop - Dell Latitude 7440 - connected to either a Dell Docking station + 2 monitors, or a pair of samsung monitors which have an inbuilt hub, connect via USB-C and are daisychained together. I've never had any issues with OneNote in the past, but recently have found that if I try and move my OneNote window onto either external monitor, it seems to break OneNote - the whole window becomes just the index list which is normally a column on the left (where it shows all your notebooks and pages) and it won't actually display any of the content from the notebooks/pages. If I try minimizing that column, it has a complete breakdown as if its unable to properly load the actual page content. The only way to fix this is to drag the window back to my laptop screen and then close it and reopen. Has anyone else experienced this? It's really frustrating and affecting my productivity as I often need it side-by-side with other screens.
Excel - COUNTIF Function
Happy Friday! I am trying to use the COUNTIF Function on a worksheet that tracks how much liquid chlorine is used at 3 different water wells each month, each well having 2 chlorine cylinders. I'm not sure if my brain is fried from reading/watching all kinds of videos for the past 3 hours and trying to follow their instructions, but any time I put in a formula, I get a pop-up saying I've entered too many arguments. Even if I enter individual cells and use only the 3 that it highlights for me (more than 3 does not highlight). I've attached a screen shot of the worksheet (Figure 1) and have highlighted the area I'm trying to figure out. As you can see, it will be for multiple dates, on multiple lines, going through to the end of the month, with the total chlorine (CL2) tallied up on the right hand side. Chlorine tanks are changed out quite often and each tank begins at 150, depleting down to 0. Figure 2 shows a screen shot of what I'm getting when trying to enter the formula. Am I misunderstanding how the formula works or am I using the wrong formula all together? Figure 1 Figure 2Bitlocker locking me out of laptop computer
I tried to start-up my laptop yesterday and I got a blue "Bitlocker" screen come up and it is asking for a recovery key. It notes the reason "..because Secure Boot policy has changed." I never installed Bitlocker, or set-up. Frankly, I never heard of it. I checked my microsoft log in and there was no bitlocker recovery key in there either. I haven't made any changes to the computer recently. Computer is an HP Envy with solid state drive I believe I am at a loss as to how to deal with this without loosing my data. I spoke to three computer guys and they were not familiar with the Bitlocker. Any assistance would be greatly appreciated.
Formatting issues in Word Microsoft 365 Copilot online.
I am experiencing formatting issues in Word (Microsoft 365 Copilot online). I am a student, and I have a problem formatting my thesis in M365 Copilot after previously working on this file on an older device with an older version of Word. I recently purchased a new laptop, where I no longer have access to that same version of Word. My only option now is to use Word in the browser. However, the file that formatted correctly on the old device is now not formatting properly. The automatic table of contents is breaking. After clicking “Update,” Word assigns random page numbers, most often all entries show as page “8,” or, for example, the “Introduction,” which is actually on page 3 (I manually set page numbering in the old version), suddenly appears as page 5 in the table of contents. Every chapter and subchapter is shown as being on the same page, usually page 8. The formatting options and capabilities also seem worse compared to the interface of the older version. The same issue occurs on my student account. Please help, I am currently writing my thesis.MISSING FUNCTIONS THAT I PREVIOUSLY HAD ACCESS TO
I just switched macbooks and opened my excel to discover I had a few missing functions: MAXIFS, SEQUENCE. This is not a problem regarding the software as mine is MICROSOFT365 and I used the same account previously. Is there any way I can gain these functions back! Thank you!
