In the following example we used the formula =FILTER(A5:D20,C5:C20=H2,"") to return all records for Apple, as selected in cell H2, and if there are no apples, return an empty string ("").

Training: Watch and learn how to create a PowerPoint presentation, add/format text, and add pictures, shapes, and/or charts.

Learn how to join a Microsoft Teams meeting if you don't have an account. Join a Teams meeting as a guest in the Windows app or on the web.

For the website(s) you would like to allow scripting, enter the address within the Add this website to the zone text box and click Add. Note: If the address does not begin with "https:", you many need to uncheck "Require server verification (https:) for all sites in this zone".

You can use any phone number that can receive text messages; it doesn’t need to be associated with your account. We won't use or give out the phone number, and the code sent to it will expire after 10 minutes.

Warning: Turning off Memory Integrity on a Secured-core PC takes the device out of a Secured-core state.If you choose to continue using your device without addressing the driver problem, you might discover that the functionality the driver supports does not work any longer, which could have consequences ranging from negligible to severe.

To change appearance, select Appearance and make the changes you want to your default theme, zoom, toolbar, and fonts.

Make text bigger on your screen. If the text size feels too small when navigating through Windows, you can make the text bigger. This affects, for example, title bars, menus, and icon texts.

Optimizations for windowed games improves gaming on your PC by using a new presentation model for DirectX 10 and DirectX 11 games that appear in a window or in a borderless window.

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.