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 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Find and transfer Outlook data files from one computer to another
Email, calendar, contact, and task information for POP accounts. If you have a POP account, all of your information is already stored in a Personal Folders (.pst) file.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
Get started with Python in Excel - Microsoft Support
Python in Excel uses the custom Python function xl() to interface between Excel and Python. The xl() function accepts Excel objects like ranges, tables, queries, and names.. You can also directly type references into a Python cell with the xl() function. For example, to reference cell A1 use xl("A1") and for the range B1:C4 use xl("B1:C4").For a table with headers named MyTable, use xl ...
Applies To: Excel for Microsoft 365
Change an email signature - Microsoft Support
Whether it’s a new job title (congratulations!) or a phone number change, make sure you keep your email message signature up-to-date. If you're using new Outlook, for more information about email signatures, or if you haven’t created one yet, see Add a signature to messages.. Select File > Options > Mail > Signatures.
Applies To: Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Play, share, and download a meeting recording in Microsoft Teams
Depending on the length of the video, generating closed captions can take several minutes. Once generated, you can watch the video in Stream and have captions displayed at the bottom of the screen.. When the caption have been created, the Generate button turns to Translate.Select Translate to change the spoken or screen language to automatically translate the captions.
Applies To: Microsoft Teams
Microsoft Edge でパスワードを保存または削除する
Microsoft Edge を使用すると、Web を参照するときにパスワードを簡単に保存できます。 デスクトップまたはモバイル デバイスの Edge ブラウザーで新しいパスワードを入力すると、ユーザー名とパスワードを記憶するかどうかを Microsoft Edge から確認するメッセージが表示されます。
Make a checklist in Word - Microsoft Support
Add an interactive checklist. Checklist is a feature that allows you to insert an interactive list in Word for Web. You can check and uncheck the checklist and keep track of the tasks that you are performing.
Applies To: Word for Microsoft 365, Word for the web, Word 2021, Word 2019, Word 2016
Subscriptions & billing | Xbox Support
Get more information about managing your Xbox subscriptions, issues with billing, and more.
Open and use a shared mailbox in Outlook Web App
Type the email address of the other mailbox that you want to open and then select Open.Or, start typing and then select Search contacts and directory to find the mailbox you want to open. Select the shared mailbox you want to open, and then select Open.Another Outlook Web App session opens in a separate window, allowing access to the other mailbox.
Applies To: Outlook Web App
Fix problems that block programs from being installed or removed
The Program Install and Uninstall troubleshooter helps you automatically repair issues when you're blocked from installing or removing programs.