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
Troubleshoot Windows Media Player Errors - Microsoft Support
Repair or reset Windows Media Player: If Windows Media Player is not working properly, you can try to repair or reset it to its default settings.To do this, Select Start > Settings > Apps > Installed Apps.. Scroll down and click the three horizontal dots next to Windows Media Player and choose Advanced options, and click the Repair or Reset button. Note that resetting Windows Media Player will ...
Change or reset Internet Explorer settings - Microsoft Support
Change Internet Explorer settings. There are many changes you can make to customize your browsing experience in Internet Explorer. To view all settings and options, open Internet Explorer on the desktop, select Tools > Internet options.. Reset Internet Explorer settings
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 .
Install and use a scanner in Windows 10 - Microsoft Support
Select Add a printer or scanner.. Wait for it to find nearby scanners, then choose the one you want to use and select Add device.
Sign out or remove an account from Microsoft Teams
Sign out of Teams. While it's a good idea to remain signed in to continue receiving chats, notifications, incoming calls, and other activities, sometimes you might want to sign out of Teams to use another account or for other reasons.
Applies To: Microsoft Teams
Repair a corrupted workbook - Microsoft Support
Use a macro to extract data from a corrupted workbook If a chart is linked to the corrupted workbook, try using a macro to extract the source data of the chart.. Copy the following macro code and paste it in a module sheet: Sub GetChartValues() Dim NumberOfRows As Integer
Applies To: Excel for Microsoft 365, Excel 2021, Excel 2019, Excel 2016
Create a new folder - Microsoft Support
For Windows 8 or Windows 8.1, swipe in from the right edge of the screen, and tap Search. If you're using a mouse, point to the upper-right corner of the screen, move the mouse pointer down, and click Search.Type File Explorer in the search box, and then tap or click File Explorer.
Use Internet Explorer in Windows 10 - Microsoft Support
Internet Explorer 11 support ended on June 15, 2022. We recommend you use Microsoft Edge for a faster, more secure and more modern web browsing experience.
Control your Dynamic Lighting devices in Windows
Notes: Some users won’t see the notification for the first hour after a Windows Update due to their notification settings. (To check this, select Start gt; Settings > System > Notifications > Turn on do not disturb automatically, and see if For the first hour after a Windows feature update is checked.) To change Dynamic Lighting settings before seeing the notification, follow the steps above.