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.

Note: If you have a current version of Microsoft 365, then you can input the formula in the top-left-cell of the output range, then press ENTER to confirm the formula as a dynamic array formula. Otherwise, the formula must be entered as a legacy array formula by first selecting the output range, input the formula in the top-left-cell of the output range, then press CTRL+SHIFT+ENTER to confirm it.

Credential Manager lets you view and delete your saved credentials for signing in to websites, connected applications, and networks. To open Credential Manager, type credential manager in the search box on the taskbar and select Credential Manager Control panel.

Try using another Surface power supply or USB-C PD charger: If you have another Surface power supply available, try using that to charge your Surface.If your Surface has a USB-C port, try using a USB-C PD charger instead. If those work or if you don't have another Surface power supply or USB-C PD charger, start a service order for your power supply.

To resize the image, select the image to see drag handles appear around the image. Move the drag handles to resize the image as necessary. Select the Picture Format tab on the ribbon, then use the options on it to format your image. For example, you can apply a style or a border to the image.

TCP/IP defines how your PC communicates with other PCs. To make it easier to manage TCP/IP settings, we recommend using automated Dynamic Host Configuration Protocol (DHCP).

To add a picture, in the box you want to add it to, click the picture icon , select the picture you want to display in the chart, and then click Insert.

Choose number of pages to print per sheet: Printing multiple pages on a single sheet of paper is a useful technique to save paper, reduce printing costs, and create compact versions of your documents. The number of pages that can be printed on a single sheet depends on the capabilities of your printer and the printing options you choose (Example: 1, 2, 4, 6, 9 or 16 pages per sheet).

The following communication site shows a footer that's been added. Labels and links appear on the right side of the footer. When you add labels and links to your footer, they follow the Edit link and appear to the right.. On your site, select Edit on the right side of the footer (Edit appears on your footer after you've turned the footer control on).

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 ...