SVERWEIS (Funktion) - Microsoft-Support
Argumentname. Beschreibung. Suchkriterium (erforderlich). Der Wert, nach dem Sie suchen möchten. Der gesuchte Wert muss sich in der ersten Spalte des Zellbereichs befinden, den Sie im Matrix-Argument angeben.. Wenn die Matrix z. B. die Zellen B2:D7 umfasst, muss sich das Suchkriterium in Spalte B befinden.. Das Suchkriterium kann ein Wert oder ein Bezug auf eine Zelle sein.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2019 for Mac, Excel 2016
How do I reassign hot keys for my keyboard? - Microsoft Support
Note: The options listed in this wizard vary depending on the key selected.For example, since you cannot reassign the Windows key, the only option available is to disable it.
Zip and unzip files - Microsoft Support
Press and hold (or right-click) the file or folder, select (or point to) Send to, and then select Compressed (zipped) folder. A new zipped folder with the same name is created in the same location.
View and delete your browsing history in Internet Explorer
Select the History tab, and choose how you want to view your history by selecting a filter from the menu.To delete specific sites, right-click a site from any of these lists and then select Delete.Or, return to a page by selecting any site in the list.
Use a link or code to join a team in Microsoft Teams
Use a code. Select Teams on the left side of the app, then select Create and join teams and channels at the top of your teams list.
Applies To: Microsoft Teams
Microsoft Store & billing help
Get Microsoft billing support. Find help with Microsoft Store purchases, subscriptions, refunds, payment options, and checking your order history.
Learn about encrypted messages in Outlook.com
If you choose the Do Not Forward option, there are two possibilities:. Microsoft Office attachments such as Word, Excel or PowerPoint files remain encrypted even after they’re downloaded. This means that if the recipient downloads the attachment and sends it to someone else, the person they forwarded it to won’t be able to open the attachment because they don’t have permission to open it.
Applies To: Outlook.com
UNIQUE function - Microsoft Support
Examples. Example 1. This example uses SORT and UNIQUE together to return a unique list of names in ascending order. Example 2. This example has the exactly_once argument set to TRUE, and the function returns only those customers who have had service one time.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2021, Excel 2021 for Mac, Excel for iPad, Excel for iPhone, Excel for Android tablets, Excel for Android phones
Analyze Data in Excel - Microsoft Support
Analyze Data in Excel empowers you to understand your data through high-level visual summaries, trends, and patterns. Simply click a cell in a data range, and then click the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane.
Applies To: Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web
User account access in Windows - Microsoft Support
Locking your Windows device allows you to quickly secure your device while keeping your applications and files open in the background. When you lock your device, anyone trying to access it must enter your password, PIN, or use biometric authentication if you have Windows Hello set up.