Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

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

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

On the Email tab, choose your account (profile), and then choose Repair.

PowerPoint for the web supports changing case. See the procedure below. Word for the web doesn't support changing case. Use the desktop application to open the document and change text case there, or else you can manually change the casing of text in Word for the web.

Get started with basic tasks in Excel such as opening a workbook, entering and formatting data, calculating data, and trying some quick analysis features..

Do one of the following: If you've never used Easy Connect, select Use Easy Connect.. If you've used Easy Connect before, select your helper’s contact name. To invite someone who isn't on your contact list, select Invite someone to help you.

If you want to give access to desktop apps, make sure that Let desktop apps access your microphone is turned on.You can't turn off microphone access for individual apps. Others can't hear me. Try the following solutions:

Tip: If you're a Microsoft 365 Family or Personal subscriber you get Microsoft Defender, our advanced security software for Windows, Mac, iOS, and Android, as part of your subscription.Learn more at Getting started with Microsoft Defender.

Things to try first. Try these things first to help you fix or narrow down the connection problem. Run Get Help to troubleshoot and fix common connection problems. Right click the network icon in the right side of the taskbar and select Diagnose network problems or open Get Help for Network & Internet