Forum Widgets
Latest Discussions
Add Letter Into Number
I am wanting to see if there is a way to have a letter inserted into a cell that already has a number if another cell meets a certain criteria. See below for example. Cells in Column D are prefilled with a number. Once the adjacent cell in column L is filled, I would want it to put a letter in Column D after the 25 as you see. Anyone know if this is possible? If so what would the formula be? I have racked my brain trying to create it but I'm coming up empty.
PowerQuery not reflecting changes to filenames in Sharepoint Library
Hi All. I've got a simple SPO library with files that I need to query within Excel via PowerQuery, I'm using the Query Type SharePoint List rather than SharePoint Folder because I need other metadata from the library. So far so good, query works great, now the issue, IF I change the filename in the library it does not update in the PowerQuery results. New files will appear OK, other metadata changes appear Version numbers update. Simply the filename will not show the change, Cleared the PowerQuery Cache, that didn't work. File in Library Result in PowerQuery If I create a new Query in a fresh Spreadsheet, same result? Any suggestions greatly appreciated. Cheers Russ
Excel 2021 Dark Mode Not Working – "Switch Mode" Button Unresponsive
Hello, I’m using Microsoft Excel 2021 (Version 2504 Build 16.0.18730.20122) 64-bit on Windows, and the Dark Mode feature is not working despite multiple fixes. Here’s what’s happening: The "Switch Mode" button (under the View tab) does nothing when clicked. Excel’s UI theme is set to Black (via File > Account), and Windows is in Dark Mode. Cells remain white—no dark grid or true dark mode applies. Troubleshooting steps I’ve tried: Updated Office to the latest version. Manually set the registry key UI Theme to 3 (Black) under HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Common. Repaired Office installation via Control Panel. Disabled add-ins and reset Excel settings. Question: Is this a known bug in Excel 2021? Are there additional registry tweaks or workarounds to force dark mode for cells? Thank you for your help!
Sum from cell across multiple sheet, depending on hire date
I can not figure this out, I am trying to make a summary sheet that will count the vacation days across multiple sheets from "Start" to "All" (these are timesheets between those named sheets) for employees. But I need the count to reset on their hire anniversary month and day. Employee 1 - Hired on 1/2/2001 (found in cell B5 on the sheet named "Summary") Employee 2 - Hired on 4/9/2020 (found in cell B6 on sheet named "Summary") In this example, any vacation days in cell F5 (employee 1) across multiple sheets between sheets named "Start" to "All" will count until the anniversary month and day arrives, then it will reset and start counting forward again until that date arrives again. Any help will be much appreciated!
Lookup seat number on table plan
Hello all, hope you can help me. In Excel, I've a table plan where I've assigned names to numbered seats. I now want to read the 'read' that table plan and create a list that tells me the name and seat number. I already have the list of names (in Column L), but need a formula for Column M to do the lookup of the seat number on the table plan. The seat number is always located in the cell above the name. For cell M2, the formula should return that Arthur is in seat C7, and in M3, that Ben is in seat B3, and so on. I suspect the formula could be a combination of one of the Lookup variations, INDEX or MATCH, or even using the CELL command, but I've not fathomed it yet. Does anyone have any suggestions on how I could do it? Many thanks
Stop Microsoft's nagware pop ups
Once more, I'm on a new computer which has reset all of Microsoft's nagware pop ups that remind me how to use a product I've used for literal decades. "Did you know you can click here and do this". "I see you went to a new menu, did you know you could see ____ in this menu but you can't actually see it because this intrusive pop up is blocking it?" "Here is another pop up that deselected the cell you were currently typing in and you didn't notice is for 5 minutes so you have to redo everything you just worked on. Sucks to be you." How the hell do I get this nagware garbage to go away forever and never, ever, ever, ever, ever, ever come back?!
