FREQUENCY function - Microsoft Support
The FREQUENCY function calculates how often values occur within a range of values, and then returns a vertical array of numbers. For example, use FREQUENCY to count the number of test scores that fall within ranges of scores. Because FREQUENCY returns an array, it must be entered as an array formula. data_array Required.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016
Fix OneDrive sync problems - Microsoft Support
Learn how to fix common OneDrive personal or OneDrive for Business sync problems.
Applies To:
OneDrive for Business 24, OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Office for business, Office 365 Small Business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows, SharePoint admin center, SharePoint in Microsoft 365 Small Business
Sync files with OneDrive in Windows - Microsoft Support
This article describes how to download the OneDrive sync app and sign in with your personal account, or work or school account, to get started syncing. If you use Microsoft 365 Apps for business, you can also sync files from your SharePoint sites.
Applies To:
OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint in Microsoft 365, Office for business, Microsoft 365 admin, Office 365 operated by 21Vianet, Office 365 operated by 21Vianet - Admin, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Windows, SharePoint admin center, SharePoint in Microsoft 365 Small Business, SharePoint operated by 21Vianet
Download files from OneDrive to your device - Microsoft Support
When using the OneDrive app, you can download a local copy of a file to your device. In the OneDrive app, open the folder that has the files you want to download. Make sure the folder contents appear in List view, not as thumbnails. Tap More next to the file you want to save and then tap Save.
Applies To:
OneDrive for Business, Office for business, Microsoft 365 admin, OneDrive (work or school), Microsoft Office, OneDrive (home or personal), OneDrive for Mac, OneDrive for Windows
VLOOKUP function - Microsoft Support
Learn how to use function VLOOKUP in Excel to find data in a table or range by row. Our step-by-step guide makes vlookup in excel easy and efficient.
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Office for business, Microsoft Office
Find lost or missing files in OneDrive - Microsoft Support
Get tips to help you find and restore lost or missing files, photos, or folders in OneDrive.
Applies To:
OneDrive for Business 24, OneDrive for Business, Office for business, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Update Your Security Processor (TPM) Firmware - Microsoft Support
Learn how to update your security processor or TPM firmware to protect Windows 10 and your device from attacks by malicious software.
Get started with Python in Excel - Microsoft Support
To begin using Python in Excel, select a cell and on the Formulas tab, select Insert Python. This tells Excel that you want to write a Python formula in the selected cell. Or use the function =PY in a cell to enable Python.
Applies To:
Excel for Microsoft 365
Find where your browser is saving downloads - Microsoft Support
To see where your browser is saving downloads, look in your browser's settings. For example, in the new Microsoft Edge , select Settings and more > Settings > Downloads . The file path for your downloaded files (for example, C:\Users\ [your name]\Downloads) is listed under Location. In Microsoft Edge Legacy , select Settings and more > Settings .
Fix duplicate IP address conflicts on a DHCP network
To resolve it, convert the network device with the static IP address to a DHCP client. Or, you can exclude the static IP address from the DHCP scope on the DHCP server. Turn off the DHCP client computer in conflict with the network device that has the static IP address.