FILTER function - Microsoft Support
In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Common problems with two-step verification for a work or school account ...
This content can help you with your work or school account, which is the account provided to you by your organization (for example, dritan@contoso.com).
Manage website notifications in Microsoft Edge
Website notifications appear in the lower right corner of your screen and are also displayed in the Notification Center.When notifications are turned on for a website, they will still appear even if Microsoft Edge is closed.
Applies To:
Microsoft account dashboard
What is: Multifactor Authentication - Microsoft Support
How does multifactor authentication work? Let's say you're going to sign into your Microsoft account or work or school account, and you enter your username and password.If that's all you need then anybody who knows your username and password can sign in as you from anywhere in the world!
When trying to install updates from Windows Update you might receive ...
Right click or long press on Command Prompt and select Run as administrator.
End of support for Cortana - Microsoft Support
Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.
Import and export Outlook email, contacts, and calendar
Export contacts out of other email services. Export iCloud contacts. Export Gmail contacts – See Gmail help. Export Yahoo contacts – See Yahoo import and export help. Export Thunderbird contacts – See Mozilla support.
Applies To:
Outlook for Microsoft 365, Outlook for Microsoft 365 for Mac, Outlook 2021, Outlook 2021 for Mac, Outlook 2019, Outlook 2019 for Mac, Outlook 2016, Outlook 2013, Outlook.com
Check your device performance and health in Windows Security
The Health report starts off by showing you the last time a Device Health scan was run. The time displayed should be basically the current time, as Windows Security tries to run a Device Health scan when you open the Device performance & health page.. Beyond the time of last scan you'll see the status of the key areas that Device Health monitors:
Stay up to date with news and interests - Microsoft Support
The taskbar can display the temperature in Celsius (°C) or Fahrenheit (°F). To switch between these two units, select the weather icon on the taskbar, select the Edit location and unit icon on the weather card, select Celsius or Fahrenheit on the weather, and select Save. News and interests is supported in any taskbar orientation.
Join a meeting without an account in Microsoft Teams
Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.
Applies To:
Microsoft Teams