Recent Discussions
Filter Function or TAKE-DROP Function
Dear Experts, I have a Data like this:- Column A -> Has the File Names, and Column B,C,D have their corresponding data, In Column F I have the unique File Names and from G/H/I -> I need the start of the hfn/sfn/slot and in J/K/L the end of the hfn/sfn/slot for that File Name as populated , How to achieve this? Thanks & Regards Anupam Shrivastava
Conditional Formatting or a Specific Filter Rule
Dear Experts , I have a data like below:- here the Column-O, txNumber can go from 1,2,3 (txNum=2 and 3 means a Retransmission), I want to filter all the pairs for all Transmissions and their corresponding Retransmissions ( either by coloring them all using a conditional formatting) or using a specific filter Rule. How to identify the Transmission and it's corresponding Retransmission for a Specific HarqId( say for dlHarqProcessIndex ==7, the blue color Row-37 is my 1st transmission(txNumber ==1) for the dlHarqProcessIndex==7 with a tbSize of 852696, and adaptRetxStatus == NOTACTIVATE, and it's corresponding 2nd transmission( Retransmission , txNumber==2) Row-45, tbSize remains same(as it's corresponding 1st transmission) in all retransmissions and adaptRetxStatus changes to "APPLY" for all retrans txNumber==2,3) and similarly for other pairs like for dlHarqProcessIndex==13. Attached is the Worksheet.XLOOKUP search w/multiple output
I've been working on a project and I am completely stumped. I cannot wrap my brain around how to get this to work. In the example below, I want to Enter a number in either of the top two field and have the last three fields populate. Now, I can get this to work for one, but not the other and for some reason when I switch from bottom search to the top search the old data doesn't clear and the search doesn't work. This is the formula I have so far //=XLOOKUP(H8,A2:A10606,B2:B10606) Anything I have done after has been a disaster
Excel returns incorrect answer to simple multiplication.
I'm saving a few favourite math examples, and ran into a problem - the last of the calculations came back with an incorrect answer. I'm using a simple =cell1*cell2 formula. It should end with 21. Please help I'm using android app. All cells formatted as numbers.
Trying to create a form field that uses images (but not a simple one!)...
I have a Word form that uses a https://www.fema.gov/emergency-managers/practitioners/lifelines-toolkit/lifelines-icons used in the public safety community. For each icon, there are four different border colours, indicating a certain level of urgency, using the TLP model - green, yellow, red, grey. What I would like to do is create a dropdown (elsewhere on the form) where someone chooses an option in that field, and depending on the choice, the icon with the corresponding colour displays. Example: Any assistance is appreciated!Link 2 sheets, then sort column A on sheet 2 alphabetically and match correct data
I have two sheets on the same spreadsheet, and I want to pull in the data from 4 different columns to the second sheet and have it automatically update when there are changes or additions to the first sheet. I have a couple issues making this happen - the main one is that the data in my first sheet is custom sorted by color, but I want the new sheet to take the data from column B on sheet 1 and sort it alphabetically, and take the other columns and match them correspondingly to the correct values they match to from column B on the first sheet. Secondly, for blank cells, I want it to leave them blank instead of inputting zero, or any dates. I don't know if this is all even possible, or if I should just remove my custom filters from sheet 1 by cell color and just link it that way. I've spent hours trying to find formulas that work. Please see attached images for reference on what I've tried, and for more clarification as to exactly what I'm requesting. Sorry for the copious redacting, I wanted to be safe rather than sorry with identifiable info regarding this. Any help would be greatly appreciated.
Word - Same Line Page Breaks Visibly Change Formatting
Within the last week or so, Word suddenly has started changing the formatting of visible text when a page break is used on the same line. How can this be corrected? (To be clear, yes, a page break could moved to the next line or deleted if there is not room for the extra line, but this impacts dozens of templates I have been using for years and I just want to set the formatting back to how it has worked in the past, where a page break inserted at the end of a line with centered text did not change the formatting of the visible text in said line.) Example 1 below is how it always used to appear whether the page break was on the same line as the centered title text or not. Example 2 below is how it looks now when the page break is on the same line.
Link doesn't work
We have recently started experiencing an issue when opening links within Excel on Azure Virtual Desktop. Our AVD environment is currently running the Version 2601, but the behaviour is very inconsistent, only a couple of users are affected, and the issue appears completely random. Interestingly, it works fine for most users both inside AVD and outside AVD. Affected users are receiving the following error message (screenshot below). So far, I have tried the following without success: Clearing the Excel cache Deleting the Excel container from the registry: HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel Is anyone else experiencing the same issue, or aware of a fix/workaround? Any help would be greatly appreciated.
Events
Learn more about the capabilities of Agent 365 in this live 'Ask Microsoft Anything' with product and engineering team experts! Get your questions answered about capabilities for agent observability,...
Online
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
- Microsoft Most Valuable Professionals (MVPs) are the heartbeat of the Microsoft ecosystem—and at Microsoft 365 Community Conference 2026, your impact takes center stage. Imagine connecting face-to-...Mar 06, 2026
- Edit images directly in PowerPoint to enhance, refine, and perfect visuals without leaving your deck.Mar 06, 2026
