This allows Excel to return an array of all names. Tips: If you format the range of names as an Excel table, then the formula will automatically update when you add or remove names. If you want to sort the list of names, you can add the SORT function: =SORT (UNIQUE (B2:B12&" "&A2:A12)) Example 4. This example compares two columns and returns ...

Select the Start button , and then select Control Panel. In the search box, type Performance Information and Tools, and then, in the list of results, select Performance Information and Tools. Select View and print detailed performance and system information. In the System section, you can see what type of operating system you're currently ...

Right-click between slides and select Add Section. An Untitled Section is added in the thumbnail pane, and the Rename Section dialog box opens. Type a name in the Section name box. Select Rename. To collapse a section, click the triangle next to the section name. The numeral by the section name shows the number of slides in that section.

DATE function. Returns the serial number of a particular date. DATEDIF function. Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. DATEVALUE function. Converts a date in the form of text to a serial number. DAY function.

The MANIFEST files (.manifest) and the MUM files (.mum) that are installed for each environment are listed separately in the "Additional file information for Windows 7 and for Windows Server 2008 R2" section. MUM and MANIFEST files, and the associated security catalog (.cat) files, are critical to maintaining the state of the updated component.

Wrap around a circle To create text that completely circles your shape, choose Circle under Follow Path, and then drag any of the sizing handles until your WordArt is the size and shape you want. Wrap around straight edges To wrap text around a shape that has straight edges, such as a rectangle, insert WordArt objects for each edge.

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.

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Right-click on the desktop you want to change. Select Choose background. Select the list in the Personalize your background section, then select Picture. Select a picture. Use multiple desktops in Windows to organize projects, or quickly switch between desktops before a meeting.

Select Personalization > Colors. Open Colors setting. In the list for Choose your mode, select Dark. Expand the Accent color section, then: To have Windows automatically pick an accent color, select Automatic. To manually select an accent color, select Manual, then select the list to the right and select a color under Recent colors or Windows ...