Recent Discussions
Filter overwhelmed? Not showing all data
Hello! I've developed an application for my workplace, logging absences through the year on a backend spreadsheet and presenting the data on a frontend spreadsheet, with a filter available as managers requested the ability to review data based on names, dates, shift times, etc. It is a lot of data, there are 1833 absences logged over the last 2 weeks. The frontend filter continues to work as expected, and there is practically no delay in presenting the data. However, I've noticed that some of the columns are presented as blank. If I open the backend spreadsheet, suddenly the frontend filter shows all columns as populated. I'm not sure how to lessen the load on my filter, as I am assuming there's excess processing afoot. Any ideas worth a try, thank you! Filter code (crunchy, I know. Eek.) The date variables were my only idea to simplify the want to search from, to, and between dates depending on blank cells: " =IFERROR( LET( fromdate,('BACKEND.xlsm]RECORD'!E:E>=G7)*('BACKEND.xlsm]RECORD'!F:F>=G7), todate,('BACKEND.xlsm]RECORD'!E:E<=H7)*('BACKEND.xlsm]RECORD'!F:F<=H7), tweendate,(('BACKEND.xlsm]RECORD'!E:E>=G7)*('BACKEND.xlsm]RECORD'!E:E<=H7))+(('BACKEND.xlsm]RECORD'!F:F>=G7)*('BACKEND.xlsm]RECORD'!F:F<=H7)), blanks,FILTER('BACKEND.xlsm]RECORD'!A:L,('BACKEND.xlsm]RECORD'!B:B<>"")*('BACKEND.xlsm]RECORD'!B:B<>"Co-Ordinator Entering Leave:")*IF(ISBLANK(B3),1,'BACKEND.xlsm]RECORD'!B:B=B3)*IF(ISBLANK(C3),1,'BACKEND.xlsm]RECORD'!C:C=C3)*IF(LEN(E7)>0,'BACKEND.xlsm]RECORD'!D:D=E7,1)*IF(ISBLANK(I3),1,'BACKEND.xlsm]RECORD'!G:G=I3)*IF(ISBLANK(J3),1,'BACKEND.xlsm]RECORD'!J:J=J3)*IF(ISBLANK(K3),1,'BACKEND.xlsm]RECORD'!L:L=K3)*SWITCH(LEN(G7)+LEN(H7),0,1,10,tweendate,5,IF(LEN(G7)=0,todate,fromdate))), IF(blanks=0,"",blanks)),"No Results") " The data / filter results are listed below, of course personal details removed. Columns A, H, I, and K are all presented as blank until the BACKEND spreadsheet is opened (which defeats the purpose of this filter). BACKEND Data RECORDED Co-Ordinator Entering Leave: Employee Name: Date Called: Absence Start Date Absence End Date Shift Time Affected Actioned? Rostered? Reason for Leave Comments Covered by: TRUE John Smith Don Douglas 08/06/2025 09/06/2025 09/06/2025 0900-1730 NO Personal Leave (PL) Sick, recuperating from injury. Note pending. TRUE Jane Smith Deb Douglas 09/06/2025 09/06/2025 09/06/2025 0600-1430 Sick / Injured Did not feel well, Victoria moved to cover. Victoria Veck Jane Smith Doug Douglas 09/06/2025 09/06/2025 09/06/2025 0600-1430 Sick / Injured Victor Veck FILTER Result ENTERED Co-Ordinator Entering Leave: Employee Name: Date Called: Absence Start Date Absence End Date Shift Time Affected Actioned? Rostered? Reason for Leave Comments Covered by: John Smith Don Douglas 08/06/2025 09/06/2025 09/06/2025 0900-1730 Personal Leave (PL) Jane Smith Deb Douglas 09/06/2025 09/06/2025 09/06/2025 0600-1430 Sick / Injured Victoria Veck Jane Smith Doug Douglas 09/06/2025 09/06/2025 09/06/2025 0600-1430 Sick / Injured Victor VeckMaking Python-in-Excel worth it
I feel like Python-in-Excel has huge promise. Embedding a Seaborn correlation matrix in an analysis sheet with a couple lines of readable code? Keeping multiple dimensions of data in one cell efficiently? Making models that involve recursion and iteration without all the workarounds of LET/LAMBDA? Yes please!! I've messed around with it a lot but my experience has mostly been negative and from reading comments it sounds like a lot of others have had bad experiences too. A local version that was unlimited for free would be ideal of course. But I'm going to assume for a minute that isn't possible for business reasons. Most of my frustrations relate to these three things. So maybe if we could get these it would be worth it to use? A way to track usage and buy more credits so we don't get stuck with #BLOCKED! with no recourse Improve the xl() function so it works with variables inside it instead of just literals. e.g. foo = "B4" ; bar = xl(foo) currently doesn't work but it should. The error messages need to always tell you what line number the error is in I'm curious if other folks have tried it and agree or disagree with this wish list.
Returning blank if equal cell value is found
If the value in cell A1 is found in the array D4:D4, I want the cell C1 to be blank. But if the value in cell A1 isn't found in the array D4:D4, I want the cell C1 to print the value of cell A1. However, the cells adjacent to the array automatically ''joins'' the formula and the input becomes grey. What I want: What I write: What I get (with the automatic input in cell C2, C3, and C4 in grey): Anyone who could help?
Problems with a SUMIFS formula
I'm really having some trouble with Excel in that it's not behaving logically. Essentially, what I'm trying to do is conditional sums for spending categorizations. But when I use the formula, I get an error that I can't figure out, because when I use the Function Wizard, it seems to work nicely. But yet, it comes up with this error, and I can't find any information sufficient enough to solve this. Here is the formula: =SUMIFS(B2+H4:H15,H4:H15,"Netspend Account",C2,"Netspend Account")
Data table in Excel copy and paste it within the same sheet
Hi all, I'm working with a one-variable data table in Excel and would like to copy and paste it within the same sheet while keeping it fully functional — including the array behavior and input cell reference. Currently, when I copy and paste the data table to a new location: The pasted result shows only static values (numbers). The data table array/formula disappears. I have to go back to Data > What-If Analysis > Data Table and re-enter the input cell reference each time. Is there a way to duplicate a data table in the same worksheet without needing to manually reset the input cell reference every time? Any suggestions or workarounds would be appreciated. Thank you!
Uploading and Saving a pdf file to OneDrive account on iOS FAILS with Sharesheet option
Uploading and Saving a pdf file FAILS with Sharesheet option from inside any app (like WhatsApp) to open Files app on iOS device and inside it choosing a OneDrive folder and then trying to save the file. It is confirmed that the upload completes when tried from Sharesheet to directly on OneDrive app without using Files app. The upload also happens when tried through OneDrive web. The problem is only when Files are tried to be uploaded on OneDrive account through Files app. The issue is not restricted with PDFs and photos, but occurs with all type of files. It occurs with all type of files like .docx, .xlsx, .pdf, .zip files, etc. This issue occurs from all apps when done through ShareSheet. It occurs when trying to uploading file from other apps via the Sharesheet option (e.g., from iMessage, Photos, or Mail). All the trouble shooting steps, viz. Clear Cache in iOS, Clear OneDrive Account Settings, Offloading the OneDrive app, Re-installing OneDrive app, have been tried multiple times on different iPhones. Yet the problem remains the same on all iPhones.
Markdown and OneNote
2025 and still no markdown support in OneNote(touch supported version). This is Post ChatGPT era and all the LLMs generate text in markdown format. And I am pretty sure, a lot of people out there nowadays generate quick and concise notes through LLMs. But no, OneNote does not wanna render markdown. However, keeping source formatting can format text somewhere close to LLMs output. But not perfectly. The code snippets and tables does not render and appear as a mess. In simple words, I cannot copy LLM output for "Give me code examples of Rust's thread::spawn() function" directly into OneNote because it will be just appear gibberish. NOTE: There are two types of copying. 1) Select text and copy 2) Dedicated copy button in LLM output. So when I say copy I mean *2 as it preserves the markdown syntax.
Filter (autofilter) will not be inserted in Excel 16.97.2 for Mac
Hi all, I'm not able to apply filter in my spreadsheet. I have tried both marking a cell and marking a whole row. Then Data and Filter. I get the the message: Warning. This cannot be used in the marked area. Mark one cell and try again. But I am already in one cell. Please assist me in how to solve this. Thanks!Excel solver frozen
I have dowloaded a file off of brightspace which has been "loading" for literally 2+ weeks because I've been ignoring the issue lol. Im using Mac, so when I try to close the program using the red button in top left corner, there is a pop up that's titled "Loading excel Add-ins" "Loading (2 of 2): solver.xlam". I had installed excel solver last year. any help to close the program so I can start a new file would be greatly appreciated.Transfer OneNote Ownership
A while ago I started a OneNote notebook using my work email address. I shared that notebook out to my personal address. Now I want to transfer ownership to have it be with my personal email address in case I ever leave this job and lose access (this is my work product - I am not looking to take any confidential information). Is this possible? I have been researching for a long time and haven't come up with the solution. Thank youWindows 11 Upgrade mit Intune
I used Intune (Feature Update) to upgrade from Windows 10 to Windows 11. For some devices, the update was completed within 12 hours. However, there were also devices that took 48 hours or longer to update to Windows. In the meantime, I carried out software installations (via Intune) on the devices within an hour. How can I force the feature update? Especially for new devices? Thank you for your support StefanTrying to search for multiple criteria and return multiple results
Hi everyone! I've got a hang up that's easy in my head, but I just can't find the right formula to make it happen. I work in catering and I'm trying to make a sheet that would allow us to search through our menu items for allergens more easily. I currently have a spreadsheet built that lists each menu item we offer, if it's vegetarian or vegan, if it's gluten free, and every allergen it contains (don't ask how long this took). I've attached a screenshot of the mock up version I've been messing around with. Ideally, I would like to be able to select the allergens I want to search for in the green drop down menu boxes, and have the full list of compliant items populate down from the gray cells. So far I've been able to pull a list of each allergen individually, but if a guest has a soy, dairy, nuts and legumes, and a shellfish allergy, it would be nice to be able to pull one cohesive list. Maybe a further stretch, but my wish list for this sheet also involves some way to search "vegetarian" and have ALL of the vegetarian food populate, not just the vegetarian food that isn't vegan. Here are the best potential solutions I've tried so far. If any of these can be tweaked and I missed it, please let me know: I can get XLOOKUP to search for multiple criteria with =XLOOKUP(1,(C3:C9=K6)*(D3:D9=K7),B4:B9,"none"), but then each drop down box had to be assigned a specific allergen, which kind of defeats the point of a drop down list. When I tried to give the lookup array a range that covered two columns, it yelled at me. FILTER worked fine when I was trying to search the entire sheet for one allergen at a time, but I couldn't find a way to make look for the crossover between two allergens when I wanted to refine the search. I tried: =FILTER(B4:G9,(C4:G9=K7),"none") I'm open to any and every solution! I'll try to stay on top of this post if I can answer any clarifying questions. Appreciate the help!Xlookup Displays Previous Match Results When Blank
Hi, I created an Xlookup formula that looks for a match in cell B1 of my spreadsheet (see image below), returning data from other sheets in my workbook. The formula functions perfectly when there is a number in B1, by returning "No Match Found" if the number I enter isn't in the lookup range, but if I delete the number and leave cell B1 blank, Excel displays a previous match -- and not even the last match, but a match from sometime early in the process. It doesn't matter how many other numbers I enter, delete, enter, and delete into that cell, the same previous match pops up when B1 is empty. I should also note that this is happening with the formujlas in columns C and D, but as you can see below, the cell in column B is blank, even though it contains the same XLOOKUP formula - maybe because that cell needs to match B1 and the others are pulling from different columns? Here is my formula: =XLOOKUP($B$1, 'SheetName' !$A$8:$A$1000, 'SheetName' !F$8$:$F$1000,"No Match Found",0). I hope someone can tell me how to return a blank cell when the criteria cell is blank, because I've never had this happen before and have spent way too much time on this issue.
Formula 4 week rotation excluding Fridays and weekends
Hi. I'm creating an employee work calendar. I need to formulas. One i have it but the other one i cannot figure it out. Employee A works from home, called W, one day a week. Week 1 on a monday, week 2 on a tuesday, week 3 on a wednesday, week 4 on a thursday, week 5 on a monday and so on. Fridays not available and saturdays and sunday are weekends. My formula only works if the first of the month is a monday. So i cannot do another month plus i cannot figure it out for employee B when the working from home is a Tuesday for week 1, can someone tell me what i'm doing wrong?Access Help
I am trying to create a rather simple dbase and need a bit of guidance. I have two tables, and in the first table I have a column titled component #. The 2nd table houses all the data associated with the Component #s. When keying data in the component # field on the first table, I would like access to look at the 2nd (Component #s) Table, and if that # doesn't already exist I want a box to pop up (a form, I imagine) that will allow the component # and associated data to be added to Component Table. Also, if the # doesn't exist in the component table the record cannot be saved. Can anyone provide guidance on how I might accomplish that. Thanks in advance
No Save Query on close
I have assembled a few workbooks that perform search functions or calculations that I allow others to use. I have the workbooks protected and I have locked all but the input cells. What I'm looking for is to not have Excel ask if you want to save the workbook when closing the file. It's protected so it can't be saved but I would like to disable the query so as not to confuse anyone. Is there a way to do this on Excel 365? BTW: Since the input cells are blank, it is returning errors and zeros. Is there a way to fix that too? Thanks
Recent Blogs
- Join us as we celebrate Pride, specifically the Pride we have for each other. Pride has always been a celebration of identity—visibility, self-expression, and the joy of being unapologetically yourse...Jun 05, 2025
- We are excited to announce that Microsoft 365 and the Microsoft 365 Advanced Data Residency add-on (ADR) are now available for commercial customers in MalaysiaJun 04, 2025
