Recent Discussions
Filter Function or any Logic
Dear Experts, I have a data like below , Column "H" has rnti's , Column "F" has sfn which can range from 0~1023( and once 1023 it shall start again from 0) slots that can range from 0~9, each sfn(say 252) has slots(0~9), Column "J" is Sn( Sequence number) , In Output , I want like this, example for the rnti 384, column "B" = count of spdu-1 for the rnti=384, and so on How the spdu-1 counted? (spdu-x's are counted per rnti & per-rlcCtrlAckSn_ ,) as below for example for rnti==384, Thanks in Advance, I posted this earlier also , not sure why post got deleted somehow
Potential Bug: SEQUENCE Function Misbehaves with Dynamic start Parameter from BYROW/LAMBDA
Dear Microsoft Excel Team, I’m encountering unexpected behavior when using SEQUENCE inside a BYROW/LAMBDA construction, specifically when the start parameter of SEQUENCE is derived from the lambda variable. Environment: Microsoft® Excel® 适用于 Microsoft 365MSO (版本 2510 Build 16.0.19328.20190) 64 位 Steps to Reproduce: The following formula works correctly and returns two identical rows: =BYROW({4;3}, LAMBDA(p, LET(n, 4, TEXTJOIN(" ",, SEQUENCE(5,,1,n))) )) Output: 1 5 9 13 17 1 5 9 13 17 However, when replacing the literal 1 with a variable derived from p (even after forcing numeric conversion), the output becomes incorrect: =BYROW({4;3}, LAMBDA(p, LET(n, 4, k, p + 0, TEXTJOIN(" ",, SEQUENCE(5,,k,n))) )) Actual Output: 4 3 Expected Output: 4 8 12 16 20 3 7 11 15 19 This suggests that SEQUENCE is not correctly interpreting k (which should be 4 and 3) as the starting value. Instead, it appears to output the value of k itself as a scalar string. Based on community reports, this may be related to the fact that BYROW always passes each row as an array—even for single-cell rows—and the value is not automatically unwrapped to a true scalar . While p + 0 should coerce to a number, SEQUENCE’s start parameter may not be handling 1×1 arrays correctly. Could you please clarify if this is intended behavior or a bug? If it’s by design, is there a reliable workaround to extract a true scalar from the LAMBDA parameter for use in SEQUENCE? Best regards, MapalerLock down Form creation for staff
Hi, I want some staff being able to create forms/surveys etc. https://forms.microsoft.com/ I want to ensure that the rest of the staff can consume the forms ,i.e. fill in, but not create new or "Collaborate or Duplicate". What is the best way for me to do this? Thank you for your time, Ollie
Account name, email address relationship and changing these
Hello, I am trying to help an elderly friend who has been left behind by technology and seemingly endless changes to Microsoft and other products. I am not exactly young (72) and between the 2 of us we cannot understand what we need to do. He has problems because the email provider used for his accounts (ntlworld.com) does not work any more AND he has forgotten / lost his MS account passwords which makes changing / correcting stuff challenging as we have found out. Not a good place to start but that is what we have. Firstly, can someone explain the "structure" of a Microsoft (MS) account in terms of these bits of data: Account name / title / whatever (e.g. John Smith) Account email address (e.g. email address removed for privacy reasons) Secondary (back up) email address (e.g. email address removed for privacy reasons) Does the account name need to be the primary email or is the account user e.g. is John Smith simply "data" about the account whose main ID is mailto:email address removed for privacy reasons What is linked to what and in what way? I ask this because I log in to my MS account using an email address and password and I don't understand if this is what everyone does or is it one of several account IDs. We also had fun trying to add secondary email addresses and getting them verified - trying to verify them, he received an email from MS (to the newly added 2nd email address) telling him to click the link in the email. When he did this a pop up appeared telling him that he was logged into the wrong account. It is a fairly meaningless message (sadly like many MS messages to users). So, a good start would be to get an understanding from someone (in plain English and not tech speak) so I (and he) can clearly understand what we have got and then work out a way to get to our eventual target. It should keep us amused over the winter!! Thank you in advance, F
Excel Formula Help!!
Hi, I'm looking to write a formula that can help my class with some basic budgeting skills. They basic layout is each column is it's own category with an allotted amount for each: ex column A is for groceries with a total of $90 to be spent in that pay period. Each column has a sum cell (B31) so students can see how much they have spent and right beneath it in the same column, there is a cell that lets them know how much of the allotted amount for that category they have left. I was wondering if there was a way to modify it so that in the cell (ex: B 32) that currently displays the remaining balance for that category if gone over budget (as in the number is now in the negatives) could be stopped at zero and the negative balance could be subtracted equally from other categories? To visualize what I've done so far: The formulas for row 13 are =sum(ColumnLetter2:CL12) Row 14 is where it differs by each cell; A: =minus(90,A13) B: =minus(100,B13) C:=minus(120,C13) D:=minus(50,D13) E:=minus(40,E13) F:=minus(60,F13) G:=minus(90,G13) H:=minus(75,H13) I:=minus(50,I13) The main question comes once students start filling in the spreadsheet. With the hypothetical fill of : How can I create a formula in row 14 that continues to show remaining balance, but only when a column reaches negative (like the beauty) takes the negative value (15 dollars) and equally subtracts (1.875) it from the remaining columns that can have that amount subtracted without going negative themselves? I wouldn't want any of the overspent value of beauty to be taken from Misc. as there is only one dollar left and that is less than the evenly split amount (1.875). Is there a way to write such a formula into the formula for row 14 or would it need to occur in a different row? I'd love for my students to be able to see how to manage the occasional sometimes necessary overspending in one category to see how to adjust spending in others (hopefully it wouldn't be for beauty lol). I've thought about using If formulas, but am struggling on how to fit in all the criteria. I would appreciate any help in creating a formula!! Thank you so much!!!
Power Query - Large Data Set Question
Hello - I combined a handful of .xlsx files and there's about 5 million rows total. I'm trying to identify duplicate "project IDs" (the long strings below in rows 22-29), basically what this filter is showing is all of the project IDs that have 3, 4, 5, 6, etc. duplicates all the way through 14. That's exactly what I'm looking for, there's about 180k project IDs I was able to get. The problem is the project IDs that have 1 duplicate, which is the number 2 in this filter because I did a group by in power query by the project ID and it counts the number of matching rows it has, so 2 means it has 1 duplicate. When I filter on this it runs over the 1 million excel row limit, I was wondering if anybody had an idea of how I could get around this problem?
Title: Expose SHA-256 or SHA-1 for Mail Attachments in Microsoft Graph
Problem Email attachments in Graph don’t include a content hash. To identify or match attachments, developers have to download the entire file first. That wastes bandwidth and time and increases exposure. OneDrive/SharePoint already return hashes, but mail does not, so experiences are inconsistent. Request Add a server-provided content hash to every mail attachment. Prefer SHA-256. If that’s not feasible initially, expose SHA-1 as a minimum to align with existing Drive item hashes. Benefits Faster and cheaper: avoid downloading large files just to tell if you already have them. Deduplication: detect repeated attachments across threads and mailboxes. Security operations: correlate attachments with threat intel by hash and triage suspicious emails without fetching payloads. eDiscovery and compliance: confidently match the same document across mail and files. Consistency: a predictable, uniform approach across Mail and OneDrive/SharePoint.Cleaning up data with Macros
Hello everyone! I am cleaning up a worksheet that I use frequently to track weekly expenses and spending. I just discovered Macros and I want to use them to clean up my worksheet. Using Macros, how can I create a button that clears entries that are 3 (or more) months old?
Excel VBA Updates not functioning as intended
Afternoon all, Attaching a deidentified copy of a metrics file. I built a macro which does two main things once a user clicks the "Update Sheet" icon in the ribbon. asks for a date in the format "MM/DD/YYYY" Compares the date entered to the format requirement, & if appropriately formatted, proceeds to make updates to the two tabs of the sheet. As a safeguard, the macro also checks if the entered date is found in Data tab, row 2. If yes, a msgbox should notify the user of the existence of the date, and exit sub. However with a user entered date which already exists, my macro continues on to make updates of inserting a new column C on Data tab, as well as inserting a new row 2 on Slide Prep tab. I've checked all the formatting and can't find why it doesn't find a match. Also, on the Slide Prep tab it when inserting new formulas, the formulas added to I2:M2 all present as text, and do not auto calculate - again, nothing i can locate as the root source of the surprise. I've attached a copy with the incorrect duplication of 10/01/2025 as two columns on Data tab, and as two rows on Slide Prep tab. VBA Code below: Option Explicit Sub CMLUpdateV2() Dim Wb As Workbook Dim Ws As Worksheet Dim ICount As Integer Dim iRow As Integer Dim Row As Object Dim RowAddress As String Dim RowRange As String Dim NM As String Dim DR As Range 'Data Date Tab Date Row(2) Dim DC As Range 'Date Found Range Dim strDateInput As String Dim blnValidDate As Boolean Application.ScreenUpdating = False For Each Wb In Application.Workbooks If Not (Wb Is Application.ThisWorkbook) Then Wb.Close End If Next blnValidDate = False 'Determine if input value is valid format, re-enter if not Do strDateInput = InputBox("Please Enter File Submission Month as MM/DD/YYYY:", "Date Entry") 'If strDateInput = "" Then ' MsgBox "No Date Entered, update cancelled.", vbInformation ' Exit Sub ' End If If IsDate(strDateInput) Then If Format(CDate(strDateInput), "MM/DD/YYYY") = strDateInput Then blnValidDate = True Else MsgBox "Invalid Date Format or No Date Entered. Please Re-Enter in MM/DD/YYYY format." blnValidDate = False End If Else MsgBox "Invalid Date Format or No Date Entered. Please Re-Enter in MM/DD/YYYY format." blnValidDate = False End If Loop Until blnValidDate NM = strDateInput 'Determine if valid input is already present on sheet Set DR = ThisWorkbook.Worksheets("Data").Range("2:2") Set DC = DR.Find(What:=NM, LookIn:=xlValues, LookAt:=xlWhole) If Not DC Is Nothing Then MsgBox "Date entered is already present. Please Review Date.", vbOKCancel Exit Sub Else 'Update Data Tab with new column and formula updates With ThisWorkbook.Worksheets("Data") .Columns("C:C").EntireColumn.Insert .Range("D:D").Copy .Range("C:C").PasteSpecial xlPasteAll .Range("C2").Value = NM .Range("C3:C6,C16:C19,C29:C32,C42:C45,C55:C58,C68:C71").ClearContents .Columns("O:O").Copy .Columns("O:O").PasteSpecial xlPasteValues End With 'Update Slide Prep Tab with New row and formula updates With ThisWorkbook.Worksheets("Slide Prep") .Rows("2:2").EntireRow.Insert .Range("A2").Value = NM .Range("A2").NumberFormat = "m/d/yyyy" .Range("B3:H3").Copy .Range("B2:H2").PasteSpecial xlPasteAll .Range("B2").Formula = "=XLOOKUP(B$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Range("C2").Formula = "=XLOOKUP(C$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Range("D2").Formula = "=XLOOKUP(D$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Range("E2").Formula = "=XLOOKUP(E$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Range("F2").Formula = "=XLOOKUP(F$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Range("G2").Formula = "=XLOOKUP(G$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Range("H2").Formula = "=XLOOKUP(H$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Range("I2").Formula = "=XLOOKUP(I$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Range("J2").Formula = "=XLOOKUP(J$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Range("K2").Formula = "=XLOOKUP(K$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Range("L2").Formula = "=XLOOKUP(L$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Range("M2").Formula = "=XLOOKUP(M$1,Data!$B$3:$B$80,XLOOKUP($A2,Data!$C$2:$Q$2,Data!$C$3:$Q$80))" .Rows("14:14").EntireRow.Copy .Rows("14:14").EntireRow.PasteSpecial xlPasteValues End With MsgBox "New File Date " & NM & " added and sheets updated. Proceed to Data Tab to record Enrollment Line Counts." End If End Sub
show a due date using data from multiple columns
I have a spreadsheet in excel, such as the Table 1 below. For the 5 Due Date columns, I have conditional formatting set up to format the cells. See Image 1 for a list of rules applied to all Due Date columns. I'd like for another table to populate, showing only columns, Laboratory ID, Description, and any column that is highlighted per the conditional formatting rules. For example, I'd like the return table to look something like Table 2. Table 1. populated in cells G9:N12 ID Description Due Date 1 Due Date 2 Due Date 3 Due Date 4 Due Date 5 Out of Service? 1234 Instrument 1 11/17/2025 N/A 1/31/2027 3/11/2026 11/17/2027 FALSE 1235 Instrument 2 1/14/2026 2/17/2026 3/31/2027 1/23/2026 12/29/2027 TRUE Table 2. Conditional formatting rules applied to cells I9:M12 This Week = White font color, Red fill This Month = Red font color, Light Red fill Next Month = Dark Yellow font color, yellow fill Table 2. If today is 11/10/2025, the table will display columns ID, Description, and only column show for due dates within This Week: ID Description Due Date 1 1234 Instrument 1 11/17/2025Excel interprets dates 12 and lowers as months
Hi If I in any cell, without any adjustment of cell formatting, excel will interpret 15/8 as 15-aug, as it should but 4/8 is interpreted as 8-apr... Is there any way to get excel to interpret this consistently correct, that is dd/mm = dd-mmm and not "IF dd=≤12 then dd is mmm and mm=dd" which is insane?
Le séparateur de milliers ne fonctionne pas dans Excel sur Mac
Dans les anciens fichiers Excel sur Mac, le séparateur de milliers ne fonctionne pas quand le format est "Feuille de calcul open XML strict (.xlsx)" alors qu'il fonctionne très bien avec le format "Classeur Excel (xlsx)". Mais dans "Enregistrer sous..." il n'est pas possible de changer de format. Merci de votre assistance !Worksheet tabs to include date from a cell
Hello , I have a worksheet with four tabs. Cell H1 in both tabs 1 and three contains a date. I would like to include that date in the tab name in the following format: for Tab 1 "AR - as of (the date in H1)" and for Tab 3 "AP - as of (the date in H1)". The dates in the tabs would update whenever the date in cell H1 is updated. I am using Microsoft 365 Apps for Enterprise, version 2510, Build 19328.20178. Thank you for your assistance.CANNOT OPEN THE SPECIFIED FILE with tel:-hyperlink
Hi, I have several "tel:" hyperlinks in a Excel sheet (xlsm). Yesterday, they sended the phone numbers to whatsapp. But today i become the errer:"CANNOT OPEN THE SPECIFIED FILE". I saved yesterday a xlsx file as xlsm, after the conversion, the links were still working. What goes wrong?IF ISBLANK and NOT
Hi all, I am banging my head against a brick wall trying to figure this out. Column C has a day in it. Cell X6 has a value in it which automatically updates every day. Column X has new values entered every day. The value in column AM for each row is calculated with a formula, so it will give the value of X6 if X in the same row is empty, or 0 if X in the same row has a value. =IF(ISBLANK(X324),X$6,0) will give me what I want if just looking at the cell in row X, but I also need to check if C324 is either Saturday or Sunday. =IF(AND(OR($C327="Saturday",$C327="Sunday"),(ISBLANK(X327))),0,X$6) will give me 0 if X327 is Blank and C327 is either Saturday OR Sunday, but will not give me 0 if X327 is Blank and C327 is not Saturday or Sunday. Is there a way to use the NOT function with the ISBLANK to say if X327 is Blank and C327 is not either Saturday or Sunday then it will return value X6, but is any of those statements are not true then it returns 0. Thanks in advance...
Excel Comments gone/unable to view
I've created a workbook to log information for my work. In this, I had a notes section that I could log all conversations I had when I had contacted a customer so when I hover over the purple indicator in the cell, it would show me the conversations/key notes i've had with customers. I have just opened my workbook today to try and view/add to these comments and all comments now have a red indicator in the cell and the text says the following ' [Threaded Comment] Your version of excel allows you to read this... How can I recover my notes as they are extremely important to my work.
Events
Learn, Connect, and Be Inspired at ESPC25
Join us in Dublin for ESPC25! One of Europe’s largest community conferences, ESPC25 is your opportunity to expand your Microsoft 365 Copilot, Collaborative...
In-Person
Recent Blogs
- We’ve repositioned the search dropdown to minimize overlap with your page, so you can browse while seeing more of your canvas.Nov 14, 2025
- 2 MIN READThank you for a fun decade of feedback, community, and engagement!Nov 13, 2025
