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
Change mouse settings - Microsoft Support
To speed up the process of selecting a choice when a dialog box appears, under Snap To, select the Automatically move pointer to the default button in a dialog box check box.(Not all programs support this setting. In some programs, you'll need to move the mouse pointer to the button you want to click.)
Remove specific prevalent malware with Windows Malicious Software ...
Microsoft generally releases the MSRT on a monthly cadence as part of Windows Update or as a standalone tool. (For exceptions, see Skipped releases.)Use this tool to find and remove specific prevalent threats and reverse the changes that they made (see Covered malware families).For comprehensive malware detection and removal, consider using Windows Defender Offline or Microsoft Safety Scanner.
Change the email address or phone number for your Microsoft account
Warning When removing an email alias that’s connected to a Microsoft domain (such as @Outlook.com, @Live.com, or @Hotmail.com), that email is completely deleted from our systems and can’t be used to send or receive emails. It won’t be available for use again as an alias on another account. Microsoft doesn’t recycle email addresses, so it can’t be reclaimed at a future time.
Use Magnifier to make things on the screen easier to see
If you are using a mouse, select Start > Settings > Accessibility > Magnifier.Select View, and then open the Keep the mouse pointer or Keep the text cursor drop-down menu, and select how Magnifier behaves when the mouse pointer or text cursor move around the screen. This is something you should experiment with to see which combination works best for you.
Help in File Explorer - Microsoft Support
To open File Explorer, select Windows logo key + E or go to Start and type File Explorer in the search box. Select File Explorer in the results.. Top topics. Here are answers to a few common questions about File Explorer: How can I open File Explorer and find the Windows 11 features?
Bildschirmspiegelung und Projektion auf Ihren PC oder ihre drahtlose ...
Wählen Sie auf dem PC, von dem Sie projizieren möchten, Windows-Logo-Taste + K aus, und wählen Sie den PC aus, mit dem Sie eine Verbindung herstellen möchten. Alternativ können Sie in der Windows Search-Leiste nach Cast suchen und dann Verbindung mit einer drahtlosen Anzeige herstellen auswählen. Wählen Sie auf der Seite Anzeigeeinstellungen unter Mehrere Anzeigen die Option Mit einer ...
Check your device performance and health in Windows Security
The Health report starts off by showing you the last time a Device Health scan was run. The time displayed should be basically the current time, as Windows Security tries to run a Device Health scan when you open the Device performance & health page.. Beyond the time of last scan you'll see the status of the key areas that Device Health monitors:
How to troubleshoot Windows Installer errors - Microsoft Support
Resolution. To fix this problem automatically, run the "Fix problems that programs cannot be installed or uninstalled" troubleshooter to repair issues that block program installation or removal because of corrupted registry keys.Important To perform many of the methods and steps in this article, you must be logged on to your computer as an administrator.
April 9, 2024—KB5036892 (OS Builds 19044.4291 and 19045.4291)
Windows 10, version 22H2 update history; July 23, 2024—KB5040525 (OS Build 19045.4717) Preview; July 9, 2024—KB5040427 (OS Builds 19044.4651 and 19045.4651)