Count unique values among duplicates - Microsoft Support
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 ...
Applies To:
Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel for the web, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016, Office for business, Microsoft Office
Beheben von OneDrive Synchronisierungsproblemen - Microsoft-Support
Kontaktieren Sie den Support Hilfe zu Ihrem Microsoft-Konto und Ihren Abonnements finden Sie unter Konto & Abrechnungshilfe.. Für technischen Support wechseln Sie zu Microsoft-Support kontaktieren, geben Sie Ihr Problem ein, und wählen Sie Hilfe erhalten aus. Wenn Sie weitere Hilfe benötigen, wählen Sie Support kontaktieren aus, um zur besten Supportoption geroutet zu werden.
Applies To:
OneDrive for Business 24, OneDrive for Business, SharePoint Server Subscription Edition, SharePoint Server 2019, SharePoint Server 2016, SharePoint Server 2013 Enterprise, SharePoint in Microsoft 365, Office for business, Office 365 Small Business, Microsoft 365 admin, OneDrive (work or school), OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows, SharePoint admin center, SharePoint in Microsoft 365 Small Business
Gliedern (Gruppieren) von Daten in einem Arbeitsblatt
Wichtig: Wenn Sie die Gruppierung einer Gliederung aufheben, während die Detaildaten ausgeblendet sind, bleiben die Detailzeilen möglicherweise ausgeblendet.Wenn Sie die Daten anzeigen möchten, markieren Sie die sichtbaren Zeilennummern neben den ausgeblendeten Zeilen. Wechseln Sie dann zu Start > Zellen > Format, zeigen Sie auf & Einblenden ausblenden, und wählen Sie dann Zeilen ...
Applies To:
Excel for Microsoft 365, Excel for the web, Excel 2024, Excel 2021, Excel 2019, Excel 2016
Connect to a VPN in Windows - Microsoft Support
Whether it's for work or personal use, you can connect to a virtual private network (VPN) on your Windows device. A VPN connection can help provide a more secure connection and access to your company's network and the internet, for example, when you’re working from a coffee shop or similar public place.
Importieren oder Exportieren von Textdateien (TXT oder CSV)
Hinweis: Wenn in Excel eine CSV-Datei geöffnet wird, werden die aktuellen Standardeinstellungen für das Datenformat verwendet, um zu interpretieren, wie die einzelnen Datenspalten importiert werden müssen.Wenn Sie beim Konvertieren von Spalten in unterschiedliche Datenformate ein größeres Maß an Flexibilität wünschen, können Sie den Textimport-Assistenten verwenden.
Applies To:
Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, Excel 2016, My Office for iPhone, Office.com
Add hyperlinks to a location within the same document
Select Add. Apply a heading style to the bookmark. You must apply a heading style your new bookmark. Heading styles are used for identifying linkable destinations.
Applies To:
Word 2013
How to add an account in OneDrive - Microsoft Support
To add a personal or work/school account to OneDrive on your pc. Open OneDrive settings (select the OneDrive cloud icon in your notification area, and then select the OneDrive Help and Settings icon then Settings.). Go to the Account tab. Select Add an account.
Applies To:
OneDrive for Business 24, OneDrive for Business, Office for business, OneDrive (work or school), Microsoft Office, OneDrive (home or personal), OneDrive (work or school) operated by 21Vianet, OneDrive for Mac, OneDrive for Windows
Create a new presentation with Copilot in PowerPoint
Select Send and Copilot will draft a presentation for you!. Edit the presentation to suit your needs, ask Copilot to add a slide, organize your presentation, or add images.. Best practices when creating a presentation from a Word document Leverage Word Styles to help Copilot understand the structure of your document
Applies To:
PowerPoint for Microsoft 365, PowerPoint for Microsoft 365 for Mac, Office for business, Microsoft 365 admin, PowerPoint for iPad, Microsoft Office
Office 2024 and Office LTSC 2024 FAQ - Microsoft Support
Microsoft 365 Apps for enterprise delivers premium versions of apps like Word, Excel, PowerPoint, and Outlook, enhanced real-time collaboration, AI-driven automation, and cloud-backed security and compliance capabilities that are not available in the classic version of the apps included with Office LTSC. Microsoft 365 apps can be installed on up to 5 PCs or Macs, 5 tablets, and 5 phones per ...
Applies To:
Office 2024, Office 2024 for Mac
Adjust privacy settings in Microsoft Edge - Microsoft Support
Microsoft Edge is designed to detect and block known trackers. We let you decide what trackers to block. You can choose from three levels of tracking prevention: Basic, Balanced, and Strict.
Applies To:
Microsoft Edge