Count unique values among duplicates - Microsoft Support
You can use the Advanced Filter dialog box to extract the unique values from a column of data and paste them to a new location. Then you can use the ROWS function to count the number of items in the new range.. Select the range of cells, or make sure the active cell is in a table. Make sure the range of cells has a column heading.
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
When trying to install updates from Windows Update you might receive ...
When trying to install updates from Windows Update you might receive "Updates Failed. There were problems installing some updates, but we'll try again later" with Errors: 0x80073701, 0x800f0988
AutoArchive settings explained - Microsoft Support
Item type. When the aging period starts. E-mail message. The received date/time or when you last changed and saved the message, whichever is later. Marking a message as read or unread is an example of a message change.
Applies To: Outlook for Microsoft 365, Outlook 2024, Outlook 2021, Outlook 2019, Outlook 2016, Outlook 2013
Error message: “Security Center service cannot be started”
If you continue to try, you still can't turn on the Security Center. Resolution. To resolve this problem, make sure that the Security Center service is configured correctly, and then start the Security Center service.
See your Google Calendar in Outlook - Microsoft Support
By importing a snapshot of your Google calendar into Outlook, you can see it alongside other calendars in the Outlook Calendar View. To keep the imported calendar up-to-date, subscribe to the Google Calendar in Outlook.
Applies To: Outlook for Microsoft 365, Outlook 2024, Outlook 2021, Outlook 2019, Outlook 2016, New Outlook for Windows
July 9, 2024—KB5040442 (OS Builds 22621.3880 and 22631.3880)
Windows 11, version 21H2; October 8, 2024—KB5044280 (OS Build 22000.3260) September 10, 2024—KB5043067 (OS Build 22000.3197) August 13, 2024—KB5041592 (OS Build 22000.3147)
MATCH function - Microsoft Support
Syntax. MATCH(lookup_value, lookup_array, [match_type]) The MATCH function syntax has the following arguments: lookup_value Required.The value that you want to match in lookup_array.For example, when you look up someone's number in a telephone book, you are using the person's name as the lookup value, but the telephone number is the value you want.
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 Hello common issues and troubleshooting tips - Microsoft Support
Windows Hello enables a sign in experience using facial or fingerprint recognition, or a PIN. While it offers a convenient and secure way to access your device, you might sometimes encounter sign in issues.
Use the Project or Roadmap app in Teams - Microsoft Support
Add a Project or Roadmap tab to a Teams channel. When you add a tab using the Project or Roadmap app, you can either add an existing project or roadmap, or create a new one.
Create and update an index - Microsoft Support
An index lists the terms and topics that are discussed in a document, along with the pages that they appear on. To create an index, you mark the index entries by providing the name of the main entry and the cross-reference in your document, and then you build the index.
Applies To: Word for Microsoft 365, Word 2024, Word 2021, Word 2019, Word 2016