FILTER function - Microsoft Support
FILTER function. Excel for Microsoft 365 Excel for Microsoft 365 for Mac Excel for the web More... The FILTER function allows you to filter a range of data based on criteria you define. 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 ...
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
Use Excel built-in functions to find data in a table or a range of ...
This article uses the following terms to describe the Excel built-in functions: The value to be found in the first column of Table_Array. The range of cells that contains possible lookup values. The column number in Table_Array the matching value should be returned for. A range that contains only one row or column.
Unlicensed Product and activation errors in Office
Tip: In Windows 7, you can synchronize your computer clock with an Internet time server to keep the computer clock up to date.To do this, select the date or time in the bottom right-hand corner of your screen, and then select Change date and time settings.Select the Internet Time tab, select Change settings, select Synchronize with an Internet time server, and then select Update now.
Applies To:
Excel for Microsoft 365, Word for Microsoft 365, Outlook for Microsoft 365, PowerPoint for Microsoft 365, Access for Microsoft 365, OneNote for Microsoft 365, Project Online Desktop Client, Publisher for Microsoft 365, Visio Plan 2, Excel 2021, Word 2021, Outlook 2021, PowerPoint 2021, Access 2021, Project Professional 2021, Project Standard 2021, Publisher 2021, Visio Professional 2021, Visio Standard 2021, Office 2021, OneNote 2021, Excel 2019, Word 2019, Outlook 2019, PowerPoint 2019, Access 2019, Project Professional 2019, Project Standard 2019, Publisher 2019, Visio Professional 2019, Visio Standard 2019, Office 2019, Excel 2016, Word 2016, Outlook 2016, PowerPoint 2016, Access 2016, OneNote 2016, Project Professional 2016, Project Standard 2016, Publisher 2016, Visio Professional 2016, Visio Standard 2016, Office 2016, Microsoft 365 for home, Office for business, Office 365 Small Business, Microsoft 365 admin, InfoPath 2013
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.
View your PC info - Microsoft Support
Type about in the search box on your taskbar, and then select About your PC. View your PC info. View your PC info.
Give your PC a Fresh Start - Microsoft Support
To reset your PC, go to Start > Settings > System > Recovery . Next to Reset this PC , select Reset PC. Then, select Keep my files, choose cloud or local, change your settings, and set Restore preinstalled apps? to No . Open Recovery settings. Note: If you don't see the option to Restore preinstalled apps, it means your PC doesn't have ...
Blocked attachments in Outlook - Microsoft Support
Rename the file. You can rename the file (or request that the sender rename the file) to use an extension that Outlook doesn't block. For example, you can rename file.exe to file.docx. Once the renamed file is sent (or received), save it and rename it with the original extension using the following steps. Locate the attachment in the email message.
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
Known issue Microsoft Defender for Endpoint on macOs
Users of Microsoft Defender in the Beta channel might experience an issue that causes the macOS installer process to freeze. The issue affects Defender version 101.23082.0018 on macOS only. NOTE: This version of Defender was not released to the Preview or Current (production) channels. Only users in the Beta channel are affected.
Fix problems with your PC by using Windows Update
To fix problems using Windows Update: Select Start > Settings > System > Recovery > Fix problems using Windows Update. After you select the Reinstall now option, choose if you want to allow the PC to automatically restart 15 minutes after the installation completes. Select OK when you’re ready to start the installation.
How to uninstall a Windows update - Microsoft Support
If you've recently installed a Windows update and you are having a problem, here's how to uninstall the update to try to resolve the issue: Select Start > Settings > Windows Update > Update history > Uninstall updates . View update history. On the list that appears, locate the update you want to remove, and then select Uninstall next to it.