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
How to use multiple monitors in Windows - Microsoft Support
Tip: If you're using a wireless display adapter, connect to an HDMI port on newer TVs, then wirelessly connect your PC to it.After connecting your wireless display adapter to your TV, go to your Windows 11 PC, press Windows logo key + K to open Cast, then select your wireless display adapter.
Personalize your PC - Microsoft Support
Windows themes A theme is a combination of pictures, colors, and sounds that help you personalize your PC. The latest versions of Windows include many exciting desktop personalization features, such as panoramic themes that extend across two side-by-side monitors, and the ability to have your theme appear on your Start screen.
Create an Xbox profile | Xbox Support
If you already have a Microsoft account that you use to sign in to other Microsoft services (such as Windows, Outlook, OneDrive, Office, MSN, and Skype), use that account to create your Xbox account as well.
Turn off Defender antivirus protection in Windows Security
Switch Real-time protection to Off.Note that scheduled scans will continue to run. However, files that are downloaded or installed will not be scanned until the next scheduled scan.
Windows 11, version 23H2 update history - Microsoft Support
Windows 11, version 22H2; July 25, 2024—KB5040527 (OS Builds 22621.3958 and 22631.3958) Preview; July 9, 2024—KB5040442 (OS Builds 22621.3880 and 22631.3880)
Add flair to your email with emojis - Microsoft Support
In the Windows emoji picker, you can either scroll through the list, use the category icons at the top or bottom of the emoji picker, or type a keyword to search for the emoji you want.
Applies To:
Outlook for Microsoft 365, Outlook 2021, Outlook 2019, Outlook 2016
Use System Restore - Microsoft Support
Use System restore to make restore points when you install a new app, driver, or Windows update, and when you create a restore point manually.
Change your screen resolution in Windows - Microsoft Support
In the Display resolution row, select the list and choose an option.It's usually best to stick with the one that's marked (Recommended). Monitors can support resolutions that are lower than their native resolutions, but text won't look as sharp and the display might be small, centered on the screen, edged with black, or stretched.
How to change your Microsoft account password | Xbox Support
Important Because changing your Microsoft account password is slightly different than resetting a forgotten password, this page does not cover the steps to reset your account password.