UNIQUE function - Microsoft Support
Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.
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 for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Set your work hours and location in Outlook - Microsoft Support
Microsoft 365 helps you manage and share your work schedule. New features allow you to specify more details about your work schedule: from where you’re working (remotely or in office) and whether you work different hours on different days. In addition, you’ll be able to schedule meetings with others based on their work location and view work location on people’s contact cards.
Applies To:
Outlook for Microsoft 365, Outlook 2024, Outlook 2021, Outlook 2019, Outlook 2016, Outlook on the web, Microsoft Teams, New Outlook for Windows
Cancel a Microsoft 365 subscription - Microsoft Support
Important: If, for example, you cancel a Microsoft 365 Basic, Personal, or Family subscription, your storage allowance will revert to 5GB of cloud storage, which includes your OneDrive and Outlook.com attachments, and 15GB of Outlook.com storage. If you cancel Microsoft 365 Family, all the people you shared your subscription with will also have their storage allowances reduced.
Compare two versions of a workbook by using Spreadsheet Compare
Differences are highlighted with a cell fill color or text font color, depending on the type of difference. For example, cells with "entered values" (non-formula cells) are formatted with a green fill color in the side-by-side grid, and with a green font in the pane results list.
Applies To:
Spreadsheet Compare 2013, Spreadsheet Compare 2016, Spreadsheet Compare 2019, Spreadsheet Compare 2021
Go passwordless with your Microsoft account
Enhance the security of your Windows device by leveraging Windows Hello. If you’ve already set up Windows Hello, you can eliminate the password sign-in method for an even more secure experience.
Install, manage, or uninstall apps in Microsoft Edge
Alternatively, you can install any website by going to the top corner of the browser and select Settings and more … > Apps > Install this site as an app. Once the application is installed, it will appear under edge://apps.
Applies To:
Microsoft Edge
Unlink and re-link OneDrive - Microsoft Support
Note: No data will be lost by unlinking and re-linking your OneDrive, your local folders are just disconnected from the cloud for a short while.Any changes made while you're unlinked will be synced once re-linking is complete.
Applies To:
OneDrive for Business 24, OneDrive for Business, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
DATEDIF function - Microsoft Support
Argument. Description. start_date . Required. A date that represents the first, or starting date of a given period. Dates may be entered as text strings within quotation marks (for example, "2001/1/30"), as serial numbers (for example, 36921, which represents January 30, 2001, if you're using the 1900 date system), or as the results of other formulas or functions (for example, DATEVALUE("2001 ...
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, Windows SharePoint Services 3.0
Microsoft 365 and Office resources - Microsoft Support
Explore subscription benefits, browse training courses, learn how to secure your device, and more.
Applies To:
Office 2024, Office 2021, Office 2019, Office 2016
Keyboard shortcuts in Excel - Microsoft Support
To do this. Press. Move to the Tell me or Search field on the ribbon and type a search term for assistance or Help content.. Alt+Q, then enter the search term. Open the File menu.. Alt+F. Open the Home tab and format text and numbers and use the Find tool.. Alt+H. Open the Insert tab and insert PivotTables, charts, add-ins, Sparklines, pictures, shapes, headers, or text boxes.
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, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones, Excel Mobile