Recent Discussions
Problem creating an Excel formula
I am contacting you because I am having trouble creating a formula to count names in an Excel spreadsheet. I have created a schedule in Excel in which there is usually one name per cell. The calculation of these simple cells is fine. However, in cells where there are two names written ‘NAME F.1 / NAME F.2’, only the first name is counted. I do not know how to make the second name count as well. If necessary, I can send you the Excel file. Thank you for your help, as I do not know how else to solve this problem.
Restore Authentication App do not work
Hi. I have had a problem with the Microsoft Authenticator and have deleted it from my Android Smartphone. Then I have installed it again and tried a recovery. But that is not working. Then I would start from scratch and I have login with my Microsoft account and tried to activate "Cloud-Backup". But I get also an error message. What can I do. Thanks for your help. What I have tried: change WiFi to 5G deinstalled Authenticator App several times delete cache
Formula help
I am trying to write a formula to search my sheet for a particular name and when that name is found, I would like to average a particular column values. There are multiple names on this sheet, but I only want to average the set belonging to that person. I believe it is an IF, THEN formula, but I'm not sure how to average the values. Thank you!
MS Forms If function ignoring new data
Hello, I have a MS form setup collating information, I need to then reformat how this data comes in so it can be copied directly into another bit of software. Currently we have sheet 1 as below which is what gets filled in automatically and directly from the form I have created a new sheet in the same excel file which then pulls the data from sheet 1 and rearranges it into the order I need. This uses the function as below. =IF(Sheet1!J2="","",Sheet1!J2) This works fine when initially setup, but when new entries are submitted to the form and new rows of data appear in sheet 1, the If formula on sheet 2 then skips these new data rows. For example if a new submission to the form has been made, then on sheet 2 cell b5 will say =IF(Sheet1!J6="","",Sheet1!J6) which is correct but the cell in the one below will =IF(Sheet1!J8="","",Sheet1!J8) which has missed J7 Can anyone shed any light on this? Thank you
Excel formula
How to revise the formula to become a string to calculate if the review year is not 36 months but can be 36 months or 48 months. The Original formula in column C is EOMonth(b3,36) column A column B Column C Document name Release date Next review date in 3 year time (mth-yyyy) Document management 1/8/2025 Aug 2028
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!!!Security Score in Security Admin center not updating
Hi, I am looking at the security score in the security admin center and trying to apply some of the easy items to improve the score. For example, "Move messages that are detected as impersonated users by mailbox intelligence" which needs anti-phishing policy with the ‘Enable mailbox intelligence’ and ‘Enable intelligence for impersonation protection’ options enabled ensure that the ‘If mailbox Intelligence detects an impersonated user’ option set to ‘Quarantine the message’ Both of which are now done But my score will not change and the reccomendation doesn't go away. In this example i have only the default policy, Office365 AntiPhish Default, and it is applied to all users - 408 users (100%). Can anyone point me towards what I am doing wrong or missed? I have applied 7 of the listed recommended actions with no score change so far so i'd like to work it out before I get too far into it if i'm doing it wrong. Thanks for any advice Ian"Heading" and "Body" fonts are sometimes incorrectly displaying as Times New Roman
This appears to have started with the latest update that also made table formatting go nuts. Sometimes when we open a document from SharePoint, any text that has been formatted with "Body" or "Headings" will display as TNR. The font box will show "Times New Roman (Body)". The style definition will show "Body". Under the Design tab, the font scheme shows the Heading and Body as both being "Aptos" though, which is correct. Limited testing shows that closing Word down completely fixes it. But it's causing a lot of consternation!How to unprotect Excel sheet if forgot the password
I recently encountered a problem and hope to get your help. I set a protection password for an Excel file before. Now I want to modify some data, but I found that I forgot Excel password. I wonder if there is any way to remove the protection or unprotect Excel sheet password? If anyone knows a related solution or has had a similar experience, please share it, thank you very much! This file is very important to me, and there is a lot of work data in it. I have tried some methods found on the Internet, but none of them worked. It would be great if someone could provide some specific steps or recommend some tools.
Excel - Showing which Carrier is used based on selected quote cost
Hello, I am looking for a formula to show me which carrier is being used based on the selected quote column (J5). I need the formula to tell me which quote is selected (Columns M/O/Q for example) in J5 based on the selected quote amount in I5. Thank you in advance. VictorOutlook for Mac - Upload and Share is not working as access "Recipients of this message" is missing
New Outlook for Mac has since some versions back gotten the feature where the user can upload a file and share it to the recipients of the e-mail. The file will be per default be uploaded to DOWNLOAD folder in OneDrive. Now this is not working on Outlook for Mac as the whole access permission Recipients of this message" is missing. On Windows and Outlook on Web, this is available, but not for New Outlook for Mac. It seems that this feature is not yet fully developed on Outlook for Mac. Any others that see the same and can confirm?Another issue with Value transformation.
I've played for a couple of days with this, having tried a number of different solutions that worked for others. Cannot figure out how to make a text field convert to value. Here is my XLS. I am running MS Excel for Mac, V 16.102.1 (25101829), Office Home and Business 2021. Years of my "moderate skills" applied with Excel but stuck on this transformation. https://1drv.ms/x/c/4d0957bca9736d6d/Ec0gUD0-JTlCsi2fCIg8bpUBvkTobtXpP5Mt-piIA90uqg?e=AGOdCDCell references
Hi everyone! I want to know if there is a way to have a cell reference like this: In my workbook, I use a formula to add a range of cells (eg. "SUM(C1:C40)"). Suppose I constantly change the numbers (eg. sometimes I want to add C5:C37), so what I WOULD LIKE to do is, say, type the cell numbers in different cells (eg. in my example, I would type the number "5" in, say, Cell A1, and the number "37" in, say, Cell A2), and Excel should figure out that I want to add C5:C37. Something to the tune of, to have a cell reference like "SUM(C[a1{which, in my example, would be "5"}]:C[a2(which in my example, would be "37"}]. In other words, if I can just type the cell number which I want to refer to, and Excel will "pick up" on it, that would be great for me.How to Check Unexpected Sign-Ins Against Utility Accounts
Utility accounts exist in every Microsoft 365 tenant. These accounts are not intended for normal user activity and include accounts used for Exchange room and shared mailboxes and the break-glass or emergency accounts intended to allow administrators to sign-in if their usual accounts are blocked. This article shows how to use PowerShell and the Microsoft Graph to check sign-in events to ensure that the accounts aren't being accessed. https://practical365.com/check-utility-accounts-break-glass-signins/Custom Fields in Booking not showing in calendar invites
I have added Custom Fields in the Booking configuration, see below. But those are not showing in the calendar invite but only in a separate confirmation email. Would it be possible to see the answers for those customs fields in the calendar invite?
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’re thrilled to announce that Surveys Agent - your intelligent assistant for managing surveys end-to-end - is now generally available to all commercial customers worldwide with a Microsoft 365 Copi...Nov 10, 2025
- Thanksgiving and Christmas are fast approaching! Prepare for the holiday shopping and travel rush with Microsoft Copilot.Nov 06, 2025
