Guidelines and examples of array formulas - Microsoft Support
An array formula (one that spans multiple cells) can do calculations on rows and columns of cells where you might otherwise need to use several formulas. For example, you can count the number of characters that are contained in a range of cells, sum only numbers that meet certain conditions (such as the lowest values in a range or numbers that fall between an upper and lower boundary), and sum ...
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016, Excel for iPad, Excel for iPhone
Create an ISO file for Windows 10 - Microsoft Support
Unlike in previous versions of Windows, you’ll need to use the media creation tool to create an ISO file to install Windows 10. Make sure you have a license to install Windows 10, and then follow these steps:
Repair a corrupted workbook - Microsoft Support
Use a macro to extract data from a corrupted workbook If a chart is linked to the corrupted workbook, try using a macro to extract the source data of the chart.. Copy the following macro code and paste it in a module sheet: Sub GetChartValues() Dim NumberOfRows As Integer
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
My microphone isn't working in Microsoft Teams
Use your phone's audio. If your mic doesn’t work after trying the solutions above and you see one of the messages below, select Call me back to use your phone’s mic.. Enter your phone number and select Call me to receive a call from Teams that will connect you to your meeting. Your audio will come from your phone, but other content sharing will still take place on your desktop.
Applies To: Microsoft Teams
What to do if Microsoft Edge isn't working - Microsoft Support
If you can't open Microsoft Edge, or if it opens briefly and then closes, or if you’re unable to open specific webpages, here are some things you can try. Close other tabs, extensions, and apps. Your computer may have run out of memory and can't load the site while also running your apps, extensions, and programs.
I can't sign in to my Microsoft account - Microsoft Support
If you can't sign into your Microsoft account, most issues can be identified by our sign-in helper tool. The tool will ask you to enter the email address or mobile phone number you're trying to sign in with and check the details you provide. If we detect a problem with your account, we'll tell you what you need to do to solve the problem.
Applies To: Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Microsoft 365 for home, Outlook.com, GroupMe, Microsoft account dashboard, Microsoft Teams, Microsoft Teams personal, Microsoft To Do, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows, Outlook for Android, Outlook for iOS
Cancel a Microsoft 365 subscription - Microsoft Support
Notes: If you don't see an option to Cancel, but instead see a link that says Turn on recurring billing, this means your subscription is already set to expire on the date shown and you won't be automatically charged after this date. There's nothing further to do at this time, and you can continue to use the product until your Microsoft 365 subscription expires.
Find and replace text - Microsoft Support
lo@t finds "lot" and "loot." The beginning of a word < <(inter) finds "interesting" and "intercept" but not "splintered." The end of a word > (in)> finds "in" and "within," but not "interesting." Word for the web lets you find and replace basic text. You can match case or fine whole words only. For more varied options, open your document in ...
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
Troubleshoot problems signing in to Windows - Microsoft Support
If you continue to experience issues signing in with your original profile, disable Windows Defender services: Open the Services app by typing services in the search box on the task bar and selecting it from the list of results. Then, find the Windows Defender Advanced Threat Protection and Microsoft Defender Antivirus services, right-click each of them, select Properties , and change Startup ...
Installing Windows 11 on devices that don't meet minimum system ...
Installing Windows 11 on this PC is not recommended and may result in compatibility issues. If you proceed with installing Windows 11, your PC will no longer be supported and won't be entitled to receive updates. Damages to your PC due to lack of compatibility aren't covered under the manufacturer warranty. Before you install Windows 11