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
Recovery options in Windows - Microsoft Support
Info for Windows Insiders. If you’re an Insider and the current preview build isn’t working for you, select Start > Settings > System > Recovery .Next to Go back , select Go back.This won’t remove your personal files, but it’ll remove recently installed apps and drivers, and change settings back to their defaults.
Save or forget passwords in Microsoft Edge - Microsoft Support
Note: The Automatically save passwords setting has been retired with Microsoft Edge version 124 and later. Instead, Edge will offer to save your passwords each time you enter new credentials in the Edge browser. All your previously autosaved passwords will continue to be available for a seamless login.
Record a meeting in Microsoft Teams - Microsoft Support
Notes: Meeting recordings won't capture whiteboards, annotations, shared notes or content shared in the stage view by apps, and also won't include videos or animations embedded in PowerPoint Live presentations.
Applies To: Microsoft Teams
Signing in with a passkey - Microsoft Support
What are passkeys? Passkeys are a replacement for your password. With passkeys, you can sign into your Microsoft personal account, or your work/school account using your face, fingerprint, or PIN.
Applies To: Microsoft account dashboard
Complete guide to Narrator - Microsoft Support
Text recognition in images is enhanced, including handwriting recognition, and overall image descriptions are better. To experience the improved experience, navigate to any image and, while the image is in focus, execute the keyboard combination "Narrator key+CTRL+d “. . An active internet connection is necessary for this feature, and Narrator settings must have the option to obtain Image ...
Common problems with two-step verification for a work or school account ...
Ensure these modes create an alert that is visible on your device. Make sure you have a device signal and Internet connection. Make sure your phone calls and text messages are getting through to your mobile device.
KB5003791: Update to Windows 10, version 21H2 by using an enablement ...
Summary. Windows 10, versions 2004, 20H2, 21H1, and 21H2 share a common core operating system with an identical set of system files. Therefore, the new features in Windows 10, version 21H2 are included in the latest monthly quality update for Windows 10, version 2004, 20H2, and 21H1, but are in an inactive and dormant state.
Browse InPrivate in Microsoft Edge - Microsoft Support
The new Microsoft Edge will delete your browsing history, cookies, and site data, as well as passwords, addresses, and form data when you close all InPrivate windows. You can open an InPrivate window in different ways: Select and hold (right-click) the Microsoft Edge logo in the taskbar and select New InPrivate window.
Applies To: Microsoft account dashboard
Getting the most out of your PC backup - Microsoft Support
When you back up your files, apps, and settings in the cloud using your Microsoft account, you get 5 GB of free cloud storage and other benefits that protect your files with the latest security and make everyday tasks easier.