Type of Range: The AGGREGATE function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges.

Use Sweep to quickly delete unwanted email in your Inbox. Sweep gives you options to automatically delete all incoming email from a particular sender, to keep only the latest email, or to delete email older than 10 days.

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.

If you don't have meeting scheduling capability in Outlook or Teams, starting an instant meeting is a great option. Just like with scheduled meetings, everyone who attends your meeting will continue to have access to the meeting chat, the recording, and anything else people share in the meeting (like files and meeting notes), even after the meeting ends.

Note: If a compatibility issue has been identified on your device that would disrupt your experience using Windows 11, we will temporarily delay your upgrade until the issue is resolved.Compatibility safeguard holds help ensure you have the best experience possible when upgrading and your productivity is not disrupted if critical apps or drivers are not yet compatible.

Get help and learn how to use Skype with Microsoft's official support page.

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

This article describes the Microsoft .NET Framework 4.7.1 offline installer for Windows 7 Service Pack 1 (SP1), Windows 8.1, Windows 10 Anniversary Update, Windows 10 Creators Update, Windows Server 2008 R2 SP1, Windows Server 2012, Windows Server 2012 R2, and Windows Server 2016.

Training: Learn how to get up and productive quickly with this Microsoft Teams Quick Start. Sign in to Teams, select Teams and Channels, reply to conversation threads, @mention someone, use emojis and stickers, and ask T-Bot questions.

Approach. Formula. 1. Reference just the lookup values you are interested in. This style of formula will return a dynamic array, but does not work with Excel tables. =VLOOKUP(A2:A7,A:C,2,FALSE)2. Reference just the value on the same row, and then copy the formula down.