Excel - how to rank by multiple criteria and priority?

Hallo Steven,
hier findest du Lösungsansätze:
HOW TO: Use Mail Merge to Create a List Sorted by Category in Word 2000 - Microsoft Support
https://www.youtube.com/watch?v=MIfid43hlHw
Group multiple rows from Excel to Word - Mail Merge (msofficeforums.com)
Graham Mayor stellt ein Add-In zur Verfügung:
Merge Many To One (gmayor.com)
Viele Grüße
Lisa

Yes, it is possible to create dynamic filters for a SharePoint list view that will automatically update the calendar view to show only the items that meet the filter criteria. You can do this by using the Filter option in the list view settings.
To create a dynamic filter for your list view, follow these steps:

1. Open the list in SharePoint and switch to the view you want to filter.
2. Click on the gear icon in the top right corner of the page and select “List settings” from the drop-down menu.
3. Scroll down to the “Views” section and click on the name of the view you want to filter.
4. In the “Filter” section, select “Show items only when the following is true” and set up your filter criteria using the available fields and operators.
5. Click “OK” to save your changes.
   

Once you’ve set up your dynamic filter, the calendar view will automatically update to show only the items that meet your filter criteria. You can change or remove the filter at any time by going back to the list view settings and modifying your filter criteria.

Hallo Andreas,

ist so in Word/Seriendruck nicht vorgesehen. Hier zwei Seiten, die sich mit dem Thema beschäftigen:



"How to Use Mail Merge to Create a List Sorted by Category"

http://support.microsoft.com/default.aspx?scid=kb;en-us;181730



"Special Merges / Multiple items per condition"

http://homepage.swissonline.ch/cindymeister/MergFram.htm



Viele Grüße von der CeBIT

Lisa [MS MVP Word]

Hallo Susanne,

[Word 2010, Excel 2010] ich soll folgendes Dokument mit Seriendruck erstellen:

Oben: Ein Name - einmal

dann eine Liste von Waren (Name der Ware, Anzahl, Preis) und unten nochmal ein Datum.

das ist kein einfaches Unterfangen, da Word eine Gruppierung im Seriendruck nicht vorsieht. Schau dir mal folgende Artikel an:

"How to Use Mail Merge to Create a List Sorted by Category":
http://support.microsoft.com/kb/211303/en-us

"Special Merges / Multiple items per condition":
http://homepage.swissonline.ch/cindymeister/MergFram.htm

Viele Grüße

Lisa [MS MVP Word]

Im Admin Panel steht untenstehendes.

Tatsächlich hat bei mir geholfen: Outlook schließen. Word öffnen. Dort abmelden. Word schließen. Outlook öffnen.

Title: Outlook client connectivity issues in specific scenarios

User Impact: Users with multiple enterprise sign-in accounts can't connect to Exchange Online via the Outlook desktop client. More info: Further investigation shows that this issue is specific to users with
multiple related and trusted Enterprise log-in accounts across Microsoft 365 and Windows. If you have users experiencing issues connecting to the service or impact outside of what is described, please submit a ticket with support. Users experiencing this problem
will see the Outlook desktop client showing as disconnected and may receive the following error when attempting to send mail: "Sending and receiving reported error (0x80040115). The connection to the Microsoft Exchange Server is unavailable. Outlook must be
online or connected to complete this action." Users may be able to leverage one of the following options to circumvent impact for this event: - Affected users may be able to use Outlook on the web or mobile clients to access their mailboxes. - Additionally,
users may be able to restore access by forcing new authentication to all office apps as noted below: 1) Close Outlook and other Office applications. 2) Open an Office desktop application, such as Word, PowerPoint or Excel. 3) Navigate to File > Account > Switch
accounts, and then click the ellipsis next to the account that's not having the problem. 4) Click Sign out and then OK. *Note: Users that have multiple accounts may find it difficult to determine which account to sign out of; though, they should be able to
sign back in later if there is an issue with this process. 5) Close the Office application used for this process and re-start the Outlook desktop client. 6) When prompted for a password, click "sign in to a different account" and enter the correct information.
- Lastly, affected users may be able to restore access by creating a new Outlook profile, further instructions can be found via the following link. https://support.office.com/en-us/article/overview-of-outlook-e-mail-profiles-9073a8ac-c3d6-421d-b5b9-fcedff7642fc
Although we acknowledge that these workarounds may not be viable for all users, we're committed to providing potential solutions to improve the end-user experience. If you would like to provide feedback on these workarounds, using a non-mobile device, please
rate this post and submit it in the text box. Current status: We’ve finished installing and enabling the focused telemetry. The data gathered from this telemetry will help identify instances of service errors specific to the Outlook desktop client, which will
be analyzed to determine if any recent client-specific changes led to this event. Concurrently, we’re implementing a set of reproduction experiments in our test environment to better isolate the specific criteria causing the incorrect user authentication token
to be delivered when connecting to Exchange Online via the Outlook desktop client. Scope of impact: Users may experience this issue if they operate multiple related and trusted Enterprise log-in accounts across Microsoft 365 and Windows. Root cause: A desktop
client-specific issue that occurs for users with multiple accounts is causing the incorrect authentication token from those accounts to be delivered to our systems when connecting to the Exchange Online service.
Next update by: Friday, August 2, 2019, at 7:00 PM UTC