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 ("").

Problembeschreibung. Ihr CD- oder DVD-Laufwerk wird nicht im Datei-Explorer („Windows-Explorer“ in Windows 7 und älteren Windows-Versionen) angezeigt, und das Gerät ist im Geräte-Manager mit einem gelben Ausrufezeichen markiert.

Try it! OneDrive gives you one place to store, share, and sync your work or school files. As part of your organization's Microsoft 365 subscription, or SharePoint Server, you can save your files in OneDrive and then work with them from almost any device.

Get more information about managing your Xbox subscriptions, issues with billing, and more.

To go passwordless, you can use the Settings app. In the Settings app on your Windows device, select Accounts > Sign-in options or use the following shortcut:. Sign-in options. Under Additional settings, turn on the option For improved security, only allow Windows Hello sign-in for Microsoft accounts on this device

Use a combination of the IF, SUM, FREQUENCY, MATCH, and LEN functions to do this task:. Assign a value of 1 to each true condition by using the IF function.. Add the total by using the SUM function.. Count the number of unique values by using the FREQUENCY function. The FREQUENCY function ignores text and zero values. For the first occurrence of a specific value, this function returns a number ...

Sometimes a file can be damaged in such a way that Word, Excel, or PowerPoint can't open it normally. But all is not lost. The Open and Repair command might be able to recover your file.. Click File > Open > Browse and then go to the location or folder where the document (Word), workbook (Excel), or presentation (PowerPoint) is stored. Don't try to open the file from the Recent section as this ...

To find your device name you can use one of the following methods: In the Settings app on your Windows device, select System > About Right-click on Start and select Settings. Use the following link: About. The device name is listed at the top of the page.

You're using add-ins with Outlook, Excel, or other Office apps. While 32-bit applications can work with add-ins, they can use up a system's available virtual address space. With 64-bit apps, you have up to 128 TB of virtual address space which the app and any add-ins running the same process can share. With 32-bit apps, you might get as little ...

Learn how Microsoft 365 Copilot empowers you to enhance your skills and boost productivity using the power of AI, helping you work smarter and achieve more efficiently.