Recent Discussions
Loss carry forward for limited years
Hello Excel Community, Excel Version: O365 (Enterprise) I’m running into a mental block trying to model loss carryforward with limited years using a spill formula. Below is a simplified example of what I’m trying to build a formula for. Rules: • A loss from any year can be carried forward for N years, after which it expires and can no longer be used. • In any year with a positive tax liability, if there is any remaining loss from the past N years, you deduct using a FIFO approach (oldest losses used first). • Any unclaimed balance from year N+1 expires, even if it hasn’t been fully used. I’ve found plenty of examples showing loss carryforward without expiration, but I’m struggling to build something that handles both FIFO and expiration in a dynamic array formula. I feel like this must be a solved problem and I’m just missing something obvious. Any help would be greatly appreciated! ------------------------------------------------------------------------------------------How do you respond to...
Hello my Excellers, I wish you all a happy new year full of great things. I have a question and I am not sure if this is a purely an Excel question or something else but maybe I start here and see how it goes: As you all may have noticed the AI craze is blooming like crazy. If you want to sell lettuce slap AI on its label and step back. I use Bing to search for VBA examples. For example I typed "excel vba code to find cells with formulas" and I get AI to find or "compose" a decent example that with minimal editing will work perfectly. But then at the end of the code and its explanation I sometimes find these kind of questions: "If you want to list the addresses of formula cells instead of highlighting them, I can give you a version that outputs them in the Immediate Window or a new sheet. Do you want me to provide that listing version as well?" How do you say YES I want that code that would list the addresses in a sheet? I see buttons like "Undo" rounded Left Arrow, or "Redo" rounded Right arrow, and a "Copy, "Export", and then "Tweak Content", "Rewrite" button, A "Testing Tools" dropdown with options like "Generate test data" and "Integrate test cases", and another dropdown called "More Actions" with options like "Perform code review", "Explain the code", "Add error handling", and "Make code compliable" and the last dropdown "Work Report" with its own options. But I do not see anything that would allow me to say YES I want that code that would list the addresses in a sheet? Thanks for any insight... GiGi
Display Last Value in Column when certain criteria match
Hello all, I am trying to find a way of displaying the last value in a column when certain criteria match... Criteria that need to match would be Design, Colour and Size, so the quantity column would populate with the latest stock quantity: Thanks all! Michael
Microsoft Copilot
Is anyone else having issues today? I was using copilot today like I have been for months. Using the same prompts I have been using for months when I started getting this response "I'd really like to help, but it seems this topic is off-limits for me. sorry about that!" I was trying to discuss with the AI what the issue was and tried showing the prompt when all of a sudden it said I was suspended for an hour. I tried to talk with support but they were no help.
Microsft Forms Permissions
Hello, We created a form for people to RSVP for an event. We shared the link with our invitees. Some individuals when they follow the link will see other peoples answers displayed in the question fields instead of the prompts we created. Furthermore, one individual opened Forms on their computer and saw that they had editing permissions to our form. How could this have happened and is there a way to remove people from what appears to be an editing permission? Thanks!Teams External Collaboration Administrator Role Arrives
Microsoft is introducing a new Entra ID role. The Teams External Collaboration administrator role allows users to manage external collaboration settings. Quite how often Microsoft 365 tenants need to manage these settings is unknown, but it’s a useful prompt to review the current set of roles used and users who are members of those roles. Time for an annual clean-up. https://office365itpros.com/2026/01/14/new-entra-id-role/
Word Document - Projector screen and Monitor Screen
Hi, I am not sure if I can get any best recommendation here. We have a document (usually converted into PDF) that the management used during meetings. The presenter will show it on the big screen via projector in front of a big audience as well as on his wide in a small audience. In the past, the document is using paper size A4. I am not familiar with such projector and screen settings but according to the presenter, the screen (both projecter screen and on his wide screen), the visual does not fill up all the screen space. The new presenter does not like it this way. He wants us to find a solution to get the document "Stretch" or "Fill" up the entire screen (whether projector screen or any wide screen he uses). A stupid idea is to use a custom paper size 16 inches by 9 inches in Word for it....but even that it does not ensure all projector screens and all monitor screens will fit. Therefore this is not a dynamic solution, plus it will messes up all the formatting (example columnal layout width and table width etc) copied from the old A4 file. Does anyone know a good solution for the above request?
Help with Excel Sorting
Hello! I am looking for help with sorting data on a sheet with form responses to different excel sheets. I want to filter by column G to different sheets ("Near Miss", "Adverse Event", "Sentinel Event". The data automatically goes to sheet1 via form responses, but I am trying to streamline the data into specific types of events. I'm using office 365. TIA!
Automatically adding the date/time to a cell when another cell is updated
I am trying to create a spreadsheet where when a specific cell is updated in anyway, the date/time stamp automatically updates in the cell right beneath the cell that was updated. I only need to have a one to one relationship with multiple cells. IOW, I have 5 cells in a row going across. When any one of the 5 cells is updated, I want an updated date/time stamp to appear in the cell directly below the cell that was updated. Is there a way to do this?
Top n vs. Others in Excel
Hi all, I'm seeking some help because I'm kind of new to the more intermediate stuff in Excel. I have an Excel table with the following columns: Subcategory in column A, Brand in column B, Region in column C, Year in column D and Values Month in column E. I want to create a PivotTable and a Pivot line chart from this PivotTable that ranks the Top 5 Brands vs. Other Competitors by each region. For added context: There are 5 subcategories, 3 regions and 25 brands. Currently, I've tried grouping the remaining 20 brands as "Other Competitors" vs. the Top 5 brands within a selected region and possibly all regions (when no selection is made). I'm seeking a solution similar to this... Please mind the colours. I will sort those out later. But, the problem that I'm faced with is that upon selection of a region, the PivotTable won't update to the Top 5 brands of a selected region because they've already been grouped. How can I make this more dynamic so that I'm able to show The Top 5 brands vs. Others? Please help. EDIT: My operating system is Windows 10 (64-bit) and I use Excel 365 (Desktop version). For reference, I've attached a link to a sample file. https://1drv.ms/x/c/b2d878e32a062614/IQC1wcnwLICcQasOfnGcwKn0ASjpXp9xQ6rjnOP10Jal5cc?e=HaXEWd Thank you all once again.
I haven't seen anyone talking about this online store
There is this office and windows key store called esd codes and they sell office keys. They seem legit since they're affiliated with Microsoft and they have mostly positive reviews but I the description of every office key and I mean every has a note stating "if office (literally every single one) version is not available, you will receive the Professional Plus version at the same price" which they are trying to make it look like an upgrade but from what I searched the professional plus versions are bought in bulk by big companies and organizations and after they stop being updated they are being sold for cheap probably by employees. I have found multiple for less than 2 or even 1 buck and I feel they are scamming people.
Bookings - No more notes or extra fields available
Hi there and happy new year to all. Starting from mid-december, we are facing an issue with our company Microsoft Bookings: basically the custom fields (like address, notes and so on). The book page will just ask for Name & Surname, E-mail Address and Phone Number. On our Administration back-end, the Customer Notes fileds is greyed out (you cannot enable it), and all the custom fields disappeared, you have just the standard ones. We have this issue in all our different booking pages, and all the services are affected. Any hint about this? Thanks!
Events
You’re passionate about what you do, and we’re passionate about empowering your potential. Microsoft 365 Community Conference - is your chance to keep up with AI, build game-changing skills, and take...
In-Person
Recent Blogs
- Managing app security and compliance in Microsoft Teams just got easier! With recent updates in Teams Admin Center (TAC), IT admins can now quickly identify trusted apps and enforce organizational st...Jan 14, 2026
- Ask Copilot for tips to help you organize your workspace, your home, or your digital files.Jan 12, 2026
